Excelgoodies +1 650 491 3131

Batch starts on

th

Microsoft Excel Reporting Course

Taught by Microsoft Certified Trainers

Course Ratings

(1.5K+ Professionals enrolled)

View Schedule

This is a 15 hour (LIVE, Instructor-Led) activity-based program that covers Excel from core fundamentals to advanced techniques, including 60+ formulas, dashboards, pivots, charting, and What-If analysis. The course also helps participants apply these skills within their specific domain.

The learning methodology includes over 50 real-time assignments, an Excel shortcut tool, and post-training support to help implement the learning back at work.

Course Fee

$149

Batch Date
:

Course Duration
:
15 Hours (5 Sessions, each of 3 Hours)

Mode of Training
:
Virtual Classroom (Instructor-Led)

Certifications
:

Batch Date
Course Duration
15 Hours (5 Sessions, each of 3 Hours)
Mode of Training
Virtual Classroom (Instructor-Led)
Certifications

Re-invented Excel Learning for Power Users.

Taught by Microsoft Certified Trainers.

This is a 15-hour, activity-based program, designed to give you extensive exposure on mining, structuring and, modeling varied data to come up with the required analysis and MIS Reports using Microsoft Excel.

What's included in your training?

  • Pre-Course Assessment
  • Hands-On Instructor Led Training
  • 50+ Assignments and Real-time exercises
  • 30 Days Post Training Support (On Job)
  • Free Study material (Online Excel Help) for 30 Days

What will you be able to do post-training?

  • Have high comfort working with Excel leading to quick turnaround time
  • Use right formulas for the given scenario
  • Write Complex Formulae with ease
  • Handle Excel related situations more maturely
  • Present Data with better interpretation

Our 5 Steps Learning Process

Excel Learning Redefined.

Learn Excel

LEARN from Microsoft Certified Trainers

Practice Excel

PRACTICE with real-time Assignments

Revise Excel

REVISE with 10+ Case Studies

Speed-up Excel

SPEED-UP with our Excel Shortcut Tool

Excel On-Job Support

ON-JOB Support to implement learnings

Course Content - Overview

EXCEL INTRODUCTION :

  1. A overview of the screen, navigation and basic spreadsheet concepts
  2. Understanding workbooks, worksheets, rows, columns, cells
  3. Various selection techniques

ENTERING DATA

  1. Entering, Editing and Deleting Text, Numbers, Dates
  2. Using Auto Lists
  3. Moving and Copying data
  4. Inserting, Deleting and Hiding Rows & Columns
  5. Inserting, Deleting, Moving and Copying Sheets
  6. Using navigation techniques

CUSTOMIZING EXCEL

  1. Customizing the Ribbon
  2. Customizing the Quick Access Toolbar
  3. Using and Customizing AutoCorrect
  4. Changing Excel’s Default Options
  5. Creating a Custom AutoFill List
  6. Creating a Custom Number Format
  7. Customizing Excel Review

MANAGING AND NAVIGATING LARGE WORKBOOKS

  1. Using Workbook Views
  2. Selecting and Switching Between Worksheets
  3. Splitting and Freezing a Window
  4. Creating Headers and Footers
  5. Hiding Rows, Columns, Worksheets, and Windows
  6. Working with Multiple Workbook Windows
  7. Creating a Template
  8. Managing Workbooks Review

CREATING AND EDITING FORMULAE

  1. Concept of Formulae
  2. Creating Formulae, Editing Formulae
  3. Bodmas : Mathematical Order
  4. Copying Formulae
  5. Using Functions - Sum, Average, Max,Min, Count, Counta
  6. Applying Absolute (Fixed) Referencing

REFERENCING TECHNIQUES

  1. Relative Reference
  2. Absolute Reference
  3. Mixed Reference
  4. Moving Range Reference

FORMATTING AND PROOFING

  1. Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
  2. Basic conditional formatting
  3. Copying and Clearing Formats
  4. Working with Styles
  5. Spell Check, Find & Replace and AutoCorrect

