top of page
Excelerate
Excelerate

Sun, 17 Dec

|

Online Video Conference

Excelerate

Advance Excel for Engineering Professionals!

Registration is closed
See other events

Time & Location

17 Dec 2023, 10:30 am IST

Online Video Conference

Guests

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

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
This event has a group. You’re welcome to join the group once you register for the event.

Tickets

  • Professionals

    ₹299.00
    Tax: 18% Tax included
    Sale ended

Total

₹0.00

Share this event

bottom of page