Save PDFPrint

Microsoft Excel – Advanced Excel Formulas & Functions (Step-by-Step Course)

This course will give you a deep understanding of the advanced formulas and functions that transform Microsoft Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, we teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways. We will not train you to regurgitate functions and formula syntax; We will teach you how to THINK like Excel.

We’ll dive into a broad range of Microsoft Excel formulas & functions, including:

• Lookup/Reference functions
• Statistical functions
• Formula based formatting
• Date & Time functions
• Logical operators
• Array formulas
• Text functions
• Powerful analytics tools and formulas like INDIRECT, HYPERLINK, WEBSERVICE & FILTERXML

Advanced Excel Course

Course Content:

Module-I – Excel Foundation 

• Getting Started with Excel
• Data Entry, Data Editing, and Number Formatting
• Data Formatting
• Working with Cells and Ranges in Excel
• Managing Worksheets
• Using Sub-Total
• Save Your Worksheets

Module-II – Formula | Data | Charts Concepts

• Formula Basics & Cell References
• Auto Fills & Custom Lists
• Working with Basic Excel Functions
• Using Smart Tables
• Sorting & Filtering Data
• Working with Conditional Formats
• Working with Charts

Module-III –  Using Advanced Functions

• Working with Named Ranges
• Using Complex Excel Functions
• Using Multi-sheet Formulas
• Using Advanced Filters
• Data Validation & Protection
• Consolidation & List Management
• Automating with Macros

Module-III – Reporting & Dashboards 

• Business Reporting with Excel Dashboards
• Advanced Charting & Visualizations
• Using Sparkline Charts
• Creating Interactive Dashboard Reports

Module-IV – Working with Macros & Custom Functions 

• Writing Customized Macros
• Using What-If-Analysis
• Working with Financial Functions
• Creating Custom Excel Functions

International Student Fee : 150 USD

Related Courses

Computerized Accounting Course 

MS Office Complete Course 

Financial Modeling Course

Microsoft Certified Solutions Associate (MCSA) Office 365

[/vc_column_text]