ELEV-FP 007: Microsoft Office Specialist (MOS) – Excel Expert

ELEV-FP 007: Microsoft Office Specialist (MOS) – Excel Expert

Course Number: ELEV-FP 007

Duration: One day

Course Description:

For professionals in roles such as accountants, financial analysts, and commercial bankers, advanced Excel skills are essential. Microsoft Office Specialist (MOS) – Excel Expert provides learners with an in-depth understanding of the Microsoft Excel environment, enabling them to fully utilize advanced features and guide others effectively. This course focuses on creating, managing, and distributing professional spreadsheets for specialized purposes, including custom business templates, multi-axis financial charts, amortization tables, and inventory schedules. Learners will also customize their Excel environment to improve efficiency and productivity on complex projects.

By the end of this course, learners should be able to:

• Customize workbook options and Excel environments
• Create and manage advanced formulas and functions
• Apply complex data formats, validation, and conditional logic
• Analyze data using advanced tools and business intelligence features
• Design and manage advanced charts, PivotTables, and PivotCharts

Course Modules:

Module One: Manage Workbook Options and Settings

• Save workbooks as templates
• Manage document versions
• Reference data between workbooks
• Enable macros and customize the ribbon
• Protect and encrypt workbooks
• Restrict editing and configure formula options

Module Two: Apply Custom Data Formats and Layouts

• Create custom number formats and populate cells efficiently
• Configure data validation
• Implement advanced conditional formatting and filtering
• Create and modify custom workbook elements
• Prepare workbooks for international use

Module Three: Create Advanced Formulas

• Apply complex functions in formulas
• Perform logical and statistical operations
• Use lookup functions
• Apply advanced date and time functions
• Conduct data analysis and business intelligence
• Troubleshoot formulas and define named ranges and objects

Module Four: Create Advanced Charts and Tables

• Enhance charts with trend lines and dual axes
• Create and manage PivotTables and PivotCharts
• Reference data effectively in PivotTables
• Apply styles to PivotCharts
• Drill down into PivotChart details

Microsoft Office Specialist (MOS) – Excel Expert equips learners with the advanced skills needed to excel in complex financial and analytical roles while maximizing the power of Excel. Join now to deepen your Excel expertise and confidently tackle advanced data analysis and reporting challenges.