top of page

Excelerate your progress!

Updated: Dec 11, 2023



 



Why you should join this event ?


Learn more in my online event where I share my experience and course material for your practice.


About the event

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


Glimpse of the Event ( Sound is muted)



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

  NOTE: The classes will continue for ~1 hour. In case some topics remain uncovered in the class, you may join our next session.


Bonus Class on:

  1. How to create online forms which allow you to gather data from individual 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


Check more information about it here: www.bikramjeet.com


Enjoy !


 

register online: get your ticket !




A certificate of completion will be given at the end of the session.






26 views0 comments

Comments


bottom of page