Microsoft Excel 2021 Free Course

Microsoft Excel is a powerful and widely used spreadsheet application that allows users to manage and analyze data efficiently. The latest version, Microsoft Excel 2021, comes with new features and improvements to help users streamline their work and increase productivity. This software is designed to work with all types of data, from simple lists to complex financial models.

Excel 2021 offers a user-friendly interface with various tools and functions that can help users create, format, and analyze data. The Ribbon interface allows users to quickly access commonly used features, while the Quick Access Toolbar can be customized to include frequently used commands. The Formula Bar provides an easy way to enter and edit formulas, and the Workbook Window displays multiple worksheets and workbooks at the same time.

Excel is used in various industries, such as finance, marketing, healthcare, and education, to name a few. It is a valuable tool for managing budgets, analyzing sales data, creating charts and graphs, and generating reports. With its extensive range of features, Excel 2021 can help users of all levels to manage their data and streamline their workflows. Whether you’re a beginner or an advanced user, Excel 2021 can help you become more productive and efficient in your work.

This Microsoft Excel 2021 course is designed to provide learners with a comprehensive understanding of the latest features and functionalities of the popular spreadsheet software. The course will cover a wide range of topics, from basic spreadsheet management to advanced data analysis techniques. Participants will learn how to create and edit worksheets, apply formatting, use formulas and functions, manage data, and work with charts and graphs. The course will also cover advanced features such as macros, VBA, and pivot tables. By the end of the course, learners will have the skills and knowledge needed to use Excel 2021 effectively and efficiently in their personal and professional lives.

Introduction to Microsoft Excel 2021

Understanding the Excel Interface

Working with Worksheets

Formatting Cells and Data

Modifying Worksheets

  • Inserting and Deleting Cells, Rows, and Columns
  • Renaming and Moving Worksheets
  • Copying and Pasting Data
  • Using the Fill Handle

Formulas and Functions

  • Understanding Formulas and Functions
  • Creating and Editing Formulas

Common Functions

  • Sum, Average, Max, Min
  • Count, Counta, Countif
  • If, And, Or
  • Vlookup, Hlookup
  • Date and Time Functions

Managing Data

  • Sorting and Filtering Data
  • Creating and Using Tables
  • Using PivotTables and PivotCharts

Importing and Exporting Data

  • CSV and TXT files
  • Access and SQL databases

Advanced Formulas, Features and Functions

  • Macros and VBA
  • Array Formulas
  • Financial Functions
  • Lookup and Reference Functions
  • Statistical Functions

Advanced Data Analysis

  • Goal Seek 2
  • Solver
  • Scenario Manager

Working with Charts and Graphs

  • Creating Charts and Graphs
  • Formatting Charts and Graphs
  • Trendlines and Forecasting

Collaboration and Sharing

  • Protecting Workbooks and Worksheets
  • Sharing Workbooks and Worksheets
  • Co-Authoring
  • Comments and Notes

Leave a Reply

Your email address will not be published. Required fields are marked *