Read more
2Month/20 Hours Price:20,000
15,000
Microsoft Excel – Advanced Excel Formulas & Functions
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 functionsStatistical 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 ExcelData 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
Stay connected even when you’re apart
Join our WhatsApp Channel – Get discount offers
500+ Free Certification Exam Practice Question and Answers
Your FREE eLEARNING Courses (Click Here)
Internships, Freelance and Full-Time Work opportunities
Join Internships and Referral Program (click for details)
Work as Freelancer or Full-Time Employee (click for details)
Hire an Intern
Flexible Class Option
Week End Classes For Professionals SAT | SUN
Corporate Group Training Availables Options
Online Classes – Live Virtual Class (L.V.C), Online Training
Related Courses
Computerized Accounting Course
0 Reviews