## [100% Off] Microsoft Excel Functions For Business 2021

9 Mar , 2021

What you will learn

â˜‘Â How to use Excel Functions to speed up activities

â˜‘Â How to use Excel Formulas to automate calculations

â˜‘Â How to use Pivot Tables to sort and filter big data

â˜‘Â How to Impress your boss with the use of advanced SUMIFS,COUNTIFS,VLOOKUP,HLOOKUP,LOOKUP,INDEX and MATCH and lots more

â˜‘Â How to create reports

â˜‘Â How to validate excel data and trace formulars

â˜‘Â How to nest the Right, Mid and Left functions to subset text strings in excel

â˜‘Â How to automate excel functions and formulas

â˜‘Â How to dynamically use cell locking

â˜‘Â How to create awesome charts and graphs in Excel

â˜‘Â How to create dashboards in Excel

â˜‘Â How to secure your dashboard in Excel

â˜‘Â How to clean dataset in excel

â˜‘Â How to analyze and make optimal decisions among competing projects.

Content

Course Preview

Overview on Microsoft Excel

What you will Learn in the Course

Introduction to Excel Past special Options

Microsoft Excel Paste Special Options

Microsoft Excel Paste Special Operations

Microsoft Excel Transpose Option

Cell Locking and Subtotals

How to fill series in Microsoft Excel

Cell locking part 1 in Microsoft Excel

Cell locking part 2 in Microsoft Excel

Working with Subtotal and Filters in Microsoft Excel

Subtotal vs Sum in Microsoft Excel

Lookup and References in Microsoft Excel

Vertical Lookup(VLOOKUP) in Microsoft Excel

Horizontal Lookup(HLOOKUP) in Microsoft Excel

Lookup Functions part 1 in Microsoft Excel

Lookup Functions part 2 in Microsoft Excel

True vs False Match

Match Function in Microsoft Excel

Index Function in Microsoft Excel

Nesting Index and Match Functions part 1

Nesting Index and Match Functions part 2

Nesting Index and Match Functions part 3

Data Cleansing in Excel

Clean Function in Microsoft Excel

Trim Function in Microsoft Excel

Text to Column option in Microsoft Excel

Substitute Function in Microsoft Excel

De-Duplicate in Microsoft Excel

The Value function in Microsoft Excel

Extracting Subset of Excel Text string

Right Functions in Microsoft Excel

Mid Functions in Microsoft Excel

Left Functions in Microsoft Excel

Find and Length Functions in Microsoft Excel part 1

Find and Length Functions in Microsoft Excel part 2

Find and Length Functions in Microsoft Excel part 3

Find and Length Functions in Microsoft Excel part 4

Excel Text Formatting Options

Text Formatting in Microsoft Excel

Concatenation function in Microsoft Excel

Data Validation in Microsoft Excel

Excel Conditional Count and Sum Function

Basics of Excel Countifs Function

Basics of Excel Sumifs Function

Excel Logical Functions

IF Functions in Microsoft Excel

IF + OR Functions in Microsoft Excel

IF + AND Functions in Microsoft Excel

Nested IF

Working with Excel Pivot Tables

How to Activate Pivot Table in Microsoft Excel

How to Create Pivot Tables

Querying Data in Pivot Table

Pivot Table Value Options

Pivot Table Calculated Fields

Pivot Table Slicers and Timelines

Sorting Pivot Tables

Pivot Table Label Filter

Pivot Table Value Filter

Redeem Offer