MATHEMATICAL FUNCTIONS

  1. SumIf, SumIfs
  2. CountIf, CountIfs
  3. AverageIf, AverageIfs
  4. SumProduct, Subtotal

LOOKUP FUNCTIONS

  1. Vlookup / HLookup
  2. Match
  3. Dynamic Two Way Lookup
  4. Creating Smooth User Interface Using Lookup
  5. Offset
  6. Index
  7. Dynamic Worksheet linking using Indirect

LOGICAL FUNCTIONS

  1. Nested If ( And Conditions , Or Conditions )
  2. Alternative Solutions for Complex IF Conditions to make work simple
  3. And, Or, Not

TEXT FUNCTIONS

  1. Upper, Lower, Proper
  2. Left, Mid, Right
  3. Trim, Len
  4. Concatenate
  5. Find, Substitute

DATE AND TIME FUNCTIONS

  1. Today, Now
  2. Day, Month, Year
  3. Date, DateDif, DateAdd
  4. EOMonth, Weekday

ROUNDING FUNCTIONS

  1. Round
  2. RoundUp
  3. RoundDown
  4. MRound

ERROR HANDLING FUNCTIONS

  1. isNa
  2. isErr
  3. isError

ADVANCED PASTE SPECIAL TECHNIQUES

  1. Paste Formulas
  2. Paste Formats
  3. Paste Validations
  4. Paste Conditional Formats
  5. Add / Subtract / Multiply / Divide
  6. Merging Data using Skip Blanks
  7. Transpose Tables

SORTING

  1. Sorting on Multiple Fields
  2. Dynamic Sorting of Fields
  3. Bring Back to Ground Zero after Multiple Sorts

FILTERING

  1. Filtering on Text, Numbers & Date
  2. Filtering on Colors
  3. Copy Paste while filter is on
  4. Advanced Filters
  5. Custom AutoFilter

PRINTING WORKBOOKS

  1. Working with Themes
  2. Setting Up Print Area
  3. Printing Selection
  4. Branding with Backgrounds
  5. Adding Print Titles
  6. Fitting the print on to a specific defined size
  7. Customizing Headers & Footers

IMPORT & EXPORT OF INFORMATION

  1. From Web Page
  2. Exporting to XML
  3. Creating Dynamic Dashboards and Reports Using Data on Other Applications
  4. Using Text To Columns

WHAT IF ANALYSIS

  1. Goal Seek
  2. Scenario Analysis
  3. Data Tables

GROUPING & SUBTOTALS

DATA VALIDATION

  1. Number, Date & Time Validation
  2. Text Validation
  3. List Validation
  4. Handling Invalid Inputs
  5. Dynamic Dropdown List Creation using Data Validation

PROTECTING EXCEL

  1. File Level Protection
  2. Workbook Level Protection
  3. Sheet & Cell Level Protection
  4. Setting Permissions for Specific Tasks
  5. Track changes

CONSOLIDATION

  1. Consolidating data with identical layouts
  2. Consolidating data with different layouts
  3. Consolidating data with different Sheets

CONDITIONAL FORMATTING

  1. Creating Basic Conditional Formats
  2. Managing Conditions Created
  3. Dynamic Formatting using Formulas in Conditional Formatting

PIVOT TABLES

  1. Creating Simple Pivot Tables
  2. Basic and Advanced Value Field Setting
  3. Sorting based on Labels and Values
  4. Filtering based on Labels and Values
  5. Grouping based on numbers and Dates
  6. Drill-Down of Data
  7. GetPivotData Function
  8. Calculated Field & Calculated Items

CHARTS & PIVOT CHARTS

  1. Bar Charts / Pie Charts / Line Charts
  2. Dual Axis Charts
  3. Dynamic Charting
  4. Other Advanced Charting Techniques

EXCEL DASHBOARD

  1. Bar Charts / Pie Charts / Line Charts
  2. Planning a Dashboard
  3. Adding Tables to Dashboard
  4. Adding Charts to Dashboard
  5. Adding Dynamic Contents to Dashboard

