Create Event
Search results for:
No result found! Try with different keywords!
Advertisement
Basic to Advanced MS Excel Training (Webinar)

Basic to Advanced MS Excel Training (Webinar)

Mar 06, 2021 - Mar 07, 2021

Basic to Advanced MS Excel Training (Webinar)

Time Sat Mar 06 2021 at 01:30 pm to Sun Mar 07 2021 at 05:00 pm

(add to calendar)

Online

Find Tickets
Advertisement

Basic to Advanced MS Excel Training (Webinar), 6 March | Online Event | AllEvents.in Basic to Advanced MS Excel Training (Webinar)
This interactive live webinar training includes a thorough discussion of the basic and advanced topics.

No Paypal, no problem! Pls email aW5xdWlyZSB8IGluc2lnaHRzbWFuaWxhICEgY29t or chat www.facebook.com/InsightsManila for other payment options.
This training is on March 6-7, 1:30PM-5PM via Zoom.
Outline:
Part 1. Basic to Advanced MS Excel Functions
-Text Functions
-Combining Texts
-Changing Case
-Other Accessory Text Functions
-Logical Functions
-Basic IF Statements
-Nested and Series IF Statements
-Combining IF with Other Functions
-Math and Date Functions
-Basic Math Functions
-Named Ranges
-Conditional Math Functions
-Shortening Long Formulas with Arrays
-Advanced Lookup Functions
-VLOOKUP
-Advanced Usage of VLOOKUP
-INDEX and MATCH
Part 2. Exploring the Data Tab Tools
-Conditional Formatting
-Basic Conditional Formatting
-Formula-Based Formatting
-Data Validation
-Creating Basic Dropdown Menus and Cell Validations
-Advanced Dropdown Menus
-Subtotal Tool
-Text-to-Columns
Part 3. Analyzing Data Using PivotTables
-Basic PivotTable Features
-Tables
-Grouping Data
-Using Slicers
-Calculated Fields
-PivotCharts



You may also like the following events from Insights Training:

Also check out other Workshops in Online, Virtual Events in Online.

Tickets

Tickets for Basic to Advanced MS Excel Training (Webinar) can be booked here.

Get Tickets

Search by related topics in Online
Event Photos
Hosted by
About The Host: Insights Training offers high-quality courses at lower investment because we believe in empowering the workforce with much needed skills to excel!
Website Link: http://www.insightsmanila.com
Are you the host?
Advertisement
Report a problem ?

Event Information

Date & Time

Sat Mar 06 2021 at 01:30 pm to Sun Mar 07 2021 at 05:00 pm
Add to Calendar

Location

Online

Advertisement
Advertisement
Make Your Events Easy to Discover

Create an online presence of your events and make them easy to discover & share with the relevant audience.

Create Events