Mastering Formulas, Functions, and Data Analysis for Business Professionals
What you will learn
‘;
}});
Introduction to the Excel Interface
Move and Copy Data in Worksheet
Working with Rand & Randbetween
Working with ROUND, ROUNDUP and ROUNDDOWN
Date and DATEDIF Function
CHOOSE and SWITCH Function
UPPER, LOWER, PROPER & TRIM
LEFT, MID, RIGHT & LEN
SORT and SORTBY Functions
INDEX, MATCH, XMATCH and EXTACT Function
Combining EXTACT & VLOOKUP
Custom Data Validation
XLOOKUP Function
Creating a PivotTable from Scratch
Applying PivotTable Styles
Create a Bar, Column, Line and Pie Chat
Inserting and Formatting Slicers
Proetect Worksheet and Workbook
Inserting Headers and Footers
Printing a Workbook
