Microsoft Excel Complete Diploma

Course details

Save hours of work with expertise in automation and data analysis skills. Decode all the secrets of Microsoft Excel to enter the job market, which starts from £26,334 per year. Make a strong portfolio on Microsoft Excel with this Online Microsoft Excel Master Certification Bundle.
As you begin the course, you will gain expertise in spreadsheet management. You will learn lessons to help you create formulas and functions and use them to analyse data. The module on Data Manipulation will let you explore data cleaning, sorting, text-to-columns, and data grouping to increase workplace productivity. Plus, you will gain insights on Check, Font, and Cell Style. By the end of module 7, you will have the customisation skills of Excel.
Streamlining the workflow and securing the spreadsheet mastery will become easy for you as you master the Templates and File Protection. A good manager knows how to present data most appealingly, and expertise in tables, data objects, and graphical elements will pave the way for that. From modules 11 to 15, you will learn Excel Advanced. Here, you become familiar with Workbook Properties and Macros, Format and validate Data, Data Lists, and Workbooks. Take your productivity level to a higher level with learning modules 16 & 17. These two modules will power you up to create & manipulate worksheets using VBA and conduct automation tasks in Excel. The final module of the bundle focuses on PowerPivot.
Learning outcome:

• Gain proficiency in spreadsheet management
• Ability to create and use Excel formulas and functions to carry out calculations & data analysis
• Acquire the skills to manipulate, sorting, and filtering data
• Learn advanced data analysis
• Explore and discover the techniques to customise Excel
• Master tools like macros and VBA to increase productivity

Course Curriculum:
Excel Beginner

• Module 01: Introduction to Excel
• Module 02: Formulas and Functions
• Module 03: Data Manipulation
• Module 04: Spell Check and Fonts
• Module 05: Cells
• Module 06: Cell Style
• Module 07: Customization

Excel Intermediate

• Module 08: Use of Specialized,Text, Logical, Date and Financial Functions
• Module 09: Table, Data and Graphical Objects
• Module 10: Templates and File Protection

Excel Advanced

• Module 11: Workbook Properties and Macro
• Module 12: Formatting, Validation and Trace Cells
• Module 13: Data list, Scenarios and What-If Analysis
• Module 14: Interactive and Consolidated Data
• Module 15: Cells Linking, Workbooks and Web Query

Excel VBA

• Module 16: Macro Recorder
• Module 17: Worksheets

Excel PowerPivot

• Module 18: PowerPivot
• Module 19: PivotTables, Charts and DAX Functions

Excel Templates

• Activities and Exercise Files

Updated on 17 October, 2023