Enrolment options
Guests cannot access this course. Please log in.
Course content
Sections:
12
•
Activities:
0
•
Resources:
45
- 001-Introduction
- 002-Importing Data
- 003-Linking Sheets
- 004-Linking to Another Spreadsheet
- 005-Protecting Sheets and Ranges
- 006-Working with Versions
- 007-Reviewing Accessibility Settings
- 008-What are Range Names
- 009-Creating Range Names
- 010-Using Range Names in Formulas
- 011-Understanding Logical Functions
- 012-Using Logical Statements
- 013-Using AND and OR Functions
- 014-Working with Nested IF Statements
- 015-Using SUMIF AVERAGEIF COUNTIF and More
- 016-Using the IFERROR Function
- 017-Understanding Lookup Functions
- 018-Using VLOOKUP
- 019-Using HLOOKUP
- 020-Using INDEX and MATCH
- 021-Comparing Two Lists with VLOOKUP and IFERROR
- 022-Using CONCAT CONCATENATE and TEXTJOIN
- 023-Splitting Text to Columns
- 024-Using LEFT RIGHT and MID Functions
- 025-Using UPPER LOWER and PROPER Functions
- 026-Using the LEN Function
- 027-Removing Duplicates and Trimming White Space
- 028-Understanding Date Function
- 029-Using TODAY NOW and DAY Functions
- 030-Calculating YEARFRAC and NETWORKDAYS
- 031-Using Data Validation
- 032-Adding Conditional Formatting
- 033-Grouping and Ungrouping Data
- 034-What is a PivotTable
- 035-Creating a PivotTable
- 036-Working with PivotTables
- 037-Creating a Chart from a PivotTable
- 038-Filter Charts and Tables with Slicers
- 039-What are Macros
- 040-Creating a Macro
- 041-Working with Scripts
- 042-Creating a Form
- 043-Working with Forms
- 044-Sending a Form
- 045-Course Recap