Master Excel - Beginner to Advanced

English + Hindi
Batch Size
Request Training Proposal

Course Contents

The training will help you discover a whole new set of Excel functionalities which can be applied to day-to-day tasks to save time and effort to a great extent. Learn a whole new range of Excel formula like Text, Index, Match, Nested-If and many more powerful Excel Functions.

  • Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch.
  • Automate, streamline, and completely revolutionize your workflow with Excel.
  • Master unique tips and tools.
  • Over 30 formula covered in details.
  • Go rogue and design your own formula-based Excel formatting rules.
  • Discover multiple functionalities in Excel like LOOKUP, INDEX & MATCH functions and many more.
  • Manipulate dates, times, text.
  • Automate tedious and time-consuming tasks using cell formulas and functions in Excel (no VBA required!).

Tentatively over 2 months

Module 1: Let’s Start with some basics - Working with Basic excel functions

  1. Working with the SUM() Function
  2. Working with the MIN() and MAX() Functions
  3. Working with the AVERAGE() Function
  4. Working with the COUNT() Function
  5. Adjacent Cells Error in Excel Calculations
  6. Using the AutoSum Command
  7. Excel AutoSum Shortcut Key
  8. Using the AutoFill Command to Copy Formulas
  9. How Subtotals function can save you time
  10. Absolute vs Relative cell Referencing

Module 2: Data Cleanup with Excel

Sub-Module 1: Formatting Data into Excel Workbook

  1. Working with Font Formatting Commands
  2. Changing the Background Color of a Cell
  3. Adding Borders to Cells
  4. Formatting Data as Currency Values

Sub-Module 2: Working with large sets

  1. Formatting Percentages
  2. Using Excel's Format Painter
  3. Creating Styles to Format Data
  4. Merging and Centering Cells
  5. Using Conditional Formatting

Module 3: Advance Formulas for quick and dynamic analysis

  1. Formula #1 - SUMIFS, COUNTIFS, AVERAGEIFS to Account for Exceptions
  2. Formula #2 - IF (Nested Functions) Because Data Analysis is Often Not Simple
  3. Formula #3 - IFERROR for Credible Reports
  4. Formula #4 - VLOOKUP For Dynamic Lookups
  5. Formula #5 - INDEX & MATCH for Flexible Lookups

Module 4: Some more Advanced Formulas to master

  1. Formula #6 - AVERAGEIFS
  2. Formula #7 - Excel's Top Date Functions
  3. Formula #8 - OFFSET for Dynamic Calculations
  4. Formula #9 - FREQUENCY, SMALL & LARGE to Organize and Rank
  5. Formula #10 - SUMPRODUCT For the experts

Module 5: Continuation of Advance Formula Marathon with Case Study

  1. YTD Calculations - SUM, SUMPRODUCT & OFFSET
  2. 3 Ways to Lookup within Boundaries - SUMIFS, SUMPRODUCT & INDEX
  3. Sum Alternate Columns based on Selection - SUMIFS & INDEX
  4. Sum Alternate Columns – SUMPRODUCT

Module 6: Learn to Excel some cool Data Validation rules and text

Sub-Module 1: Excel Data Validation

  1. Creating an Excel Data Validation List
  2. Excel Decimal Data Validation
  3. Adding a Custom Excel Data Validation Error
  4. Dynamic Formulas by Using Excel Data Validation Technique

Sub-Module 2: Types of error in Excel and ways to resolve them

Module 7: Excel Text Function - Working with Text function

  1. Introduction
  2. Capitalization with UPPER LOWER PROPER & TRIM
  3. Combining Text with CONCATENATE (&)
  4. Extracting Strings with LEFT MID RIGHT & LEN
  5. Converting Text to Values with TEXT & VALUE
  6. Searching Text String with SEARCH & FIND
  7. Categorizing Data with IF(ISNUMBER(SEARCH))
  8. Combining RIGHT, LEN and SEARCH
  9. Replacing Text with SUBSTITUTE

Module 8: Bonus Lecture on Formula based Formatting

  1. Introduction
  2. Creating Editing & Managing Formula-Based Rules
  3. Highlighting Rows Using the MOD Function
  4. Formatting Based on the Value of Another Cell
  5. Formatting Cells Using Stats Functions
  6. Formatting Cells Using Text Functions & Logical Operators.


Instructor Profile


Advanced Excel knowledge with success in maintaining and organizing data, including dictionaries, power pivot, power query and cross-reference indexes across a broad range of industries.

This course includes:

  • 100% Online Sessions
  • Instructor led
  • Customizable Syllabus
  • Customizable Schedule
  • Certificate of Completion
  • Training Recordings
  • Training Resources
  • Learner Assessment
Request Training Proposal

StepUpwards Training Requirement Form

Please complete this form so we can get back to you with a training proposal.

By clicking "Submit", you agree to our Terms of Use , Privacy Policy and Service Agreement

Individuals younger than 18 years of age, but of the required age for consent to use online services, as per applicable law in their country of residence may set up an account and enroll in appropriate courses through their parent or guardian. Individuals younger than the required age for consent to use online services may not use the Services offered by StepUpwards Platform. For more details, please refer to our Privacy Policy.

Related courses


Microsoft Excel VBA & Macro for Automation


Amardeep Excel4All

View Course

Microsoft Excel VBA & Macro for Costing Automation


Amardeep Excel4All

View Course

Do More with Microsoft PowerPoint


Amardeep Excel4All

View Course