Professional Diploma in Microsoft Excel 2010

Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel.Microsoft Excel 2010 is the spreadsheet application in the MS Office 2010 suite. You will begin with the fundamentals, assembling a strong foundation that will give you further knowledge as you advance into intermediate and advanced level topics. By the end of this course, you will have mastered the most important Excel 2010 tools and come out with confidence to finish any Excel assignments with proficiency and grace.

Professional Diploma in Microsoft Excel 2010 is CPD Qualification Standards & IAO accredited. This makes it perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds.

CPD

COURSE CURRICULUM

• Microsoft Excel 2010 for Beginners

• Module One - Getting Started

• Module Two - Opening and Closing Excel
• Module Three - Your First Worksheet
• Module Four - Working with Excel Files
• Module Five - Viewing Excel Data
• Module Six - Printing Excel Data
• Module Seven - Building Formulas
• Module Eight - Using Excel Functions
• Module Nine - Using Time Saving Tools
• Module Ten - Formatting Your Data
• Module Eleven - Advanced Formatting Tools
• Module Twelve - Wrapping Up

• Microsoft Excel 2010 Intermediate Level

• Module One - Getting Started

• Module Two - Working with Permissions and Options
• Module Three - Sharing Workbooks
• Module Four - Performing Advanced Formula and Function Tasks
• Module Five - Working with Array Formulas
• Module Six - Working with Functions
• Module Seven - Working with Macros
• Module Eight - Working with Forms
• Module Nine - Applying Advanced Chart Features
• Module Ten - Working with PivotTables and PivotCharts
• Module Eleven - Using the Automated Analysis Tools Add-In
• Module Twelve - Wrapping Up

• Microsoft Excel 2010 Advanced Level

• Module One - Getting Started

• Module Two - SmartArt and Objects
• Module Three - Auditing
• Module Four - Creating Charts
• Module Five - Creating Pivot Tables
• Module Six - Working with PivotTables and PivotCharts
• Module Seven - Macros
• Module Eight - Solving Formula Errors
• Module Nine - Using What-If Analysis
• Module Ten - Managing Your Data
• Module Eleven - Grouping and Outlining Data
• Module Twelve - Wrapping Up

• Activities

• Activities-Accredited Microsoft Excel 2010 for Beginners

• Activities-Microsoft Excel 2010 Intermediate Level

• Activities-Certified Microsoft Excel 2010 Advanced Level

• Why You Should Choose Professional Diploma in Microsoft Excel 2010

• Lifetime access to the course

• No hidden fees or exam charges
• Full Tutor support on weekdays (Monday - Friday)
• Efficient exam system, assessment and instant results
• Download Printable PDF certificate immediately after completion
• Obtain the original print copy of your certificate, dispatch the next working day for as little as GBP9.
• Improve your chance of gaining professional skills and better earning potential.

We understand more than anyone how important it is for you to get the right qualifications and at the right time. We also understand that when you have a lot to do, you might not always have the time free to go and attend college or even university. That is why we created this site, so you can take all of the time you need to learn more about your chosen topics as well as being able to do the whole thing from home.

We believe in empowering the people of today, by offering them opportunities to expand and extend their knowledge and skillset as well as giving them the help and support they need to achieve great things. With thousands of courses available and a team who will do just about anything for you, it is safe to say that you won’t find a better course provider on the internet and we would love to work with you to make sure that you get the best experience and best result out of your education.