Advanced Excel Online Course

Basic Understanding Menu and Toolbar

Introduction to different category of functions

Creation of Excel Sheet Data

Range Name, Format Painter

Conditional Formatting, Wrap Text, Merge & Centre

Sort, Filter, Advance Filter

Different type of Chart Creations

Auditing, (Trace Precedents, Trace Dependents) Print Area

Data Validations, Consolidate, Subtotal

What if Analysis (Data Table, Goal Seek, Scenario)

Solver, Freeze Panes

Various Simple Functions in Excel (Sum, Average, Max, Min)

Real Life Assignment work

Save a workbook as a template,

copy macros between workbooks,

reference data in another workbook,

reference data by using structured references,

enable macros in a workbook,

display hidden ribbon tabs

Restrict editing,

protect a worksheet

configure formula calculation options

protect workbook structure

manage workbook versions

encrypt a workbook with a password

Create custom number formats

populate cells by using advanced Fill Series options

configure data validation

Create custom conditional formatting rules

create conditional formatting rules that use formulas

manage conditional formatting rules

Create custom color formats,

create and modify cell styles,

create and modify custom themes,

create and modify simple macros

insert and configure form controls

Display data in multiple international formats

apply international currency formats,

manage multiple options for Body and Heading fonts

Perform logical operations by using AND, OR, and NOT functions;

perform logical operations by using nested functions

perform statistical operations by using SUMIFS, AVERAGEIFS, COUNTIFS functions

Look up data by using the VLOOKUP function,

look up data by using the HLOOKUP function,

look up data by using the MATCH function,

look up data by using the INDEX function

Reference the date and time by using the NOW and TODAY functions,

serialize numbers by using date and time functions

Reference the date and time by using the NOW and TODAY functions

import, transform, combine, display, and connect to data

consolidate data

perform what-if analysis by using Goal Seek and Scenario Manager

use cube functions to get data out of the Excel data model

calculate data by using financial functions

Trace precedence and dependence

monitor cells and formulas by using the Watch Window

validate formulas by using error checking rules,

Evaluate formulas

Name cells,

name data ranges,

name tables,

manage named ranges and objects