-
Getting Familiar with the Interface 8
-
Understanding the RibbonLecture1.1
-
Collapsing and expanding the RibbonLecture1.2
-
Using the Ribbon Display optionsLecture1.3
-
Customizing the RibbonLecture1.4
-
Contextual tabs in the RibbonLecture1.5
-
Understanding the Quick Access ToolbarLecture1.6
-
Customizing the Quick Access ToolbarLecture1.7
-
Using Zoom and View shortcuts in the status barLecture1.8
-
-
Understanding the worksheet structure 3
-
Creating a new workbookLecture2.1
-
Understanding the worksheet and cellsLecture2.2
-
Understanding cell rangesLecture2.3
-
-
Selecting and navigating in a worksheet 8
-
Selecting cells and rangesLecture3.1
-
Selecting a row or columnLecture3.2
-
Selecting multiple adjacent rows or columnsLecture3.3
-
Selecting multiple non-adjacent rows or columnsLecture3.4
-
Selecting all cells in a worksheetLecture3.5
-
Navigating using the scrollbarsLecture3.6
-
Navigating using the keyboardLecture3.7
-
Using the Go To commandLecture3.8
-
-
Entering and editing data 19
-
Entering dataLecture4.1
-
Entering data using the Formula BarLecture4.2
-
Entering datesLecture4.3
-
Understanding how text data behavesLecture4.4
-
Understanding how numbers and dates behaveLecture4.5
-
Adjusting the column width and row heightLecture4.6
-
Autofitting the column width and row heightLecture4.7
-
Replacing data in a cellLecture4.8
-
Canceling data entryLecture4.9
-
Editing data in a cellLecture4.10
-
Editing data using the Formula BarLecture4.11
-
Deleting data / Clearing contentsLecture4.12
-
Copy and paste using the RibbonLecture4.13
-
Copy and paste using right click on the mouseLecture4.14
-
Copy and paste using keyboard shortcutsLecture4.15
-
Cut and paste using the RibbonLecture4.16
-
Cut and paste using right click on the mouseLecture4.17
-
Cut and paste using keyboard shortcutsLecture4.18
-
Moving data within a worksheetLecture4.19
-
-
Modifying worksheets 10
-
Inserting new columns and rows using the RibbonLecture5.1
-
Inserting new columns and rows using right click on the mouseLecture5.2
-
Inserting new cells using the RibbonLecture5.3
-
Inserting new cells using right click on the mouseLecture5.4
-
Inserting a new worksheetLecture5.5
-
Renaming a worksheetLecture5.6
-
Navigating through worksheetsLecture5.7
-
Moving and reordering worksheetsLecture5.8
-
Creating a copy of a worksheet using right clickLecture5.9
-
Creating a copy of a worksheet by draggingLecture5.10
-
-
Saving and closing a workbook 2
-
Saving a new workbookLecture6.1
-
Closing a workbookLecture6.2
-
-
Working with the Auto Fill tool 5
-
Using Auto Fill with textLecture7.1
-
Using Auto Fill with numbers and text with numbersLecture7.2
-
Using Auto Fill with datesLecture7.3
-
Controlling the series incrementLecture7.4
-
Filling cells with data using CTRL + EnterLecture7.5
-
-
Using formulas and functions 10
-
Understanding and entering formulasLecture8.1
-
Understanding functions and function syntaxLecture8.2
-
Understanding the SUM functionLecture8.3
-
Using the SUM functionLecture8.4
-
Using AutoSUMLecture8.5
-
Editing formulas or functionsLecture8.6
-
Using Auto Fill with formulas or functionsLecture8.7
-
Understanding relative cell referencing (must-know!)Lecture8.8
-
Understanding absolute cell referencing (must-know!)Lecture8.9
-
Using the Insert Function commandLecture8.10
-
-
Formatting data 16
-
Applying the thousands separator and decimal places to numbersLecture9.1
-
Applying the accounting or currency format to numbersLecture9.2
-
Applying the percentage format to numbersLecture9.3
-
Applying or changing a date formatLecture9.4
-
Changing the fontLecture9.5
-
Changing the font sizeLecture9.6
-
Applying the bold effectLecture9.7
-
Applying the italic effectLecture9.8
-
Applying the underline or double underline effectLecture9.9
-
Hiding and unhiding columns or rowsLecture9.10
-
Changing the fill color of cells or the font color of textLecture9.11
-
Creating a custom fill color for cells or a custom font color for textLecture9.12
-
Applying borders to a cell or rangeLecture9.13
-
Applying borders using the Draw Border optionLecture9.14
-
Applying borders using the Border dialog boxLecture9.15
-
Using the Mini toolbar to format your data and cellsLecture9.16
-
-
Essential keyboard shortcuts 4
