Mastering Excel 2019 – Intermediate

Become proficient in using the world’s most popular software tool for organizing and analyzing data.

When you master Excel, you have one of the most practical and valuable skillsets in modern business. You can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course builds on your existing Excel knowledge and teaches you how to efficiently manage data using charts and tables, and how to use powerful reporting tools such as Pivot Tables, Pivot Charts, Slicers, Timelines, and more.

Request a demo

Course Details

Learning Objectives

By the end of this course, you will be able to:

  • Create and use named ranges
  • Insert functions into spreadsheets including Date and Time functions, Logical functions, Text functions, Math functions, Database functions, Subtotals, and nested functions
  • Sort and filter data
  • Create and modify tables
  • Apply advanced Conditional Formatting
  • Create and modify charts and graphics, and apply advanced charting tools
  • Create a Pivot Table
  • Use advanced Pivot Table tools, create a Pivot Chart, and filter data using Slicers and Timelines

Specs

Course Level Intermediate
Languages English
Compatibility Audio, Video, MobileReady

Bigger Brains

In 2009, Bigger-Brains founder Chip Reaves was tasked with creating an online training platform for Computer Troubleshooters, a global franchise network. As is the case with most companies, some of the training content was unique to their business, but others (Quickbooks, Online Marketing, Microsoft Office, etc) could be used by many companies. Frustrated with the poor quality, high prices, and lack of selection in the eLearning marketplace, Chip brought together a team to research the characteristics of effective training. The result is Bigger Brains" "Uniquely Engaging" teacher/learner format, which replicates the dialogue, interaction, humor, and personal connection of traditional classroom training with the "always available" convenience and searchability of eLearning. Today Bigger-Brains continues to create the "Absolute Best Online Training" from our studios in Anderson, South Carolina.

Course Applies To

Demos + Pricing

Learn more about our courses, get pricing, and see our platform.

Trusted by 24,000+ Industry Leaders