Select Page

# Excel Training Course

World’s Most Comprehensive Excel Training Course is here!

And that for Just \$ 97!

Taught by an Industry Expert: Chandoo

The goal of this Excel Training Course is to make you awesome in Excel and Dashboard.

Most intense, focused and clearly defined program to help you learn Excel in useful and fun way.

[one]

### Hours of Video Lecture

Total of ~24 hours of video, neatly structured in to a lesson plan with links to view, download and discuss.

[/services]

[services src=”icon-magic”]

### Most Comprehensive

World’s most comprehensive online Excel training course yet! With no competition to match!

[/services]

[services src=”icon-trophy”]

### Bonus Materials

Contains lots of bonus materials – Excel formula cheat-sheet, Excel keyboard shortcuts Ebook and many more!

[/services]

[/one]

[title text=”Lesson Plan of Online Excel Training Course”]

[tabs_item title=”Module 1″]

Module 1: Lessons on Basic Formulas

• Relative & Absolute Cell References in Formulas
• Difference between relative and absolute references
• using \$ symbol while writing formulas
• Switching between relative & absolute refs. With F4 key
• Using IF Formula, Nesting IF Formulas
• IF Formula
• Nesting IF Formulas
• CHOOSE Formula
• Examples of Nested IFs and Discussion
• COUNTIF, SUMIF Formulas
• What is it and Syntax
• SUMIFS examples
• COUNTIFS examples
• Excel Text Formulas
• LEFT, TRIM, FIND, LEN, RIGHT, LOWER, SEARCH, TEXT, MID, UPPER, VALUE, PROPER, SUBSTITUTE, REPLACE, CONCATENATE and REPT
• VLOOKUP formula, INDEX, MATCH Formulas
• What is it and Syntax
• Vlookup examples
• Vlookup hacks
• Vlookup Errors & Fixing them
• INDEX Formula
• MATCH formula
• SUMIFS Formula, COUNTIFS Formula
• What is it and Syntax
• SUMIFS examples
• COUNTIFS examples
• ROWS, COLUMNS Formulas
• What is it and Syntax
• Using Rows /columns to generate running numbers
• Formula Editing Tips And Tricks
• Using F2 key
• Using F4 Key
• Copying Formulas
• Moving Formulas
• Auto-filling formulas
• Using Mouse to Edit Formula Ranges
• Formula Debugging Using F9 Key
• How to debug formulas using F9 key

[/tabs_item]

[tabs_item title=”Module 2″]

Module 2: Lessons on Advanced Formulas

• Looking up on left
• How to Get Unique Values from a List using Formulas
• How to get unique values from a list using formulas alone
• OFFSET Formula
• What is it and Syntax
• Offset examples
• Uses of Offset formula
• SUMPRODUCT Formula
• What is it and Syntax
• Sumproduct – Simple examples
• Conditional Sum using Sumproduct
• Sumproduct hacks
• Alternatives to Sumproduct
• SMALL, LARGE Formulas
• What is it and Syntax
• Examples of SMALL and LARGE
• Using Small / large to fetch nth item of an un-sorted list
• Named Ranges
• Using Formula Audit Tools
• 3D References (example: consolidate sales data)
• Array Formulas – What are they? (example: MAXIF, MINIF)
• Circular References – What are they? (example: log)
• Various Calculation Modes and How to use them
• Formula Errors and how to handle them

[/tabs_item]

[tabs_item title=”Module 3″]

Module 3: Lessons on Formatting

• Formatting Paste Special
• Currency format sales and profits
• Understand how formats work, examples
• Conditional format codes – examples
• Hide a value without really removing it
• Make the entire table readable
• Copy and paste formats
• Column widths and row heights
• Format Painter, Paste Special
• Freezing the top row of table

[/tabs_item]

[tabs_item title=”Module 4″]

Module 4: Lessons on Conditional Formatting

• Conditional Formatting – 1
• What is Conditional Formatting?
• Basic CF with values
• Using Formulas in CF
• Examples of CF
• Conditional Formatting – 2
• Using Icons
• Using Data Bars
• Using Heat-maps
• Highlighting Top 5, above average etc.
• Conditional Formatting – 3
• Conditional Formatting & Dates
• Conditional Formatting and Duplicate Data
• Complex CF Examples

[/tabs_item]

[tabs_item title=”Module 5″]

Module 5: Lessons on Basic Charting

• How to Select Correct Chart
• Basics of Chart Selection – Rationale
• Common Messages for charts
• Which Charts to use
• Further help & Tips on Chart selection
• Introduction to Excel Charts
• Understanding Excel Charting Options
• Bar Charts / Column Charts
• Line Charts
• Scatter Plots
• Pie Charts
• Other Charts in Excel
• Chart Formatting – 10 Tips
• Making titles dynamic
• Reversing categories
• Removing axis, grid lines, legend
• Combining 2 chart types
• Error bars, adding and formatting them
• Choosing right colors
• Chart Templates
• Bar & Column Chart Formatting
• Overlapped Bar Charts, Understanding Series Gaps
• Negative bars
• Highlighting the max or minimum item automatically
• Adding average line to the chart

