Microsoft Excel Online Expert level by Upskill Technologies

1Day:
Day 1: 9 AM -6 PM
Working with and Editing Excel Ribbon and Quick Access Toolbar.
Creating and Organizing workbooks by inserting,deleting, renaming....
Working with excel templates, creating dynamic lists, autofill, tables..
Exploring Formatting options to create stunning reports and dashboards.
Understanding the basics of Formulas and writing simple functions.
Creating sample reports with basic formulas and formatting options.
Creating and customizing various types of Charts.
Defining Names and creating dynamic charts and formulas

2nd Day: 9 AM -6 PM

Working with Excel Filter and Sort
Data Analysis using Pivot Tables
Using Formulas Sum-IF, Count-IF, Sum-IFS, Sum-Product, MultipleIF
Using Vlookup, Hlookup, Indirect and Match
Validating and Securing data with validaiton and protection of cells.
Analyzing data with subtotals, goal seek and scenario manager.
Content :

Creating Templates, Formatting, Creating Tables, Changing Default Options, Writing Formulas, If Conditions, Conditional Formatting, Using Formulas in conditions, Sum-IF, Count-If, Vlookup, Pivot Table Subtotals, Data Validation, Protecting Sheet and Workbook