Microsoft Excel Course | Learn Advanced Excel Formulas & Dashboards

Microsoft Excel is the world’s most widely used spreadsheet software, essential for professionals across every industry. From basic data entry and formatting to advanced reporting, analysis, automation, and dashboard creation, Excel is the go-to tool for data-driven decision-making.

This comprehensive Excel course is designed to take you from foundational skills to expert-level techniques. Whether you're a beginner or a working professional, this course helps you build real-world Excel expertise used in accounting, finance, data analysis, HR, operations, and more.

Education introduction

Section 1

Part 1
- Overview of the Basics of Excel
  - An Overview of the Screen, navigation and Basic Spreadsheet concepts
  - Excel Hierarchy
  - Mathematical and Statistical
  - Various data selection techniques of Data
  - Excel shortcut keys
  - Grouping and Ungrouping of Sheets
  - Range and Cell
  - Cell Referencing/Freezing Concept
  - Protecting and un-protecting worksheets and cells
- Mathematical Functions in Advanced Excel
  - Sum, Sumif, Sumifs
  - Count, Counta, Countblank, Countif, Countifs
  - Average, Averagea, Averageif, Averageifs
  - Subtotal, Aggregate
  - Rand, Randbetween
  - Round, Roundup, Rounddown
  - SumProduct
  - DCount, DCountA, DSum, DAverage
- Date and Time Functions in Advanced Excel
  - Date, Day, Month, Year
  - EDate, EOMonth
  - Networkdays, Networkdays.INTL
  - Workday, Workday.INTL
  - Weeknum, Weekday
  - Hour, Minute, Second
  - Now, Today, Time
- Text Functions and Data Validation in Advanced Excel
  - Char, Clean, Code
  - Concatenate, Find, Search, Substitute, Replace
  - Len, Right, Left, Mid
  - Lower, Upper, Proper, Text, Trim, Value
  - Large, Small
  - Filters (Basic, Advanced, Conditional)
  - Data Sort (Ascending, Descending, Cell/Font Color)
  - Conditional Formatting
  - Data Validation, Dependent Validation
  - Group and Ungroup
  - Data split
- Statistical and Other Functions in Advanced Excel
  - Max, Min, Median
  - Len, Right, Left, Mid
  - Maxa, Maxifs
  - Minifs, Mina
  - Vara, Correl, Geomen, Slope, Forecast
- Logical Functions in Advanced Excel
  - IF, Nested IF
  - AND, OR, NOT
  - ISNA, ISBLANK, ISERR, ISERROR
  - ISEVEN, ISODD
  - ISLOGICAL, ISTEXT, ISNUMBER
  - Other logical operators
  - Truth Table
- Lookup and Reference Functions in Advanced Excel
  - Lookup, Vlookup, Hlookup
  - Index, Match
  - Offset, Indirect, Address
  - Column, Columns, Row, Rows
  - Choose
  - Arrays Concept in Lookup Formula’s
  - Paste Special, Paste link
  - Hyperlink
  - Insert object in Excel (Excel, Notepad, Access, Email, Image, etc.)

Section 2

Part 2
- Working with Reports in Advanced Excel
  - Pivot Tables
  - Golden Rule of Pivot Table
  - Grouping and Ungrouping in Pivot
  - Calculated fields in Pivot
  - Slicer in Pivot
  - Slicer Formatting
  - Dynamic Pivot
  - Pivot Data Model
  - Formatting and customizing
  - Advanced options of Pivot tables
  - Consolidated pivot tables
  - Show values As in pivot
- Data Analysis and Visualization
  - Power Pivot
  - What-if Analysis
  - Data Table – One Variable and Two Variables
  - Data Analysis Using Statistics
  - Descriptive Statistics
  - ANOVA
  - Moving Average
  - Testing Hypothesis
  - Measuring Covariance and Correlation
  - Distribution
  - Regression
  - Graphs and Charts
  - Analysis Tool Pack
  - Solver
  - Histogram
  - Pareto
  - Water Fall
  - Import and Export data
  - Worksheet formatting and Print Display
- Data Collection Method in Advanced Excel
  - Import data from web browser
  - Import data from MS-Access
  - Import data from Text file
  - Import data from SQL Server
  - Import data from other data sources as well
- Analysis Single/Multidimensional Analysis in Advanced Excel
  - Three Dimensional (3D) Tables
  - Sensitivity Analysis like Data Table
  - Manual What-If Analysis
  - Threshold Values
  - Goal Seek
  - One-Variable Data Table
  - Two-Variable Data Table
  - Solver
  - Histogram
- Data Analysis and Visualization (Charts)
  - Charts Overview
  - Charts Description
  - Create charts like Column, Line, Pie, Bar, Combo, Area, Bubble, Scatter etc.
  - Formatting Charts
  - Using 3D Graphs
  - Using Secondary Axis in Graphs
  - Sharing Charts with PowerPoint / MS Word
  - Dynamic Chart updates (Data Modified in Excel, Chart would automatically get updated)
- Advanced Dashboard in Excel
  - Dashboard using Active X Form Controls
  - Create Interactive Dashboard using Option Button, Scroll Bar, Check Box, Combo Box
  - Form Controls for reports automation
- Two Live Report Development in Advanced Excel (Real World Data)

ASHOK KUMAR

Founder & CEO

More than 16 Year Working experience in testing with CMM level orgranizations i.e Sapient, Saxo Bank, IBM & Fareportal. Currently working as Enterpreneur with Askme Technologies & driving training vertical Askme Training. Involved in setting up of manual, automation testing and Agile teams. Implemented various automation projects using Selenium, QTP, SOAP UI & JMeter etc. Trained thousands of students for Manual Testing, ISTQB Certification, Agile Testing,QTP & Selenium. Conducted various Online trainings, corporate trainings, College trainings and face to face trainings across the Globe.

Price Rs 8000
Duration40 Hours
Batch weekdays
Event Category Development
Mode: offline
Websitewww.askmetraining.in

Book now

Advantages for you through AskMeTraining

Grouped requests in a batch format

WEEKDAYS

02 Jul, 2024

Take class during weekdays and utilize your weekend for practice.

Get regular training by Industry Experts.

Get Proper guidance on certifications.

FASTRACK

31 Jul, 2024

Running lack of time? Join Fastrack classes to speed up your career growth.

Materials and guidance on certifications

WEEKDAYS

25 Jun, 2024

Take class during weekdays and utilize your weekend for practice.

Get regular training by Industry Experts.

Get Proper guidance on certifications.

Do the timings not align with your schedule?

We can schedule a session at a time that works best for you.

Master Microsoft Excel – Advanced Formulas, Dashboards & Data Analysis

Mobile Automation Testing Course Using Appium

Instructor:

Categories:

Duration

Education introduction

Section 1

Section 2

ASHOK KUMAR

Related Courses

Python with Django

Full Stack Development

React JS Development

HTML Development

Node.js Development

Power BI

Macro and VBA

Power Automate Desktop

Grouped requests in a batch format

Grouped requests in a batch format

Do the timings not align with your schedule?

Real-life Case Studies

Assignment

Lifetime Access

24 x 7 Expert Support

Certification