Free Specialized Microsoft Excel Course 2018

Enter your details and reserve your slot now Limited attendees per batch, so act fast

Welcome to our FREE Advanced Excel Training Course

Here’s What You Can Expect To Learn From This Course

The objective of this course is to significantly strengthen your core Excel skills and make you ready for the next level

This entire module has something for everyone, from Beginner to Intermediate, to Advanced users

You will learn the best strategies and tips that will help you refine your professional skills like never before

We will start with the Fundamental

Introducing you with Excel Interface, Quick Access Toolbar, Workbook, and Worksheets, Selecting and Entering Data, Using Excel Templates etc.

Gradually we will move towards Excel Function and Formulas, Charts, Conditional Formatting, Pivot Table, Leveraging Excel sheet as a Database and so on

The complete course curriculum is listed below

Since this course is formulated in a manner to help everyone, if at any given point in time you feel the topic is too basic for you, you can certainly go ahead and skip that portion

The choice is yours

You are not just going to learn, but also going to Implement all that we have learned, by working on live scenarios-based projects Step by Step.

On completion of this course, you will have a solid understanding of:

How to Design a Reports?

How to use Excel Functions to Create your Own Formulas?

Managing Data using Pivot Table

Create amazing Charts and Graphics etc.

In other words, you not only stand out in a crowd but often turn out to be the go-to person in the office who knows a special skill that others don’t.

It will also equip you to increase further job prospects because Excel’s usages and advantages are known to most hiring managers

So, your options automatically open up

Get Instant Access to this Free Advanced Excel Course now:

Frequently Asked Questions


Yes, this course is completely free and will not cost you a penny

To enroll in this course, you need to reserve your spot. Post that you will receive a welcome email with the appropriate details

Yes, this is a proper classroom training. You may register yourself and get your training scheduled

Course Curriculum


Course Overview

  • Introduction to Excel Basics
  • Difference between Workbook and Worksheet
  • Add New Workbook
  • Add OR Delete a Worksheet
  • Add or Delete Multiple Worksheet
  • Rename Worksheet
  • Define Color to a Worksheet
  • Add OR Delete Rows
  • Add OR Delete Multiple Rows
  • Add OR Delete Columns
  • Add OR Delete Multiple Columns
  • Explore Excel Shortcut keys

Excel Mathematical Operators

  • What are the different type of Mathematical Operators in Ms. Excel
  • What is the Order of Operators
  • How to Create Formulas using Operators
  • Use of Brackets () , Commas , and Inverted commas "" in excel formulas

Excel Cell References

  • What are Excel Cell References?
  • Letters for Columns and Number for Rows References
  • Numbers for both Columns and Rows References
  • Relative References
  • Absolute References
  • Column References
  • Row References

Excel Essentials

  • Excel Formatting
  • Use of Format Painter
  • Explore Paste Special
  • Sort and Filter
  • Find and Select
  • Freeze Panes
  • Explore Go To
  • Excel Flash Fill
  • Protection
  • Comments
  • Spelling and Thesaurus
  • Print Layout

Formulas and Functions

  • Difference between Formulas and Functions
  • SUM Function
  • COUNTIF
  • VLOOKUP
  • HLOOKUP
  • CONCATENATE
  • YEAR
  • TODAY
  • AVERAGE
  • PMT
  • NPER
  • PV
  • RATE
  • VALUE

Data Manipulation

  • Excel Table
  • Pivot Table
  • Conditional Formatting

Charts

  • Recommended Charts
  • Column Chart
  • Line Chart
  • Pie Chart
  • Bar Chart

Projects we Intend to Work Together

  • Attendance Tracker
  • Break Log
  • Leadership Effectiveness Survey
  • Loan Calculation
  • Math Table
  • Pay Calculation
  • Pivot and Charts
  • Travel Chart