[/tabs_item]

[tabs_item title=”Module 6″]

Module 6: Lessons on Advanced Charting

• 7 Advanced Charting Tutorials in Excel
• Bullet chart – what is it and how to make
• Incell charts – using REPT to make charts
• Min-Max chart – showing range along with average
• Waterfall charts
• Time line charts
• Thermo-meter charts
• Gauge Chart
• Dynamic Charts in Excel
• Need for Dynamic Charts
• Dynamic charts using Filters
• Dynamic charts using camera tool
• Interactive Charts In Excel
• Need for interactive charts
• Introduction to form controls
• Using Scrollbar control
• using checkboxes
• Example interactive charts (2)

[/tabs_item]

[tabs_item title=”Module 7″]

Module 7: Lessons on Class Projects

• Excel School Class Project # 1
• Class project objective
• building an interactive chart to compare our performance with competition
• Excel School Class Project # 2
• Class project objective
• Building a dynamic dashboard using camera tool and macros

[/tabs_item]

[tabs_item title=”Module 8″]

Module 8: Lessons on Using Tables

• Excel Tables
• What Is A Table?
• Format As Table
• Understand Table Formatting Options
• Filters, Can Get Multiple Filters In The Same Sheet
• Total Row, Ability To Select Type Of Summary
• Structured References – What Are They?
• Write A Formula For Profit %
• Write A Formula For Profitability Per Customer
• Convert Table To Named Range
• Compatibility Of Tables With Excel 2003 And Earlier

[/tabs_item]

[tabs_item title=”Module 9″]

Module 9: Lessons on Pivot Tables

• Excel Pivot Tables
• What Is A Pivot, Why You Should Use It
• Creating Your First Pivot Report
• Formatting Pivots
• Summarizing Data, Playing With Pivots
• Grouping Values
• Calculated Fields
• Calculated Items
• Making A Pivot Chart
• Copying Pivot Tables
• Example Uses Of Pivots
• Pivot Table Tricks
• Guest lecture by Debra Dalgleish
• Pivot and chart
• Group dates and data
• Calculate
• Focus with filters, sort

[/tabs_item]

[tabs_item title=”Module 10″]

Module 10: Lessons on Data Filters

• Data Filters & Sorting
• Uses of Filters
• Basic Filtering
• Short-cuts for filtering
• Visual Filters – Using Conditional Formats
• Sorting
• Sorting left to right

[/tabs_item]

[tabs_item title=”Module 11″]

Module 11: Lessons on Validation

• Data Validation
• Uses of Data Validation
• Simple Data Validation Examples
• Using drop-down box to validate
• Using Formulas
• Showing Error Messages

[/tabs_item]

[tabs_item title=”Module 12″]

Module 12: Lessons on Working with Data

• Importing External Data
• What is the purpose of Excel Import?
• Understanding various import options
• Importing Text Files – Example: Dynamic Data Validation
• Importing Web Pages – Example: Movie Tracker
• Importing Access DBs – Example: Sales Pivot Report
• Using Text Import Utility – Example: Converting Dates
• Excel Access Integration
• Excel to Access
• Integrating Excel & Access thru Automation
• Working With Complex Worksheets
• What is a complex sheet?
• Tips for handling complexity
• Designing a complex workbook

[/tabs_item]

[tabs_item title=”Module 13″]

Module 13: Lessons on Using Excel

• Export Excel to Other Formats
• How to Export Excel Content to PPT or Word Documents?
• How to Export Excel Content to Web Pages
• How to Export Excel Content to PDF
• Excel 2010 – A Short Introduction
• New features in Excel 2010
• Sparklines
• Conditional Formatting Enhancements
• Backstage view / File menu

[/tabs_item]

[tabs_item title=”Module 14″]

Module 14: Lessons on Macros & VBA

• Introduction To Macros
• What is a Macro
• Using Macro Recorder and Your First Macro
• Editing Macros & VBE
• Macros vs. UDFs
• How to get more help on Macros & Advanced Excel

[/tabs_item]

[tabs_item title=”Module 15″]

Module 15: Lessons on Excel Dashboards

• What is a Dashboard?
• 5 Dashboard Examples
• Deriving our own dashboard definition
• Looking at Dashboard definitions around web
• Conclusions
• Dashboard Creation Process
• Why have a process – Learning from a Failed Dashboard
• Defining the Dashboard Creation Process
• Example Dashboard made with such process
• Conclusions
• Making Excel Dashboards – Part 1
• Defining the purpose of the dashboard
• Finding appropriate metrics for the dashboard
• Making a mockup of the dashboard
• Making Excel Dashboards – Part 2
• Understanding the data
• Writing Formulas
• Making Charts
• Putting Everything Together
• Conclusions & Homework
• Dashboard Design Tips & Tricks
• Making Website Dashboard
• Making a Sales Dashboard
• Making a KPI Dashboard

