Quick review on MS Excel Options, Ribbon, Sheets

Saving Excel File as PDF, CSV and Older versions

Using Excel Shortcuts with Full List of Shortcuts

Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet

Using Paste Special Options

Formatting Cells, Rows, Columns and Sheets

Advanced Filtering in Excel

Grouping & Subtotal in Excel

Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password

Page Layout and Printer Properties

Working with Formulas / function

Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, etc

Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc

Database Functions

Date & Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY

Information Functions

Math & Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, EVEN, SUMIF

Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE.

Conditional Formatting

Using Conditional Formatting

Using Conditional Formatting with Multiple Cell Rules

Using Color Scales and Icon Sets in Conditional Formatting

Creating New Rules and Managing Existing Rules

Data Lock & Protection

Advance Charts in Excel

Area Charts and Surface Charts

Trend line Charts and Candle Stick

Charts and Pie Charts

XY (Scatter Charts)

Time Series Charts and Bubble Charts

Radar Charts and Doughnut Charts

Rotating 3D Excel Charts

Working with Fill Series & Go to Special

Consolidation in Excel

What if Analysis in Excel

-Goal Seek

-Scenario Manager

-Data Table