Create Event
Search results for:
No result found! Try with different keywords!
Advertisement
Advanced Excel Training Masterclass Course

Advanced Excel Training Masterclass Course

Jun 27, 2022 - May 27, 2023

Advanced Excel Training Masterclass Course

Time Mon Jun 27 2022 at 01:00 am to Sat May 27 2023 at 05:30 pm

(add to calendar)

Online

Find Tickets
USD 88
Advertisement

Advanced Excel Training Masterclass Course | Online Event | AllEvents.in Advanced Excel Training Masterclass Course
The advanced Excel course helps you to automate spreadsheets, work with advanced functions and reports using pivot tables and pivot charts

About this Event

This practical, 4 day Advanced Excel Training Masterclass focuses on the MS Excel skills that the typical business user would require.

This Online Advanced Excel Training Course is Instructor-led live, interactive online training with certificate of completion.

Course Content

Module 1: Customising Excel

  • Customising the Ribbon
  • Changing defaults

Module 2: Database Essentials

  • What is a Database
  • Correct Data Input
  • Using the Get and Transform Data
  • Sorting a list
  • Filtering a list
  • Data Forms
  • Setting Data Validation
  • Custom Number formats

Module 3: Excel tools

  • Linking Worksheets
  • Data Consolidation
  • Using hyperlinks
  • Protecting Worksheets, Workbooks and Files

Module 4: Advanced functions

  • Creating and using Range Names
  • =And, =Or
  • =If and Nested IF statements
  • =iferror
  • =Sumif and =Countif
  • =Sumifs and =Countifs
  • =Vlookup among other functions

Module 5: Pivot Table Reports

  • Creating a pivot table
  • Filter/Show and Hide Pivot Table data
  • Using slicers
  • Rearranging Pivot Tables:
  • Grouping fields
  • Moving fields
  • Collapsing and Expanding fields
  • Refreshing data
  • Using Show Value As
  • Adding Subtotals and Grand Totals
  • Formatting field settings
  • Applying a Pivot Table Style
  • Creating a new custom Pivot table style
  • Creating a PivotChart

Module 6: Macros

  • Recording a macro
  • Relative and Absolute References
  • Editing and Deleting macros
  • Running a macro
  • Assigning macros to objects
  • Assigning macros to a toolbar

You can get details of Launch Hub Certification Training Courses Here

or reach us at:

Email: aW5mbyB8IHByb2plY3RjZW50ZXJlZCAhIGNvbQ==

Call us - +254 707 260 205

Advanced Excel Classroom Training, Live Online Training and Weekend special classes are also offered,

To know about the dates, prices, and offers, chat with us now or send a query

Other Trainings offered include: Advanced Excel Training Masterclass Course; Ms. Project Masterclass; Project Management Professional; Product Management Masterclass; Ultimate Startup Guide for successful Startups.

We also offer consultancy Services in Project Management get more info here:




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

Tickets

Tickets for Advanced Excel Training Masterclass Course can be booked here.

Get Tickets

Ticket Information Ticket Price
General Admission USD 110
Early Bird USD 88
Event Photos
Hosted by
Are you the host?
Advertisement
Event details from Report a problem ?

Event Information

Date & Time

Mon Jun 27 2022 at 01:00 am to Sat May 27 2023 at 05:30 pm
Add to Calendar

Location

Online

Advertisement
Advertisement

Event Marketing