[/tabs_item]

[title text=”Join Excel Training Course Now”]

[one]
[price type=”Basic” title=”BASIC” price=”\$97″ plan=””] [price_item]24+ Hours Excel video[/price_item] [price_item]6 Month Access to Online Classroom[/price_item] [price_item]40+ Example Excel Workbooks[/price_item] [price_item]Free Bonus – Excel Formula Cheat-sheet Ebook[/price_item] [price_item]Free Bonus – Excel Keyboard Shortcuts Ebook[/price_item] [price_item]Free Bonus – Chart Design Ebook[/price_item] [price_item]30 Day Money Back Guarantee[/price_item] [price_item]Email Support[/price_item] [price_item type=”btn” btn_text=”Launching Soon” btn_url=”https://feasibility.pro/” btn_size=”” btn_bg_color=”#005800″ btn_bg_hover_color=”#0000FF” btn_txt_color=”#FFFFFF” btn_txt_hover_color=”#FF0000″][/price_item] [/price]
[price type=”Pro” title=”PRO” price=”\$147″ plan=””]
[price_item]24+ Hours Excel video[/price_item] [price_item]6 Month Access to Online Classroom[/price_item] [price_item]40+ Example Excel Workbooks[/price_item] [price_item]Free Bonus – Excel Formula Cheat-sheet Ebook[/price_item] [price_item]Free Bonus – Excel Keyboard Shortcuts Ebook[/price_item] [price_item]Free Bonus – Chart Design Ebook[/price_item] [price_item]30 Day Money Back Guarantee[/price_item] [price_item]Email Support[/price_item] [price_item]Download HD Quality Lessons[/price_item] [price_item type=”btn” btn_text=”Launching Soon” btn_url=”https://feasibility.pro/” btn_size=”” btn_bg_color=”#005800″ btn_bg_hover_color=”#0000FF” btn_txt_color=”#FFFFFF” btn_txt_hover_color=”#FF0000″][/price_item] [/price]
[/one]

[title text=”More Detail about Excel Training Course”]

[accordion id=”accordion_1″]

[accordion_item id=”accordion_item_1″ title=”1,350 minutes Excel lessons” open=”yes”]Each topic in Excel Training Course comes with several videos discussing various topics in-detail. There is a total of around 24 hours of video in the course at this moment. All these lessons are neatly structured in to a lesson plan with links to view, download and discuss.[/accordion_item]

[accordion_item id=”accordion_item_2″ title=”45+ Example Excel Workbooks”]Almost all the topics in Excel training course include downloadable content – either excel files or ppts or pdf files. Using these files, you can easily improve your understanding and play with the concepts right-away.[/accordion_item]

[accordion_item id=”accordion_item_4″ title=”8 Hour Lessons on Excel Dashboards”]We will discuss dashboard design principles, best practices, see several examples, build 4 different dashboards. Also, you can download unlocked dashboard excel files and reuse them as you see fit.[/accordion_item]

[accordion_item id=”accordion_item_5″ title=”Free Bonus – Formula Cheat-sheet “]If you use excel formulas a lot, then this cheat sheet can help you. It contains the syntax of most important formulas along with example uses and tricks to handle errors.[/accordion_item]

[accordion_item id=”accordion_item_6″ title=”Free Bonus – Excel Keyboard Shortcuts E-Book”]This E-book includes some really powerful and useful excel keyboard shortcuts which will be critical in building excel models[/accordion_item]

[accordion_item id=”accordion_item_7″ title=”Free bonus – Excel Chart Design E-book”]This e-book explain the process to format charts to wow your audience. It also includes guidance on how to use colors effectively. This will come very handy in creating excel dashboards for project management and investment analysis.[/accordion_item]

[accordion_item id=”accordion_item_8″ title=”30 Day money back guarantee”]Each Excel Training Course comes with a 30 day money back guarantee. If you don’t like what you see in course, just drop an email and your money will be refunded. No questions asked.[/accordion_item]

[/accordion]

[title text=”Testimonials”]

[testimonials type=”avatar”]
[testimonials_item name=”Mary Scott” job=”Project Manager” img=””]Your sense of humor, kindness and enthusiasm for Excel are fantastic. The numerous shortcuts that you teach are invaluable.[/testimonials_item]
[testimonials_item name=”Monique Ballard” job=”Business Owner” img=””]I can view the lessons at my own leisure. They are very clear and easy to understand. Completely packed with information that it is almost overload.[/testimonials_item]
[testimonials_item name=”Gaston Wilson” job=”Investment Manager” img=””] I get my most benefit from first reviewing the lesson but then “reverse engineering” the sample files. Well Done![/testimonials_item]
[/testimonials]

.

.

Hope to see you in Excel Training Course.

* We will be using Microsoft Excel 2010 / 2007 during the Excel Training Course.
* This Excel Training Course is offered in association of Chandoo, Click here to view more details

## Wait

### I want to teach you how to conduct feasibility studies!

Enter you email to know more!