LF logo
by learnformula
search
Log in
search
Courses/Office Productivity/MS Excel

Mastering Excel 2021 - Intermediate

Learn many of Excel’s tools for analyzing and sharing your data.

Created byBigger Brains
4.3
(6 reviews)
IntermediateUpdated Feb 3, 2025
Mastering Excel 2021 - Intermediate

What You'll Learn

check_circleUse Flash Fill, Text to Columns, and Group Mode to work with your data
check_circleUse editing features such as Find and Replace, proofing options, and research tools to refine your workbook
check_circleModify workbook views
check_circleApply conditional formatting to text, numbers, and dates
check_circleApply custom number formatting
check_circleUse nested, logical, and statistical functions
check_circleModify and format charts
check_circleAdd sparklines, pictures, and SmartArt
check_circleModify Tables, PivotTables, and web queries
check_circleShare workbooks
check_circleUse tools to enhance sharing such as hyperlinks, track changes, and comments

About This Course

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.

Your Instructors

Bigger Brains
Bigger Brains

Powering Productivity, One Brain at a Time!

menu_book116 courses
star3,794 reviews

Combining TV-style video production with modern graphics and animation, Bigger Brains courses are popular with both learners and training professionals around the world. Our top teachers and subject matter experts have real-world experience and create the most realistic and comprehensive training courses possible. Bigger Brains courses are built in a unique “Teacher/Learner” style, featuring two people on camera to recreate some of the interactivity and physiological benefits of classroom training, including dialogue, humor, and practical use case examples. This Uniquely Engaging™ video-based format is more enjoyable and more effective than traditional eLearning formats.

Kathy Jones
Kathy Jones

Certified Trainer

Kathy is a Microsoft Certified education/training professional with experience in all aspects of training. Her strengths include classroom presentations, organizational skills, problem-solving, program design and development, and interpersonal communication.

Credit Information

Do these courses count toward my professional development requirements?

This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.

If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.

What Students Are Saying

4.3
Student's Choice
6 reviews

Frequently Asked Questions

We are a registered provider with 327+ associations and regulatory bodies worldwide. We operate across 29 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.