Existing User Login

New User? Create An Account

Request new password

We Are All About You

XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.

This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

courses popup callback

E-COURSE:

Microsoft Excel 2016

Instructor-led video course with presentations, workbooks, games, flashcards and quizzes.
Overview
This Microsoft Excel 2016 training course will teach you fundamental and advanced spreadsheet skills. With real-world examples taken from a business environment, you'll learn about number formats, data visualization, PivotTables, What-If Analysis, Forecasting, 3D maps, and more.

Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do. This includes the 7 most popular functions.
Objectives
  • Spreadsheets
  • Tables
  • Ranges
  • Pie, Column, Bar and Line charts
  • Pivot tables
  • Pivot charts
  • Tons of tips and tricks to make using Excel 2016 easier every day.

Excel Beginner

1.1 Tabs And Ribbons Part 1

1.2 Tabs And Ribbons Part 2

1.3 Cells Part 1

1.4 Cells Part 2

1.5 Cells Part 3

1.6 Cells Part 4

1.7 Calculations Part 1

1.8 Calculations Part 2

1.9 Calculations Part 3

1.10 Printing Part 1

1.11 Printing Part 2

Excel Intermediate

1.1 Menus And Keyboard Shortcuts Part 1

1.2 Menus And Keyboard Shortcuts Part 2

1.3 Menus And Keyboard Shortcuts Part 3

1.4 Tabs Part 1

1.5 Tabs Part 2

1.6 Formulas And Calculations Part 1

1.7 Formulas And Calculations Part 2

1.8 Formulas And Calculations Part 3

1.9 Formulas And Calculations Part 4

1.10 Importing Data Part 1

1.11 Importing Data Part 2

1.12 Invoices

Excel Advanced

1.1 Advanced Invoice Part 1

1.2 Advanced Invoice Part 2

1.3 Advanced Invoice Part 3

1.4 Advanced Invoice Part 4

1.5 Number Crunching

1.6 Creating A Pivot Table From Scratch

1.7 Smaller Excel Components Part 1

1.8 Smaller Excel Components Part 2

1.9 Smaller Excel Components Part 3

E-COURSE Expert-led video course with presentations, workbooks, quizzes, games and flashcards.
  • 09:04:05+ Hours Of learning
  • Includes video, presentations, workbooks, quizzes, flashcards & games
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months access
  • 10-Day money-back guarantee
Back to Top