.jpg){kind=logo}
ECDL-EXCEL2019.AA1
ECDL Excel Labs
Self-paced · 1 year access
56 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
1 Interactive Lessons · 1 topics01 MS Excel 1 topics · 56 LiveLab +
- Excel 2019
56 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
56 LiveLabs- Applying Conditional Formatting
- Formatting Numbers
- Splitting Text to Columns
- Copying and Moving Worksheets between Spreadsheets
- Splitting a Window, Moving, and Removing the Split Bar
- Hiding or Showing Rows or Columns in a Worksheet
- Saving a Spreadsheet as a Template and Modifying a Template
- Using Date and Time Functions
- Using Logical Functions
- Using Mathematical Functions
- Using Statistical Functions
- Using Text Functions
- Using Financial Functions
- Using Lookup Functions
- Using Database Functions
- Creating a Two-Level Nested Function
- Using a 3-D Reference in a Formula
- Using Mixed Cell References in Formula
- Creating a Combined Chart
- Creating, Changing, and Deleting a Sparkline
- Adding a Secondary Axis to a Chart
- Changing the Chart Style
- Adding and Deleting a Data Series in a Chart
- Repositioning Chart Title, Legend, and Data Labels in a Chart
- Changing Scale of the Value Axis
- Changing Display Units on the Value Axis
- Formatting the Chart Elements to Display an Image
- Creating and Modifying a Pivot Table
- Modifying the Data Source and Refreshing the Pivot Table
- Filtering and Sorting Data in a Pivot Table
- Grouping Data in a Pivot Table and Renaming the Group Name
- Using One-Input and Two-Input Data Tables
- Sorting Data by Multiple Columns
- Creating a Customized List and Performing Custom Sort
- Filtering a List
- Applying Advanced Filter Option to a List
- Using Automatic and Manual Outline Features
- Expanding and Collapsing Outline Detail Levels
- Creating a Scenario
- Showing, Editing, and Deleting a Scenario
- Creating a Scenario Summary Report
- Entering an Input Message and an Error Alert
- Tracing Precedents and Dependents
- Adding, Editing, Showing, Hiding, and Deleting Comments in a Worksheet
- Creating and Deleting the Name for a Cell Range
- Using Named Range in a Function
- Activating and Deactivating the Group Mode
- Using Paste Special Options to Perform Arithmetic Calculations
- Using Paste Special Options to Copy the Values and Transpose the Data
- Inserting, Editing, and Removing a Hyperlink
- Linking Data Within a Spreadsheet and Between Spreadsheets
- Updating and Breaking a Link
- Importing Delimited Data From a Text File
- Comparing and Merging Spreadsheets
- Protecting and Unprotecting Cells and Worksheet
- Hiding and Unhiding Formulas
Labs run in your browser — nothing to install.
Keep going
You might also like
Prepare for ECDL Excel Labs
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 56 LiveLab included
- Certificate of completion
No credit card required