Microsoft Excel 2021 - Excel 365 Advanced + Expert

Excel 365 Advanced + Expert

Deepen your knowledge of the advanced and expert functions of Excel 365. 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:

Advanced

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.