uCertify

ECDL Excel Labs

(ECDL-EXCEL2019.AA1)
Lab
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

MS Excel

  • 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

Related Courses

All Courses