Certified Diploma in Microsoft Excel - CPD Certified

COURSE CURRICULUM

Microsoft Excel for Beginners

• Module One – Getting Started
• Module Two – Opening 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

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