Professional DevelopmentMastering Excel 2021 – Intermediate

Mastering Excel 2021 – Intermediate

SKU: RVBB-3437
Duration: 3.43 Hrs

Learn many of Excel’s tools for analyzing and sharing your data Microsoft Excel is the most popular data analysis tool in the workplace, so using it effectively is a crucial skill for any business professional. In this course you’ll learn great tools to modify your data and refine your workbook. Excel expert Kathy Jones will also show you how to nest functions and modify and format charts.

You’ll even learn to enhance your visualizations by adding sparklines, pictures, and SmartArt. And if you need to work with others, you’ll learn some great tools available when sharing your workbooks, including comments, hyperlinks, track changes, and share options.

Request a demo

Course Details

Learning Objectives

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

  • Use Flash Fill, Text to Columns, and Group Mode to work with your data
  • Use editing features such as Find and Replace, proofing options, and research tools to refine your workbook
  • Modify workbook views
  • Apply conditional formatting to text, numbers, and dates
  • Apply custom number formatting
  • Use nested, logical, and statistical functions
  • Modify and format charts
  • Add sparklines, pictures, and SmartArt
  • Modify Tables, PivotTables, and web queries
  • Share workbooks
  • Use tools to enhance sharing such as hyperlinks, track changes, and comments
  • Analyze data with Goal Seek and Data Tables

Specs

Course Level Intermediate
Languages English
Compatibility Audio, Video, MobileReady, Responsive

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