Call us: 2348089469906

Excel Training

Basic & Advance Excel Training

The Basic to Advanced Excel Training by Topsite Infotech is a 4-Weeks Intensive Training Program covering the basic and advanced modules of Microsoft Excel. In this training program, you will learn how to use Microsoft Excel and the Advanced Concepts of Excel.

Pre-requisite

  • Basic Excel: This would be better suited to beginners who have no prior knowledge of analytics. It is for beginners. There are no pre-requisites
  • Advance Excel: You only need to have the Knowledge of Basic Excel as stated in the course content

Microsoft-Excel-Training

Course Content

Basic Excel

GETTING STARTED WITH EXCEL

In this module, you will get a brief introduction to get you familiar with Excel.

  • Introduction to Excel.
  • Why should we learn Excel?
  • Orientation / Tour
  • Interface & Terminology
  • Excel worksheets
  • Backstage View
  • Quick Access Toolbar
  • Keyboard shortcuts

EXCEL WORKSHEET:

You will learn basic concepts of working with Worksheet in this module which will give you a chance to build a solid foundation.

  • Working with Cells/Rows/Columns
  • Basic Cell Formatting
  • Cell Number Formats
  • Cut, Copy & Paste with Find & Replace
  • Personalizing Worksheets
  • Multiple worksheets
  • Sheet Protection
  • Printing & Page Layout
  • Assignment

FORMULAS & FUNCTIONS

In-depth lessons on formulas, functions, lookup functions and data validation with Excel.

  • Introduction
  • Basic Formulas
  • Advanced Formulas
  • Cell References
  • Basic Excel Functions
  • Assignment

——————————-

DURATION: 2 Weeks

——————————-

Advance Excel

ADVANCE FUNCTIONS

In-depth lessons on advance functions, lookup functions and data validation with Excel.

  • Date/Time Functions
  • Text Functions
  • Financial Functions
  • Logical Functions
  • Lookup Functions
  • Data Validation
  • Troubleshooting
  • Assignment

WORKING WITH DATA

You will learn all about data organization and data visualization.

  • Basic tips for working with data
  • Freezing panes and View options
  • Data Sorting
  • Data Filtering
  • Tables
  • Charts in Excel
  • Assignment

ADVANCED CONCEPTS

You will learn the skills needed to automate, analyze & present Excel data in the most effective manner.

  • Conditional Formatting
  • What-If Analysis
  • Pivot Tables 1
  • Pivot Tables 2
  • Pivot Tables 3
  • Assignment

——————————-

DURATION: 2 Weeks

——————————-

Weekdays Class

  • Start: 1st Monday of the Month
  • End: 4th Friday of the Month
  • Days: Mon, Wed & Fri.
  • Time: 9am – 11am

Weekend Class

  • Start: 1st Saturday of the Month
  • End: 4th Saturday of the Month
  • Days: Saturdays Only
  • Time: 2pm to 7pm (1hr break btw)

Payment Method

  • Basic Class Only: #10,000
  • Advance Class Only: #15,000
  • Basic & Advance Class: #20,000
  • Pay Into: GTB – 0137403564 – Topsite Infotech