About the Trainer

Mr. Sami

MCT, MCP, MEE, MOS

30,000+

Students Trained

18+

Year of Experience

4.9

Reviews

Mr. Sami is an exceptionally accomplished and certified Microsoft Trainer, possessing extensive expertise in the fields of Finance, HR, and Information Technology. With an impressive 14-year tenure in the industry, he has successfully trained and empowered over 23,000 professionals, and the number continues to grow.

He has undertaken assignments with the renowned IRS, The World Bank, Tata Chemicals, Buckman Laboratories, Standard Chartered, ING Barings and much more. His nature of going that Extra Mile has got him the startling popularity amongst the Excelgoodies prominent clients.

With his wealth of knowledge and dedication to delivering exceptional training experiences, Mr. Sami consistently exceeds the expectations of his clients and leaves a lasting impact on the professionals he trains.

Mr. Sami is an exceptionally accomplished and certified Microsoft Trainer, possessing extensive expertise in the fields of Finance, HR, and Information Technology. With an impressive 14-year tenure in the industry, he has successfully trained and empowered over 23,000 professionals, and the number continues to grow.

Throughout his illustrious career, Mr. Sami has collaborated with esteemed organizations such as the IRS, The World Bank, Mercedez-Benz, Comcast, Standard Chartered, and ING Barings, to name just a few. His unwavering commitment to going the extra mile has earned him a stellar reputation among Excelgoodies' prominent clients.

With his wealth of knowledge and dedication to delivering exceptional training experiences, Mr. Sami consistently exceeds the expectations of his clients and leaves a lasting impact on the professionals he trains.

Training Schedule

Available Slots

Session Date Time (ET)

Contact Us

Mr. Perrie Smith

Business Associate

Tel: +1 650 491 3131

Email: inquiry_excel@excelgoodies.com

Connect us on

Course Fee

$149

Course Content - Overview

EXCEL INTRODUCTION :

  1. A overview of the screen, navigation and basic spreadsheet concepts
  2. Understanding workbooks, worksheets, rows, columns, cells
  3. Various selection techniques

ENTERING DATA

  1. Entering, Editing and Deleting Text, Numbers, Dates
  2. Using Auto Lists
  3. Moving and Copying data
  4. Inserting, Deleting and Hiding Rows & Columns
  5. Inserting, Deleting, Moving and Copying Sheets
  6. Using navigation techniques

CUSTOMIZING EXCEL

  1. Customizing the Ribbon
  2. Customizing the Quick Access Toolbar
  3. Using and Customizing AutoCorrect
  4. Changing Excel’s Default Options
  5. Creating a Custom AutoFill List
  6. Creating a Custom Number Format
  7. Customizing Excel Review

MANAGING AND NAVIGATING LARGE WORKBOOKS

  1. Using Workbook Views
  2. Selecting and Switching Between Worksheets
  3. Splitting and Freezing a Window
  4. Creating Headers and Footers
  5. Hiding Rows, Columns, Worksheets, and Windows
  6. Working with Multiple Workbook Windows
  7. Creating a Template
  8. Managing Workbooks Review

CREATING AND EDITING FORMULAE

  1. Concept of Formulae
  2. Creating Formulae, Editing Formulae
  3. Bodmas : Mathematical Order
  4. Copying Formulae
  5. Using Functions - Sum, Average, Max,Min, Count, Counta
  6. Applying Absolute (Fixed) Referencing

REFERENCING TECHNIQUES

  1. Relative Reference
  2. Absolute Reference
  3. Mixed Reference
  4. Moving Range Reference

FORMATTING AND PROOFING

  1. Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
  2. Basic conditional formatting
  3. Copying and Clearing Formats
  4. Working with Styles
  5. Spell Check, Find & Replace and AutoCorrect

MATHEMATICAL FUNCTIONS

  1. SumIf, SumIfs
  2. CountIf, CountIfs
  3. AverageIf, AverageIfs
  4. SumProduct, Subtotal

