Microsoft Excel: Excel 2021 with Pre-test (Beginner to Expert)

Excel 2021 Beginner + Intermediate + Expert with Pre-test 

Deepen your knowledge of the advanced and expert functions of Excel 2021. You work online with interactive videos, spoken explanations, subtitles and assignments that are automatically checked.

You can see your progress immediately and receive targeted feedback.

Including free video course: Microsoft Copilot. This extra training shows you how to work smarter and faster with AI within Microsoft 365.

After completing 70% of the training, you will receive a certificate of participation.

Course Content:

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

Expert

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.