Excelerate
Service Description
Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and Mac OS X. Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data, and integrating information from different programs. Audience This Advance Level training has been designed for computer users who would like to learn Microsoft Excel in easy and simple steps. It will be highly useful for those who have prior exposure to Microsoft applications. Modules Covered in this Excel Training MODULE 1 - EXCEL BASICS (for Beginners) MODULE 2 - EXCEL ESSENTIALS MODULE 3 - EXCEL FORMULAS MODULE 4 - DATA ANALYSIS MODULE 5 - INTRODUCTION TO EXCEL CHARTING MODULE 6 - PIVOT TABLE MODULE 7 - EXCEL EXTRAS SYLLABUS: 1 ROUND() vs. ROUNDUP() & ROUNDDOWN() 2 COUNT() vs. COUNTA() & COUNTBLANK() vs. COUNTIF 3 DAY(), MONTH(), YEAR(), DATE() 4 TEXT() 5 WEEKDAY(), WORKDAY(), NETWORKDAYS() 6 WORKDAY.INTL() for deadline/due date calculations w. custom weekends/holidays 7 NETWORKDAYS.INTL() for no. of business days calculations w. custom weekends/holidays 8 TODAY() and NOW() w. Shortcut 9 Text Formulas – Using CONCATENATE 10 Text Formulas – LEFT(), RIGHT() & SEARCH() - 1 11 Text Formulas – MID() & LEN()03:41 12 Text Formulas – REPLACE() & SUBSTITUTE() 13 VLookup Rules 14 VLookup With Exact Match 15 VLookup Approximate Match 16 VLookup With Trim 17 H-Lookup 18 Hyperlink To Sheet, File, Webpage, External links 19 Print Page Setup, Header & Footer 20 Data Sorting 21 Advanced Filters 22 Filtering Data 23 Basic Table 24 Advanced Table 25 Conditional Formatting: Formula-based (Colored rows based on user input) 26 Pivot Table Examples 1, 2, 3 27 Data Validation 28 Dependent Dropdown List Bonus Class on: 1) How to create online forms which allow you to gather data from individuals team members 2) How to automate Excel tasks with time-saving macros 3) How to remove duplicates from data in Excel 4) VBA Macro - Making use of Excel for business purposes - Purchase Order Generator, Invoice/Billing, 5) Automatic Email Sending with attachments, MIS reports preparation
Upcoming Sessions
Cancellation Policy
Please keep us informed, well in time before cancelling the meeting session!
