Highline Excel 2013 Class Video 01


Back To Basics: Number Format, Keyboards, PivotTables, Formulas

DESCRIPTION

(0:01:14) Cells, Worksheets, Sheet Tabs and Workbooks.
(0:02:14) Navigating Sheets in Excel 2013.
(0:03:30) Keyboards.
(0:08:51) Number Formatting as Façade.
(0:21:36) Types of Data in Excel.
(0:23:20) Alignment.
(0:27:47) Proper Data Sets, Non-Proper Data Sets.
(0:29:28) Raw Data Into Information using Formula.
(0:33:00) PivotTable #1: Raw Data Into Information using PivotTable.
(0:39:38) Bad Data and Tracking Down Formula Errors.
(0:45:42) Excel Tables.
(0:53:40) Style & Number Formatting for cells.
(1:00:39) PivotTable #2: Style & Number Formatting for PivotTable.
(1:04:34) Page Setup.
(1:11:04) Sorting.
(1:13:15) Filtering.
(1:17:35) PivotTable #3: PivotTables.
(1:19:12) Charts.
(1:25:28) PivotTable #4: Recommended Chart.
(1:26:42) Excel’s Golden Rule.
(1:29:53) IF function.
(1:33:35) VLOOKUP function.

WORKBOOKS

Download “Highline Excel 2013 Workbooks” Highline-Excel-2013-Video-Workbooks.zip – Downloaded 2 times – 21 MB




Be the first to comment

Leave a Reply