Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel: Beyond the Basics
Welcome
Overview of Course (1:12)
Navigating this eLearning Program (5:47)
Updating Your Password & Personal Preferences (1:55)
Module 1: Conditional Formatting
Overview of Conditional Formatting. (2:44)
Applying Conditional Formatting to Highlight Text (3:32)
Applying Conditional Formatting to Highlight Numeric Information (4:24)
Adding Data Bars to Emphasize Numeric Information (2:57)
Using Conditional Formatting Icon Sets (2:41)
Clearing Conditional Formatting (2:28)
Managing & Deleting Conditional Formatting Rules (7:33)
Editing Conditional Formatting Rules (5:02)
Module 2: Calculating Data Across Worksheets
Overview of Calculating Data Across Worksheets (2:26)
Creating Formulas by Calculating Across Worksheets (10:47)
Using Named Ranges to Calculate Across Worksheets (9:23)
Using Functions to Calculate Data from Different Worksheets (6:16)
Using Functions When the Data is Located on the Same Cell on Each Worksheet (5:29)
Automatically Update Text Information Housed Elsewhere (10:17)
Creating Calculations from Data Located on Other Workbooks (9:48)
Module 3: Combining & Separating Cell Information
Overview of Combining & Separating Cell Info (5:12)
Combining Cell Information (18:36)
Copying Cell Values (5:39)
Separating Cell Information (11:09)
04 Performing Advanced Functions
Overview of Performing Advanced Functions (2:57)
Locating the Insert Functions Feature (7:06)
Working with Date & Time Functions (8:04)
Changing Case Using Functions (11:51)
Using the vLookUp Function (13:01)
Understanding & Working with IF Functions (15:37)
Editing IF Functions (6:59)
Working with the OR Function (10:14)
Working with the AND Function (9:33)
Working with the LEFT & RIGHT Functions (5:30)
Module 5: Sorting & Filtering Data
Overview of Sorting & Filtering (1:44)
Sorting Data (16:15)
Sorting Multiple Columns
Filtering Data (14:57)
Easily Redisplay Filtered Data
Module 6: PivotTables & PivotCharts
Overview of PivotTables & PivotCharts (1:03)
Creating a PivotTable (35:50)
Adding a PivotChart (8:56)
Wrap-Up
That's a wrap! What's next? (2:25)
Editing Conditional Formatting Rules
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock