Skip to content Skip to sidebar Skip to footer

Mastering Excel 2021 – Basics

Mastering Excel 2021 – Basics

Learn how to use the world's most popular software tool for analyzing and reporting on data. When you master Excel, you have one of the most practical

What you'll learn

  • Open and save existing workbooks
  • Manage rows, columns, and worksheets
  • Create and use named ranges
  • Add logical and conditional functions
  • Address formula errors
  • Apply cell and number formats, including cell styles and themes
  • Modify charts
  • Create Tables and PivotTables
  • Configure page settings and headers/footers for printing

Go Link 

Users who know the basic elements of Excel 2021 

Course Goal: Users will know how to use and customize the basic elements of Excel 2021 and start performing data analysis.

You will be able to:

  • · Open and save existing workbooks
  • · Manage rows, columns, and worksheets
  • · Create and use named ranges
  • · Add logical and conditional functions
  • · Address formula errors
  • · Apply cell and number formats, including cell styles and themes
  • · Modify charts
  • · Create Tables and PivotTables
  • · Configure page settings and headers/footers for printing

Go beyond the basics of data entry to analyze your data and create visually appealing workbooks.

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 to make your spreadsheets easily readable and visually appealing, while including complex functions and summary reports. Excel expert Kathy Jones will also show you how to address function errors, customize your charts, and create and use tables and PivotTables to easily manipulate and summarize your data.

Topics covered include:

  • · Managing rows, columns, and worksheets
  • · Creating and using named ranges
  • · Adding logical and conditional functions
  • · Addressing formula errors
  • · Applying cell and number formats, including cell styles and themes
  • · Modifying charts
  • · Creating Tables and PivotTables
  • · Configuring page settings and headers/footers for printing

Almost 3 hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

Online Course CoupoNED based Analytics Education Company and aims at Bringing Together the analytics companies and interested Learners.