Advanced Excel

+ View more

Course overview

Objective:

This Advanced Excel program will help participants in enhancing the ability to use spreadsheets, graphing, tables, calculations, and automation, efficiently to process large quantities of data relevant to business tasks.

Topics Covered:

➱ Brush-up on Basics

➱ Working with Cell Reference

➱ List Management

➱ Working wit Formulas & Functions

➱ Sorting & Filtering data

➱ Working with Styles & Conditional Formatting

➱ Working with Lookup Functions

➱ Working with Range Names

➱ Data Validation

➱ Working with Templates

➱ What-If Analysis(optional)

➱ More Functions

➱ Workbook Sharing and Auditing

➱ Working with Professional Reports & Graph

➱ Basics of Macros(VBA)

Target Audience:

➱ Working professionals across industries

➱ Freshers/ New Joiners across industries

➱ Students/ Entrepreneurs/ Teachers/ Tutors/ Facilitators/Anyone seeking to upskill

➱ Self Employed ( Lawyers, Entrepreneurs, Doctors, Consultants etc)

➱ Students Youngsters aspiring to join corporates

➱ People aspiring to start their business

➱ Organisations looking to train their workforce on Advanced Excel

What will I learn?

Use different methods for entering and editing data and the various ways to write simple formulas
Examine spreadsheet concepts and explore the Microsoft Office Excel environment.
Create, enter and Modify a worksheet and workbook.
Work with Formulas & Functions, Cell Reference, Styles & Conditional Formatting
Learn to use functions and formulas.
Create and edit charts and graphics.
Filter and sort table data.
Work with templates, professional reports, graphs, pivot tables and charts.
Import and export data.

Program Highlights