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
Job Interview Preparation (Soft Skills Questions & Answers)
- Tough Open-Ended Job Interview Questions
- What to Wear for Best Job Interview Attire
- Job Interview Question- What are You Passionate About?
- How to Prepare for a Job Promotion Interview
🎥 Your FREE eLEARNING Courses (Click Here)
Internships, Freelance and Full-Time Work opportunities
Flexible Class Options
- Week End Classes For Professionals SAT | SUN
- Corporate Group Trainings Available
- Online Classes – Live Virtual Class (L.V.C), Online Training
Related Courses
Computerized Accounting Course
Microsoft Certified Solutions Associate (MCSA) Office 365