BPC110 Excel Practice 3
Channel: PVCCOERSpecialist
Date: 2021-04-21

For Excel Practice 3, we will use Excel to manage the technology Inventory at the college., where you work as a Data Analyst. Key skills in this practice are Flash Fill, Advanced Functions, and Conditional Formatting.

00:00 Introduction
00:13 Step 1 Open the Starter File
01:37 Step 5 Flash Fill
02:28 Step 10 Insert Fuction
03:37 Step 15 Apply Accounting Number Format
04:43 Step 20 Format the Cells
07:47 Step 25 Apply Conditional Formatting
08:09 Step 30 Select Range to Add Table
09:42 Step 35 Filter Department
10:32 Step 40 Change the Orientation to Landscape
11:17 End Credits