IC0974

Excel 2016 Intermediate

This course takes you well beyond the beginner stage to become an Excel power user. Learn the additional advanced skills you need to become more valuable at work. You will learn more advanced ways of working with data, how to master charts and graphs and how to work with dynamic formulas and named ranges. The course includes great exercise files as takeaways.


Course Goal

  • Start your journey in data analysis in Excel
  • Learn all about LOOKUP functions and INDEX MATCH
  • Master dynamic formulas
  • Bring your data to life with brilliant charts and graphs
  • Start using PivotTables and Power Query

Who This Training Is For

  • All

Exam/Certificate

  • Certificate of Completion (more certification info)
  • Upon successful completion of this course, receive your Excel 2016 Intermediate certificate

Instructor

Simon Calder

4.7 Average Rating

98 Reviews

688 Students

21 Courses

Simon Calder

Teaching Business Software

Chris "Simon" Calder was working as a Project Manager in IT for one of Los Angeles's most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course which he sold on DVD via eBay. Fast forward to now and Simon Sez IT has taught hundreds of thousands of students through its online course platform and popular YouTube channel.

Students Also Bought:

Basic SAP Skills for Beginners
Basic SAP Skills for Beginners

This introductory course teaches you the basics of SAP and puts you on a path to developing highly sought-after, high...

4.5

Average Rating

Complete Excel 2019 for Beginners
Complete Excel 2019 for Beginners

This Excel course is perfect for those who are new to Excel and who are using Excel 2019 or Excel 365 editions. In th...

4.8

Average Rating

SAP S/4 HANA - Basic Navigation
SAP S/4 HANA - Basic Navigation

Your path to specializing in SAP S/4 HANA starts here. Perform hands-on simulations to learn the basics of SAP S/4 HA...

4.5

Average Rating

View All Courses

Student Feedback

4.6

Average Rating

Reviews

Language: English
Level: Intermediate
Duration: 4.5 hours
Type:  Instructor-led
Releases: Enterprise Software
Category: Microsoft

Training 5 or more people?

Unlimited access for your entire SAP team.

SAP Training for Businesses