1-on-1 Microsoft Excel Training for Intermediates

1-on-1 Microsoft Excel Training for Intermediates

by Jupiter Training & Consulting

380 AED

(VAT inclusive)

1-on-1 Microsoft Excel Training for Intermediates

380 AED

(VAT inclusive)

when:
Flexible Dates
where:
Sharjah - Al Nahda
level:
Intermediate
Validity Period: All sessions are valid for 45 days upon booking
We offer a best price guarantee for our classes. If you get a better price, let us know & we'll give you a free AED 100 voucher.
Description:

Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool. This private 8-hour program (4 sessions x 2 hours) will continue your Excel journey with intermediate-level tools and functions.

Learning Outcomes for Intermediate:

  • Provides intermediate level of Excel functionalities
  • Use of advanced features in the software
  • Prepare for specialized fields

Course Topics

  • Functionalities
  • Reporting
  • Charts & Graphs
  • 3 Projects

FULL COURSE OUTLINE: INTERMEDIATE

  • Basic Functionalities
    • Working with tables & Creating table appearance
    • Understanding and creating table structures
    • Validating cell data
    • Advanced Filters
    • Customize the ribbon
    • Making a copy of the formula, formula to values
    • What if Analysis
    • Pivot table
    • Pivot table options
    • Power Query
    • Power Pivot
    • Pivot table analyse and design
    • Working with Pivot Chart
    • Pivot Chart Options
    • Data Analysis with Excel
    • Working with Forecast function and sheet
    • Outline (Group, ungroup)
    • Working with forms and the form tools.
  • Reporting
    • Excel Dashboards
    • Working with slicers
    • Develop user interactive dashboards
  • Charts
    • Advanced concept in charts and reports
    • Waterfall Chart
    • Combo Chart
    • Funnel Charts
    • Box and Whisker Chart
  • Project 1
    • Project related to data analysis based on the subjects studied above
  • Project 2
    • Project related to charting based on the subjects studied above
  • Project 3
    • Project related to Dashboard based on the subjects studied above

Skill Level:

Intermediate

Materials:

All materials will be provided

Validity Period:

All sessions are valid for 45 days upon booking

Age Requirements:

10 and older

Additional Info:

  • Certificate of participation will be awarded upon completion
  • Optional KHDA certificate can be awarded with an additional fee payable directly to the instructor

  • This course can also be taken online

Location:

Office #1007
Al Mansoor Tiger Tower
Al Nahda
Sharjah

Register for the class
Schedule
# Sessions
Price
View all dates

Each session takes 2 hours

After booking this class you will be contacted by the instructor to set your schedule as per your availability.

Instructor's working hours
SunMonTueWedThuFriSat
9:00AM
To
9:00PM
12:00PM
To
9:00PM
12:00PM
To
9:00PM
12:00PM
To
9:00PM
12:00PM
To
9:00PM
12:00PM
To
9:00PM
9:00AM
To
9:00PM
Share this class:

Categories