top of page
Sun, 17 Dec
|Online Video Conference
Excelerate
Advance Excel for Engineering Professionals!
Registration is closed
See other eventsTime & 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:
- ROUND() vs. ROUNDUP() & ROUNDDOWN()
- COUNT() vs. COUNTA() & COUNTBLANK() vs. COUNTIF
- DAY(), MONTH(), YEAR(), DATE()
- TEXT()
- WEEKDAY(), WORKDAY(), NETWORKDAYS()
- WORKDAY.INTL() for deadline/due date calculations w. custom weekends/holidays
- NETWORKDAYS.INTL() for no. of business days calculations w. custom weekends/holidays
- TODAY() and NOW() w. Shortcut
- Text Formulas – Using CONCATENATE
- Text Formulas – LEFT(), RIGHT() & SEARCH() - 1
- Text Formulas – MID() & LEN()03:41
- Text Formulas – REPLACE() & SUBSTITUTE()
- VLookup Rules
- VLookup With Exact Match
- VLookup Approximate Match
- VLookup With Trim
- H-Lookup
- Hyperlink To Sheet, File, Webpage, External links
- Print Page Setup, Header & Footer
- Data Sorting
- Advanced Filters
- Filtering Data
- Basic Table
- Advanced Table
- Conditional Formatting: Formula-based (Colored rows based on user input)
- Pivot Table Examples 1, 2, 3
- Data Validation
- 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:
- How to create online forms which allow you to gather data from individual team members
- How to automate Excel tasks with time-saving macros
- How to remove duplicates from data in Excel
- VBA Macro - Making use of Excel for business purposes - Purchase Order Generator, Invoice/Billing,
- 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.00Tax: 18% Tax includedSale ended
Total
₹0.00
bottom of page