Microsoft Excel Complete Diploma – Beginners, Intermediate, Advanced - CPD Certified

COURSE CURRICULUM

Microsoft Excel - Beginners

• Module One – Getting Started
• Module Two – Opening and Closing Excel
• Module Three – Working with the Interface
• Module Four – Your First Worksheet
• Module Five – Viewing Excel Data
• Module Six – Building Formulas
• Module Seven – Using Excel Functions
• Module Eight – Using Quick Analysis
• Module Nine – Formatting Your Data
• Module Ten – Using Styles, Themes, and Effects
• Module Eleven – Printing and Sharing Your Workbook
• Module Twelve – Wrapping Up
• Activities – Microsoft Excel for Beginner Learners

Microsoft Excel - 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 Macros
• Module Seven – Working With Forms
• Module Eight – Applying Advanced Chart Features
• Module Nine – Working With Slicers and Timelines
• Module Ten – Working With Multiple Tables, Relationships and External Data
• Module Eleven – Working With PowerView
• Module Twelve – Wrapping Up
• Activities- Microsoft Excel – Intermediate Level

Microsoft Excel - Advanced Level

• Module One – Getting Started
• Module Two – SmartArt and Objects
• Module Three – Auditing
• Module Four – Creating Charts
• Module Five – Working with Charts
• Module Six – Creating Pivot Tables and Pivot Charts
• 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-Microsoft Excel – Advanced Level

• Mock Exam – Microsoft Excel Complete Diploma – Beginners, Intermediate, Advanced

• Final Exam – Microsoft Excel Complete Diploma – Beginners, Intermediate, Advanced

Assessment and Certification

At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39.