EXCEL PROFICIENT

This course will cover all aspets of creating spreadsheet, performing calculations, formatting, some very widely used formulas like sumif, lookups, and also getting Excel to make decisions using the 'IF' finction and conditional formatting.

This course will enable the users to create , build and customise graphs.

Our case study training design is unique as it blends the features of the tool and usage scenarios. Existing excel users whom habe not had any formal training finds this course extermely useful, as it will bridge the gap in your knowedge of excel.


Download

MODULE NAME DETAILED TOPICS
Basic Arithmetic Function and Data
Handling Techniques
Arithmetic Functions-Sum, Product Average. Insert Row, Column, copy and paste Techniques, Formatting, Navigational Technique, Protect Sheet and workbook
Mathematical Functions SUMPRODUCT, SUMIF AND SUMIFS, COUNTIF AND COUNTIFS, AVERAGIF AND AVERAGEIF 2-CASE STUDIES
Validation Techniques Drop Down Lists, Error Alerts, Conditional formatting
Graphs Different kinds of Graphs 1-case study
Date Functions DAYS360, TODAY, NOW NETWORKDAYS, WORKDAY-1 CASE STUDY
Logical Functions IF, AND, OR and NESTED IF 1-case Study
Lookup's VLOOKUP and HLOOKUP 4-Case Studies
Data Analysis Data Analysis using Pivot tables 2-Case Studies
Filters and Data Sorting Applying and using AuroFilter, Creating a Custom Auto Filter, Sorting On More than one Column