Advanced MS Excel
3 Days
Duration
20 May - 30 May 2022
Date
10am - 1pm
Time
Online
Mode of Training
E-Certification
To all Participants
About the Program
This program is developed to educate students on the functions, types of financial analysis, and the advanced formulas required to function as an Excel power user. This course program builds skill enhancement, specifically for spreadsheet users, to strengthen their fundamentals in Excel to an advanced level. It allows the user to complete tasks and analyze data more quickly. It also allow to keep team members up-to-date on data, which can streamline the workflow process.
Who should attend?
Anyone involved in Corporate world linked with Computer Science, Information Technology, Healthcare, Artificial Intelligence, Data Analysts, Policy Makers, Hospital Management, Administration and Public Health.
Program Overview
The program will include the following topics:
- Introduction
- Overview
- Syntax
- Ranges
- Fill
- Cell operations
- Relative reference & absolute reference
- Arithmetic operators
- Parenthesis
- Functions
Formatting, format painter, colors, fonts, numbers, borders, grids, settings.
Analysis, sort, filter, tables, conditional formatting, highlighting rules, charts, customization.
Functions, And, Average, Averageif, Averageifs, Count, Counta, Countblank, Countif, Countifs, If, Ifs, Max, Median, Min, Mode, Or, Stdev.P, Stdev.S, Sum, Sumif, Sumifs, Vlookup, Xor.
