MS Excel Training

MS Excel Course:
Microsoft Excel is the most basic yet powerful tool to manage and analyze various types of Data. This training on Excel covers beginner to intermediate lessons on how to use various Excel formulas, Tables, and Charts for managing small scale business processes. For more advanced training on Excel please refer to our training on "Advanced Excel". This Excel training helps your team increase productivity and convert manual business processes into an automated one with intuitive visualization. This Excel course takes a completely hands-on approach. Corporate training in Excel is customized based on the requirement of the clients. This Excel training is delivered by our experts at Bangalore as well at client locations across India and South-East Asia in cities such as Bangalore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Singapore, Hong Kong and many more.

MS Excel Course Curriculum

1. Getting started with Excel

A brief introduction to Excel

Why Excel

CSV and other formats

Explanation about data calculation in Excel

Use of Shortcuts

Formatting and Conditional Formatting

2. Excel Basics

Basic concepts

Understanding of Mathematical, Statistical Functions

Worksheet and Workbook Protection and Security

Understanding of Name Ranges

Introduction of Charts

Introduction of Form Controls

Understanding of Data Tools Panel

Basics of Macro Recording

3. Data Analysis using Excel

Working with Formulas - Logical and Text Functions

Understanding about Sorting, Filtering, and Data Validation

Data Analysis using Pivot Tables

Lookup functions and

Data validation with Excel

Advanced Formulas

4. Data visualization using Excel

Overview of Dashboards

Deciding on Dashboards

Trends and Scenarios using charts

Charting - Thermometer, Doughnut, Pareto, Panel and Step Chart

Designing Sample Dashboard using Form Controls

Tips and Tricks

5. Advanced Concepts of Excel

Automation

Data analysis

Data Presentation

The Way Forwar

Frequently Asked Questions

What are the modes of the Excel training?

We provide classroom-based as well as online training. Since this is a hand-on training so batches generally does not contain more than 4 people.

Will I be provided with any study material during the Excel training?

We will provide web services specific study material as the course progresses. You will have lifetime access to all the code and basic settings needed for these Excel training through our github account and the study material that we share with you. You can use that for quick reference.