LOOKUP FUNCTIONS

  1. Vlookup / HLookup
  2. Match
  3. Dynamic Two Way Lookup
  4. Creating Smooth User Interface Using Lookup
  5. Offset
  6. Index
  7. Dynamic Worksheet linking using Indirect

LOGICAL FUNCTIONS

  1. Nested If ( And Conditions , Or Conditions )
  2. Alternative Solutions for Complex IF Conditions to make work simple
  3. And, Or, Not

TEXT FUNCTIONS

  1. Upper, Lower, Proper
  2. Left, Mid, Right
  3. Trim, Len
  4. Concatenate
  5. Find, Substitute

DATE AND TIME FUNCTIONS

  1. Today, Now
  2. Day, Month, Year
  3. Date, DateDif, DateAdd
  4. EOMonth, Weekday

ROUNDING FUNCTIONS

  1. Round
  2. RoundUp
  3. RoundDown
  4. MRound

ERROR HANDLING FUNCTIONS

  1. isNa
  2. isErr
  3. isError

ADVANCED PASTE SPECIAL TECHNIQUES

  1. Paste Formulas
  2. Paste Formats
  3. Paste Validations
  4. Paste Conditional Formats
  5. Add / Subtract / Multiply / Divide
  6. Merging Data using Skip Blanks
  7. Transpose Tables

SORTING

  1. Sorting on Multiple Fields
  2. Dynamic Sorting of Fields
  3. Bring Back to Ground Zero after Multiple Sorts

FILTERING

  1. Filtering on Text, Numbers & Date
  2. Filtering on Colors
  3. Copy Paste while filter is on
  4. Advanced Filters
  5. Custom AutoFilter

PRINTING WORKBOOKS

  1. Working with Themes
  2. Setting Up Print Area
  3. Printing Selection
  4. Branding with Backgrounds
  5. Adding Print Titles
  6. Fitting the print on to a specific defined size
  7. Customizing Headers & Footers

IMPORT & EXPORT OF INFORMATION

  1. From Web Page
  2. Exporting to XML
  3. Creating Dynamic Dashboards and Reports Using Data on Other Applications
  4. Using Text To Columns

WHAT IF ANALYSIS

  1. Goal Seek
  2. Scenario Analysis
  3. Data Tables

GROUPING & SUBTOTALS

DATA VALIDATION

  1. Number, Date & Time Validation
  2. Text Validation
  3. List Validation
  4. Handling Invalid Inputs
  5. Dynamic Dropdown List Creation using Data Validation

PROTECTING EXCEL

  1. File Level Protection
  2. Workbook Level Protection
  3. Sheet & Cell Level Protection
  4. Setting Permissions for Specific Tasks
  5. Track changes

CONSOLIDATION

  1. Consolidating data with identical layouts
  2. Consolidating data with different layouts
  3. Consolidating data with different Sheets

CONDITIONAL FORMATTING

  1. Creating Basic Conditional Formats
  2. Managing Conditions Created
  3. Dynamic Formatting using Formulas in Conditional Formatting

PIVOT TABLES

  1. Creating Simple Pivot Tables
  2. Basic and Advanced Value Field Setting
  3. Sorting based on Labels and Values
  4. Filtering based on Labels and Values
  5. Grouping based on numbers and Dates
  6. Drill-Down of Data
  7. GetPivotData Function
  8. Calculated Field & Calculated Items

CHARTS & PIVOT CHARTS

  1. Bar Charts / Pie Charts / Line Charts
  2. Dual Axis Charts
  3. Dynamic Charting
  4. Other Advanced Charting Techniques

EXCEL DASHBOARD

  1. Bar Charts / Pie Charts / Line Charts
  2. Planning a Dashboard
  3. Adding Tables to Dashboard
  4. Adding Charts to Dashboard
  5. Adding Dynamic Contents to Dashboard

About Your Trainer

Mr. Sami

MCT, MCP, MEE, MOS

30,000+

