Microsoft Excel Online for Novice by Upskill Technologies

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

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

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.