Microsoft Excel 2016 Training - ITU Online
Get Lifetime Training At 60% Off

Future proof your IT career with our LIFETIME IT training option.  Start today with over 2,500 hours of focused IT training.  Plus, you’ll receive all new and updated content for life at no additional cost.

Lock In At Our Lowest Price Ever: $14.99/month for 2,500+ hours of IT training.
Limited time only. Enroll now, cancel anytime!

Microsoft Excel 2016 Training

In this course you will learn how to use Microsoft Excel 2016 more effectively whether you are using it at home or in the workplace. Understand how to manipulate data within a spreadsheet, validate and present information using the built in structure and functions of Microsoft Excel. This Microsoft Excel 2016 training course covers basic, intermediate and advanced competency levels.

Included In This Course

Included In This Course

Total Hours
9  Training Hours
Microsoft Excel 2016 Training
32 On-demand Videos
Closed Caption

Closed Captions

Course Topics
3  Topics
Prep Questions
148 Prep Questions
Microsoft Excel 2016 Training

Certificate of Completion

Course Description

Note: Even though this course is based on an older version, it is still a worthwhile resource for online learning and training.

About our online Microsoft Excel 2016 Training course

Our comprehensive Microsoft Excel 2016 video tutorials training course for beginner to advanced will equip you with the most current and actionable tips and strategies for using this renowned software platform. Packed with hours of video content full of useful knowledge, but free from unnecessary filler content, the course is regularly updated so that your skills stay up-to-date with any changes in Microsoft Excel. Enroll today and unlock its powerful potential!

Are you ready to begin your Microsoft Excel journey? Start off by receiving an overview of the course and understanding how to launch it. Then, open up a world of possibilities with mastering worksheet basics and acquire some novice Excel tactics!

Once you have a comprehensive understanding of the fundamentals, enter and manipulate columns and rows, select cells & ranges, use formulas and shortcuts to copy/move data. Additionally comprehend how fill handles work in naming ranges, formatting worksheets contents plus working on table filters. As your excel knowledge expands learn about function (like accounting functions or AVERAGE function) & what-if analysis; how to find & fix errors while protecting your workbooks and working across multiple sheets or creating charts!

Upon completion of our Learn Microsoft Excel course, you will have the knowledge and skills to:

  • Mastering Excel is essential for productivity and efficiency. Learn the best practices to maximize your use of this powerful program.
  • Gaining an understanding of worksheet fundamentals and mastering keyboard shortcuts can take your productivity to the next level.
  • Discover the power of manipulating columns and rows.
  • Discover the procedures for entering and altering diverse data types such as text, numbers, dates, and symbols.
  • Enhance your skills in Excel by mastering the art of selecting cells and ranges, as well as discovering foundational formulas, financial functions, basic stats functions, and more.
  • Streamline your workflow by leveraging the fill handle – you’ll save yourself precious time in terms of copying and moving files!
  • Designate names to specific cells or groups of cells and unlock the power of SUM, as well as numerous other functions.
  • Master the art of formatting your Excel worksheets like an expert!
  • Master the art of transforming a massive Excel file for printing and take your skills to the next level.
  • Master data handling by creating tables, pivot tables and charts while actively safeguarding your work.

About Microsoft Excel

Microsoft Excel is the standard spreadsheet application for both personal and business use, so staying on top of the latest version is very important for anyone considering career advancement. Regardless of your level of understanding, you will benefit from this Microsoft Excel 2016 training course because it covers basic, intermediate, and advanced competency levels.

Our Microsoft Excel 2016 training course will help arm you with the knowledge to use it more effectively whether you are using it at home or in the workplace. Understand how to manipulate data within a spreadsheet, validate and present information using the built-in structure and functions of Microsoft Excel.

Proudly Display
Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Example Certificate

Course Outline

Microsoft Excel 2016 Course Content

Excel 2016 Basic

  •    Tabs And Ribbons Part1

  •    Tabs And Ribbons Part2

  •    Cells Part1

  •    Cells Part2

  •    Cells Part3

  •    Cells Part4

  •    Calculations Part1

  •    Calculations Part2

  •    Calculations Part3

  •    Printing Part1

  •    Printing Part2

Excel 2016 Intermediate

  •    Menus And Keyboard Shortcuts Part1

  •    Menus And Keyboard Shortcuts Part2

  •    Menus And Keyboard Shortcuts Part3

  •    Tabs Part1

  •    Tabs Part2

  •    Formulas And Calculations Part1

  •    Formulas And Calculations Part2

  •    Formulas And Calculations Part3

  •    Formulas And Calculations Part4

  •    Importing Data Part1

  •    Importing Data Part2

  •    Invoices

Excel 2016 Advanced

  •    Advanced Invoice Part1

  •    Advanced Invoice Part2

  •    Advanced Invoice Part3

  •    Advanced Invoice Part4

  •    Number Crunching

  •    Creating A Pivot Table From Scratch

  •    Smaller Excel Components Part1

  •    Smaller Excel Components Part2

  •    Smaller Excel Components Part3

Add a review
Microsoft Excel 2016 Training Microsoft Excel 2016 Training
* Rating is required
Your review
* Review is required
* Name is required
Based on 56 reviews
5 star
4 star
3 star
2 star
1 star
1-5 of 56 reviews
  1. So far all is good

  2. I have signed up for a lot of your courses so it will take me time to get through them all but I am so pleased with what I have already started with. THANK YOU!

  3. Great Assistance. Thank you

Your Training Instructor

Josh Schofer

Josh Schofer

Cybersecurity | Cloud Trainer

Josh has 15 plus years in account management and client support with over 5 years specifically in the healthcare industry. Josh provides hands-on leadership to the healthcare team at NetDirector by focusing on client success and innovative solutions. As the Healthcare Operations Manager, Josh ensures that each client implementation is completed as efficiently as possible with the greatest impact to the client. He holds a Bachelor of Arts degree from the University of South Florida.

Microsoft Excel 2016 Training



Subscribe To All-Access

Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.00 $14.99 Monthly

Microsoft Excel 2016 Training

Microsoft Excel 2016 Training
Microsoft Excel 2016 Training
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.

Monthly All-Access Subscription
7 Days Free - $39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses

Microsoft Excel 2019 Training


Master Microsoft Excel with our comprehensive online course. Learn formulas, functions, and more in this hands-on training series. Enroll now!

Microsoft Excel is the go-to spreadsheet application, no matter if you’re using it personally or professionally. Whether your knowledge of Microsoft Excel is beginner’s level or advanced, this Microsoft Excel 2019 Training online course will help take your abilities to a new height – covering topics from basic to intermediate and even advanced.

Microsoft Word 2016 Training


Master Microsoft Word with ITU Online’s Microsoft Word Online Course. Learn at your own pace and advance your career with this essential software skill.

This Microsoft Word 2016 training course will teach you how to improve your Microsoft Office Word 2016 skills. You will learn how to maximize this industry standard word processing system by mastering document creation. This online training course will cover Basic Word 2016, Intermediate Word 2016 and Advanced Word 2016.

Microsoft 70-412: Configuring Advanced Windows Server Services


Advance your IT career with Microsoft 70-412 training course. Learn how to configure advanced Windows Server 2012 services with ITU Online.

In this Microsoft 70-412: Configuring Advanced Windows Server Services course you will learn how to perform the advanced configuring tasks required to deploy, manage, and maintain a Windows Server 2012 infrastructure, such as fault tolerance, certificate services, and identity federation.