Students Trained

18+

Year of Experience

4.9

Reviews

Mr. Sami is an exceptionally accomplished and certified Microsoft Trainer, possessing extensive expertise in the fields of Finance, HR, and Information Technology. With an impressive 14-year tenure in the industry, he has successfully trained and empowered over 23,000 professionals, and the number continues to grow.

He has undertaken assignments with the renowned IRS, The World Bank, Tata Chemicals, Buckman Laboratories, Standard Chartered, ING Barings and much more. His nature of going that Extra Mile has got him the startling popularity amongst the Excelgoodies prominent clients.

With his wealth of knowledge and dedication to delivering exceptional training experiences, Mr. Sami consistently exceeds the expectations of his clients and leaves a lasting impact on the professionals he trains.

Mr. Sami is an exceptionally accomplished and certified Microsoft Trainer, possessing extensive expertise in the fields of Finance, HR, and Information Technology. With an impressive 14-year tenure in the industry, he has successfully trained and empowered over 23,000 professionals, and the number continues to grow.

Throughout his illustrious career, Mr. Sami has collaborated with esteemed organizations such as the IRS, The World Bank, Mercedez-Benz, Comcast, Standard Chartered, and ING Barings, to name just a few. His unwavering commitment to going the extra mile has earned him a stellar reputation among Excelgoodies' prominent clients.

With his wealth of knowledge and dedication to delivering exceptional training experiences, Mr. Sami consistently exceeds the expectations of his clients and leaves a lasting impact on the professionals he trains.

Training Schedule

Available Slots

Session Date Time (ET)

Course Fee

$149

Contact Us

Mr. Perrie Smith

Business Associate

Tel: +1 650 491 3131

Email: inquiry_excel@excelgoodies.com

Connect us on

Learner stories around
the world

Total Reviews

4583

Overall growth till now

Average Rating

4.9

Average rating this year

Graph

5

2.0K

4

1.0K

3

500

2

200

1

0

Star Rating

Trainer's Expertise

Course Structure

Course Content

Assignments

Certification Process

Excelgoodies

Scott A. Reifsynder

Power BI Training

Chief Financial Officer

Nexterus

United States

This class was extremely helpful in my knowledge and growth in these database, analysis and reporting tools. I really enjoyed the hands-on approach and got lots of “goodies” out of all the classes. Your approach, repetitiveness and patience is much appreciated and sincerely helped me learn how to accomplish these important tasks. Doing these activities again and again embedded these processes into my routines while I began strategizing how to best utilize these tools in my company’s reporting and analyses. I’d be happy to consider additional classes that you offer on related, important topics to continue enhancing my skills. Thank you very much for your teaching and training methods. I am also very grateful that you provided the daily sample dashboards, instruction steps and how-to descriptions.

Excelgoodies

Wendy Flowers

Power BI Training

Financial and Business Analyst

First Light

United States

This Power BI course was an exceptional training experience. It was very fast paced -- necessary as it covered Power Pivots, Power Query, DAX, Power BI, and SQL. Sami ran the training smoothly, staying after to help individuals with questions. We also are able to schedule up to two 30-minute sessions after the end of the course for guidance on projects. Highly recommend!

Excelgoodies

Tim Palacios

Power BI Training

WFM Data Developer

World Connection

United States

This course was excellent. Sami had a systematic approach to the course curriculum which I feel is key to most if not all learning experiences. He was very knowledgeable and very quick with troubleshooting and helping support when we had any challenges with our work. I am definitely going to take more courses from Excelgoodies. If you are an IT professional or require Data Analytics for your job, this is a great course and I highly recommend it. I think my only critique is that I would have like to have more time devoted to the database side of the class, but that is just a personal preference.

Learner stories
around the world

Total Reviews

4583

Overall growth till now

Average Rating

4.9

Average rating this year

APPLICATION DEADLINE

Registration Closes on .

Registration Closes on
, .

Prove you're human: Type the code shown.

Excelgoodies
=
Excelgoodies