About the Course
This class is helpful for working professionals, MBA students as well anyone looking for brushing up their excel skills.
Excel is a powerful analysis Tool which can be used for business analysis as well simple home use of tracking home expenses.
Class would give hands on working experience on excel and power point for professional presentations.
Topics CoveredDay: 1
Cell Operation, Format Cells, Freeze Panes, Techniques of Paste Special, Protect Worksheets & Workbooks ,Time Saving Utilities, Format Painter, Text to Columns with fixed and delimited parameters, Data Sorting using custom list, Summarizing data using Auto Outline, Concept of Cell Referencing, Relative Referencing, Absolute Referencing, Mixed Referencing
NETWORKDAYS,IS FUNCTIONS,MATCH,IF,VLOOKUP (2D lookup & 3D lookup),HLOOKUP,REVERSE LOOKUP,
Who should attendWorking professionals, Students looking for practical MS office exposure and House wives for tracking home expenses and kids home work
Pre-requisitesBasic computer knowledge
What you need to bringnote pad/laptop
Key TakeawaysExcel functions and formula