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

VIRTUALCLASS Basic to Advanced MS Excel Training

Oct 24, 2020 - Oct 25, 2020
VIRTUALCLASS Basic to Advanced MS Excel Training

Time Sat Oct 24 2020 at 05:30 am to Sun Oct 25 2020 at 09:00 am

(add to calendar)

Online

PHP 735
Advertisement

VIRTUALCLASS Basic to Advanced MS Excel Training | Online Event | AllEvents.in VIRTUALCLASS Basic to Advanced MS Excel Training
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 from Oct 24-25, 1:30PM-5PM via MS Teams.
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



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

Tickets

Tickets for VIRTUALCLASS Basic to Advanced MS Excel Training can be booked here.

Ticket Information Ticket Price
Regular Ticket PHP 840
Early Bird PHP 735
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
Advertisement
Report a problem ?

Event Information

Date & Time

Oct 24, 2020 - Oct 25, 2020
Add to Calendar

Date & Time

Sat Oct 24 2020 at 05:30 am to Sun Oct 25 2020 at 09:00 am
Add to Calendar

Location

Online

Advertisement
Advertisement

Planning for an event?

List your events for free and make sure your audience never miss an event from you!

Create Events