Microsoft Excel: Excel 2021 Beginner Intermediate

Microsoft Excel 2021 Beginner & Intermediate.

Discover our comprehensive Excel 2021 e-learning course, delivered in a virtual Office 365 cloud environment. This training covers Excel VBA, Excel Data Analysis, Excel PivotTables, and Excel for Financials, as well as Excel Basics for Beginners and Excel Advanced/Expert. You'll learn through practical exercises and interactive videos with voice and captions. Your progress is analyzed in real time and tracked through detailed reports.

This course, developed by experienced MOS instructors and published by a Microsoft Gold Partner, prepares you for the MOS exam. Upon completion of more than 70% of the course, you will receive a certificate of participation. The content is SCORM-compliant and integrates with Microsoft Office 365, Microsoft Power Automate, and Power Apps, deepening your knowledge of Microsoft Office and Office 365.

• Objective: Fully master Excel, from basic to advanced level, covering topics such as data entry, formatting, calculations, charts, managing large tables, pivot tables, and advanced functions.
  
• Target audience: Beginners with some basic knowledge who want to master the basic functions of Excel.
  
• Level: Beginner and Intermediate
  
• Required knowledge level:** Basic computer skills
  
• Course duration: 10 hours (Video clips averaging 2-5 minutes, depending on personal speed)
  
• Language:  English
  
• Online access: 24/7, 365 days after activation
  
• Includes: Online book and Certificate of Participation

Beginner

Introduction to Excel, filling in a table

• What you need to know about: Spreadsheets
• Opening workbooks
• General work environment
• Moving within a workbook
• What you need to know about: Data entry assistance
• Entering data
• What you need to know about: Selecting, copying, and moving
• Selecting and deleting cells
• Undoing and redoing actions
• Column width and row height
• What you need to know about: Saving files
• Saving workbooks
• Adjusting cell content
• Creating a new workbook

Make your first calculations

• Entering formulas
• Sum and other simple calculations
• Calculating percentages
• Copying to adjacent cells
• Simple number formats
• Applying a theme
• Text formatting
• Font and font size
• Aligning cell content
• Cell color
• Cell borders

Print and set up page layout for your worksheets

• Page layout
• Print preview and printing
• Page breaks
• Print area
• What you need to know about: Headers and footers
• Headers and footers

Work more efficiently with Excel

• Using Excel help
• Spell check
• Find and replace
• Zoom in and out
• Inserting or deleting rows, columns, and cells
• Moving cells
• Copying to non-adjacent cells
• Quickly copying cell formatting
• Merging cells
• Printing cell content orientation
• Cell styles
• Sorting a table
• Worksheet name and tab color
• Inserting, deleting, and setting the background of worksheets
• Moving, copying, and hiding worksheets
• Freezing columns/rows, splitting the screen
• Repeating column and row titles
• Hiding items on the worksheet
• Grouping data in an outline

Intermediate

Transition to complex tables

• Displaying multiple lines in a cell
• Absolute references in a formula
• Copying and transposing calculation results and links
• What you need to know about: Entering functions
• System date and date format
• Simple conditions
• Custom formats
• Applying conditional formatting
• Managing conditional formatting
• Naming a cell range
• Validation criteria
• Cell ranges in functions

Present your data in chart form

• What you need to know about: Charts
• Creating and moving a chart
• Managing a chart
• Selecting chart elements
• Adding or removing chart elements
• Formatting chart elements
• Changing chart text elements
• Legend and plot area
• Printing a chart and page layout

Improve the appearance of your charts

• Changing data labels
• Data series and chart axes
• Managing series
• Chart type options
• Managing chart templates
• Creating a 2D map chart
• Creating a sparkline chart
• Managing sparklines

Enhance your tables

• Creating a graphic object
• Selecting and deleting objects
• Copying and moving objects
• Resizing a graphic object
• Modifying a text box
• Editing a shape
• Formatting drawing objects
• Inserting an image
• Managing images
• Rotating and aligning objects
• Overlapping and grouping objects

Utilize your data

• What you need to know about: Flash Fill
• Calculating subtotals
• Creating and managing a data table
• Formatting and sorting a data table
• Adding calculations to a data table
• Auto filter
• Custom filters
• Empty and duplicate values
• What you need to know about: Criteria ranges
• Filtering with criteria range
• Filtering and copying rows with criteria range
• Calculations with criteria range
• Sorting and filter functions

Create and use pivot tables and charts

• What you need to know about: Pivot tables and charts
• Creating a pivot table
• Modifying a pivot table and adding calculations
• Changing pivot table source
• Selecting, copying, moving, and deleting a pivot table
• Structuring and printing a pivot table
• Formatting a pivot table
• Filtering a pivot table
• Filtering with slicers
• Basing a pivot table on multiple data tables
• Adding fields or calculated elements
• Grouping pivot table data
• Creating a pivot chart

Excel 2021: Cases

This module offers a 48-minute video.

Set up a quality control

• Presentation of the use case
• Creating statistical formulas
• Preparing the chart
• Creating a control chart
• Adjusting the control chart display
• Conclusion

Analyze library visits

• Presentation of the use case
• Creating the Development of Visitor Numbers chart
• Creating pivot tables
• Conclusion

Track budget

• Presentation of the use case
• Creating pivot tables
• Creating charts
• Creating the dashboard
• Conclusion

Reduce costs

• Presentation of the use case
• Creating formulas
• Solving the problem with Solver
• Conclusion

Office 2021: Cases

Excel, Word, or PowerPoint with an Office 365 subscription

This module offers a 20-minute video.

• Creating an email with or without an Office 365 subscription: what are the differences?
• Creating and saving Office documents in OneDrive, SharePoint Online, or Teams
• Editing a document from OneDrive, SharePoint, or Teams
• Sharing Office documents with colleagues or external persons
• Collaborating on a file

Excel 2021: The Reference Work

This comprehensive reference work provides a detailed overview of all the functions of the widely used spreadsheet program Microsoft® Excel, version 2021. It is intended for anyone who wants to learn to use this program or expand their knowledge about it.