Advanced excel training topics

Hello sir can you please provide me Advanced excel training topics its very argent for me??

[Arun Vats]

Here I am providing you Advanced excel training topics as you want the same Na.

Navigation & Views (Basic, Intermediate, Advanced, Managing Databases)

Formatting (Basic, Intermediate, Pivot Tables & Charts)

Conditional formatting (Intermediate, Advanced, Pivot Tables & Charts, Formulas & Functions)

Charts (Intermediate, Advanced, Pivot Tables & Charts)

Pivot Tables (Advanced, Pivot Tables & Charts)

Formulas & Functions (Basic, Intermediate, Advanced, Formulas & Functions)

Lookups, HLookups, VLookups (Advanced, Formulas & Functions)

IF statements (Intermediate, Advanced, Formulas & Functions)

Some other topics of Advanced Excel

BASIC Microsoft Excel:
Spreadsheet basics
Creating, editing, saving and printing spreadsheets
Working with functions & formulae
Graphically representing data : Charts & Graphs
Analyzing data : Data Menu, Subtotal, Filtering Data
Formatting worksheets , Securing & Protecting spreadsheets

ADVANCED Excel Contents:
Formulas & Macros Formulas:

Use the Function Wizard, Common functions (AVERAGE, MIN, MAX, COUNT,COUNTA, ROUND, INT)
Nested functions , Name cells /ranges /constants
Relative, Absolute, Mixed cell references : >,<,= operators
Logical functions using IF, AND, OR, NOT
The LOOKUP function , Date and time functions , Annotating formulas

DATA Analysis:

Sub Total Reports, Auto Filter
Password Protecting Worksheets
Linking Multiple Sheets
Sheet Referencing
Linking Between Word/Excel/Ppt
Functions:- LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF
What-if-analysis, GOAL SEEK
Pivot Tables, NESTED IF
Reporting
Character Functions
Date Functions
Age Calculations
Consolidation of Data
Data Validation
MACRO’S

Macros:

Definition and use , Record a macro
Assign a macro , Run a macro
Store a macro, Introduction to VBA Prog.

Develop the Worksheet:

Plan a worksheet , Row and Column labels
Split worksheet /box /bar, Copy data and formulas
Display /move toolbars , Enhance worksheet Appearance

Special Operations:

Use multiple windows : Copy/ paste between Worksheets
Link worksheets , Consolidate worksheets
Import and link from other Applications
Use AutoFormat : Create, use and modify styles and templates
Print features : Create /edit an outline

Graphic Operations:

Create charts , Enhance charts, Drawing toolbar features