Microsoft Excel 2010: Advanced Training

Master advanced Excel 2010 features with this comprehensive training course. Learn powerful functions, Macros, Pivot Tables, and more to excel in your skills.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This Advanced Excel 2010 course takes your spreadsheet skills to the next level. You'll learn powerful features like advanced formulas, lookups, and how to visualize data with Pivot Tables and Sparklines. Perfect for those ready to upgrade their Excel game!

Key Points

  • Advanced functions like nested IF statements
  • Calculating using AVERAGEIF and SUMIF
  • Performing lookups with HLOOKUP and VLOOKUP
  • Creating Sparklines and concise visual data
  • Mastering Pivot Tables and Charts
  • Recording and creating Macros

Learning Outcomes

  • Use advanced Excel functions proficiently.
  • Execute complicated data lookups.
  • Visualize data effectively with charts.
  • Automate tasks using Macros.
  • Handle large datasets with ease

About This Course

Master Advanced Excel 2010 Features. Become A Expert And Learn To Use Excel Like A Pro With This Advanced Excel Training

A Verifiable Certificate of Completion is presented to all students who undertake this Excel course.

This Excel 2010 advanced training course, follows up from the Beginners Excel 2010 course by delving even deeper into the features and functions of this powerful spreadsheet software.

Microsoft Excel 2010 is much more than a quick way to add up numbers. In this online course, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP. This tutorial also covers Sparklines, and goes in-depth with Pivot Tables and Charts. Finally, you will learn how to create and record your own Macros.

This advanced Excel video course is not for beginners. You should have a firm grasp of the basics before taking this Advanced Excel training course. By the conclusion of this advanced computer software tutorial for Microsoft Excel 2010, you will have mastered the advanced features and functions of this software. Working files are included to allow you to follow along with the same Excel files the author trains you with.

  • Learn Advanced Microsoft Excel 2010 from a professional trainer from your own desk.

  • 136 lectures (8.5 hours of content) teaching you lookups, advanced IF statements, Macros, Sparklines, and much more!

  • Suitable advanced Excel users. ideal for users who learn faster when shown.

Course Curriculum

Instructor

Profile photo of Infinite Skills
Infinite Skills

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.The emphasis is on teaching real life skills that are essential for...

Review
4.9 course rating
4K ratings
ui-avatar of Rebecca Rasquinha
Rebecca R.
3.5
9 months ago

Well explained

  • Helpful
  • Not helpful
ui-avatar of Thomas McDermott
Thomas M.
5.0
1 year ago

Really learned a lot from this course. Would really recommend it for anyone wanting to master Excel.

  • Helpful
  • Not helpful
ui-avatar of Karmin Canales
Karmin C.
5.0
1 year ago

I loved Guy's style of teaching! He's able to break down complex concepts into simple terms/processes.

  • Helpful
  • Not helpful
ui-avatar of Ronald Henley
Ronald H.
5.0
1 year ago

Subject is covered in an understandable and thorough manner with a little humor here and there.

  • Helpful
  • Not helpful
ui-avatar of Leelambika M
Leelambika M.
4.0
2 years ago

The explanations and illustrations are very clear. Very useful course and the working files comes in handy to practice

  • Helpful
  • Not helpful
ui-avatar of Janine Ellis-Davidson
Janine E.
4.0
3 years ago

I enjoy how the instructor takes time to explain everything and I'm able to walk through the examples and come up with the same results. Actually enjoying learning this way

  • Helpful
  • Not helpful
ui-avatar of Fredrick Dmello
Fredrick D.
5.0
3 years ago

Absolute beauty, this course will be my bread and butter for basic analysis. Ask myself as to why I did not do this course before.

  • Helpful
  • Not helpful
ui-avatar of Raymond Gladue
Raymond G.
4.0
4 years ago

This course explained Excel functions clearly and added to my ability to use Excel. It did not go into great depth on any particular topic so further courses will be necessary for greater Excel proficiency but overall, this was a worthwhile valuable course.

  • Helpful
  • Not helpful
ui-avatar of Ajay Mishra
Ajay M.
4.0
5 years ago

It is made in such a way that gives precise knowledge and information required. It has taken away my Excel Phobia and finally I learnt Advance Excel. Thank you.

  • Helpful
  • Not helpful
ui-avatar of Yvonne Fan
Yvonne F.
5.0
5 years ago

Most of the contents are exactly what I am looking for after being in the analytics field for over a decade. Thank you!

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses