Get this product (A$66.00)

Productivity and Soft Skills

14 MUST KNOW Microsoft Excel Functions (CPE73)


Description
Objective: The 14 MUST Know Microsoft Excel Functions is designed to provide students with foundational skills to understand a range of basic to more advanced functions for performing calculations in Excel spreadsheets,

This short course covers 14 Microsoft Excel Functions every Excel user should know.
Includes demonstration file and downloadable quick reference sheets on each function.

Accreditation: Approved CPE Details/Format: Online Outcome/Learning: Master a range of common Microsoft Excel... Type: Structured Evidence of Completi...: Certificate CPE Hours: 1

Content
  • Introduction and Working File
  • 1 - SUM Function
  • Excel 365 - SUM Function Reference Sheet
  • 2 - Trim Function
  • Excel 365 - Trim Function Reference Sheet
  • 3 - Concatenate Function
  • Excel 365 - Concatenate Function Reference Sheet
  • 4 - Proper Function
  • Excel 365 - Proper Function Reference Sheet
  • 5 - Average Function
  • Excel 365 - Average Function Reference Sheet
  • 6 - Today Function
  • Excel 365 - TODAY Function Reference Sheet
  • 7 - COUNT Function
  • Excel 365 - COUNT Function Reference Sheet
  • 8 - COUNTA Function
  • Excel 365 - COUNTA Function Reference Sheet
  • 9 - COUNTBLANK Function
  • Excel 365 - COUNTBLANK Function Reference Sheet
  • 10 - IF Function
  • Excel 365 - IF Function Reference Sheet
  • 11 - SUMIF Function
  • Excel 365 - SUMIF Function Reference Sheet
  • 12 - COUNTIF Function
  • Excel 365 - COUNTIF Function Reference Sheet
  • 13 - ROUND Function
  • Excel 365 - ROUND Function Reference Sheet
  • 14 - VLOOKUP Function
  • Excel 365 - VLOOKUP Function Reference Sheet
  • BONUS Function - XLOOKUP Simple
  • BONUS Function - XLOOKUP with Text for Errors
  • BONUS Function - XLOOKUP with Wild Card Characters
  • BONUS Function - XLOOKUP Specifying Search Order
  • Excel 365 - XLOOKUP Function Reference Sheet
Completion rules
  • All units must be completed
  • Leads to a certificate with a duration: Forever
Back