Advanced MS Excel

Overview

The objective of this program is to empower participants with advanced Microsoft Excel skills, enabling them to enhance their ability to analyze data, generate comprehensive financial reports, and build effective financial models. Participants will learn how to apply conditional formatting, utilize pivot tables, perform scenario analyses, and leverage advanced Excel functions to optimize decision-making processes. The program aims to equip professionals with the tools to transform data into actionable insights, supporting strategic planning and data-driven decision-making.

Main Topics:

• Introducing the Course
• Advanced Excel Option
• Using & customizing Autocorrect
• Creating Custom Number Formats
• Secret of Excel
• Advanced Format as Table
• Using Conditional Formatting
• Conditional Formatting with Formulas
• Using the Advanced Filter Feature
• Creating and Modifying List Ranges
• Grouping and Outlining Data
• Logical functions (IF, IFS,)
• Addition and counting functions according to a condition (sum, sum if, SUMIFS, count, count if, COUNTIFS)
• Text Functions (Upper, Lower, Proper, Left, Mid, Right, Trim, Len)
• Date and Time Functions (Today, Now, Day, Month, Year)
• Advanced functions.
• Advanced Paste Special Techniques
• Flash fill.
• Using Financial function
• Merge options.
• Auditing Worksheets and Performing What-If Analyses
• Using Scenarios
• Compile financial data using a tool consolidate.
• Analyze data using
• Data Validation Tools
• Data Validation with Function