Excel Screen

Managing Sheets-Hide Unhide,Insert, Delete, Color

Sheet Move Or Copy

Customizing Quick Access Toolbar

Managing Columns And Rows

Change Workbook Views

Custom View – Create, Edit And Manage

Save The File In Different Format (Pdf, Csv, Text Etc)

Hyperlink – Create, Edit And Manage

Wrap Text, Text Orientation, Alignment, Customized Border, Merge

Number Formatting With Customization

Date Formatting With Customization

Percentage Formatting

Using Format Painter

Clear All Format In A Click

Set Print Scaling

Fixing Number Of Pages To Be Printed Of Whole Sheet

Row(S) To Be Printed At Top On Every Page

Setting Margin-Top, Bottom, Left, Right

Printing in center-horizontally or vertically in a page

Customizing Header And Footer – Create, Edit And Manage

Printing A Specific Area Of The Sheet – Create, Edit And Manage

Page Break – Create, Edit And Manage

Copy-Paste Techniques

Use Of Various Paste Special Options

Auto Filling Techniques For Different Types Of Data

Showing-Hiding The Screen Objects

Freeze Panes-Fixing Rows And Columns While Scrolling

Create An Excel Table From A Cell Range

Add Columns And Rows In The Table

Configure Table Style Options

Controlling Tables Using Slicers

Sorting And Filtering Table Data

Convert A Table To A Normal Range

Relative Cell Reference

Partial Relative And Partial Absolute

Absolute Cell Reference

Left Function

Right Function

Mid Function

Upper Function

Lower Function

Proper Function

Trim Function

Trim+Proper In The Same Formula

Cell Joining Using Concatenate Function

Cell Joining Using (Ampersand)

Value Function

Text Function

Round Function

Roundup Function

Rounddown Function

Aggregate Function

If Condition Excluding Else

If Condition Including Else

Ifs Function Excluding Else

Ifs Function Including Else

Nested If Formula With And Or

Data Sort With Single Criteria

Data Sort With Multiple Criteria

Sort By Month Name Or Day Name

Sort By Color

Row Wise Sort And Column Wise Sort

Most Common Mistakes In Data Sorting

Data Filtering With Single Criteria

Data Filtering With Multiple Criteria

Filter By Color

Customized Filtering With Text Values

Customized Filtering With Number Values

Making Unique List And Pasting In A Different Location

Summation On Only Visible Filtered Data

Clear All Filtered Data Using One Click

Setting A Single Conditional Formatting

Setting Multi-Level Conditional Formatting In The Same Range

Using Data Bar Type Conditional Formatting

Highlighting The Duplicate Values

Conditional Formatting Using Formula

Highlighting Top Or Bottom Values

Conditional Formatting Using Color Scale

Conditional Formatting Using Icon Set

Customizing The Icon Set

Add, Edit Or Remove Conditional Formatting

Clearing The Conditional Formatting

Finding Out The Conditional Formatting Applied Cells

Vlookup Function When The Range Is Whole Column

Vlookup Function For The Specific Range

Copy-Paste Techniques For The Vlookup Formula

Difference Between True And False In Vlookup Function

Carefulness For Vlookup Function

Hlookup Function

Match Function

Index Function

Combination Of Index And Match Function In A Single Formula

Overview Of Pivottable

Creating Pivottable Using One Row And One Column-1

Creating Pivottable Report With Multiple Groups

Changing Layout Of Pivottable

Drill Down Your Pivottable Value

Filtering The Pivottable Data

Formatting Pivottable Data-Finished

Creating Pivotchart

Use Slicers In Pivottable

Conclusion Of Pivottable

Overview Of Data Validation

Setting Data Validation In A Specific Area

Changing Data Validation

Clearing Data Validation

Searching Data Validated Set Area

Entry Restriction In A Specific Area Of A Sheet

Set The Password To Unprotect The Sheet

Unprotect The Sheet With Correct Password

Removing Password To Unprotect The Sheet