03.
Entering And Editing Data In Cells
0701 Using Print Titles And Print Areas
0301 Entering Text, Numbers, And Dates
0702 Paper Size, Orientation, Margins,
0302 Entering Numbers As Text
0303 Editing The Contents Of A Cell
0703 Creating Headers and Footers
0304 Undo And Redo Actions
0704 Using The Page Break And The
0305 Cut, Copy, And Paste
0306 Dragging And Dropping Cells
o
o
o
o
The Short Method
1303 Formatting A Chart With The 2013
Shortcut Options
0705 Printing A Range Of Cells
1304 Modifying The Chart Type
0307 The Fill Handle
0706 Running The Spell Checker
1305 Formatting Chart Elements
0308 Inserting And Deleting Cells
0707 Controlling Most Print Settings In
1306 Adding A Trendline
One Place
1307 The Pie Chart In Detail
1308 Mini Graphs: Sparklines
0309 Changing Column Widths And Row
08. Mathematical Formulas
Heights
0801 The Sum Function
0310 Hiding And Un-Hiding Columns And
0802 Copying Formulas And Functions
Rows
0803 Other Mathematical Functions:
0311 Searching For Values In A Workbook
14. Excel As A Database
1401 Fixing On Screen Rows And
Columns
Average, Min, And Max
1402 Fixing Print Rows And Columns
0804 Useful Count Functions
1403 Sorting Data In Excel
0401 Getting Started With Basic Math
0805 Absolute Referencing Explained
1404 Filtering Data To Reduce Dataset
Formulas
0806 Formulas Across Worksheets
0402 Order Of Operation With BODMAS
0807 3D Referencing
0403 Introduction To Basic Formulas
0808 Making Use Of Named Cells And
0404 Copying Formulas And Functions
0405 Displaying Formulas On A
0501 Selecting Cells For Formatting
0502 Modifying Typeface Font, Size, And
Colour
0503 Merging And Wrapping Cell
0504 Using Number Formats
0505 Cell Content Alignment And
o
o
o
o
Themes
1408 Linking To Data On A Webpage
0902 Adding, Editing, And Deleting
15. Advanced Formulas
1502 Use Of The If Function To Hide
0904 Converting Data To A Table For
Excel Error Messages
10. Security
1503 Datedif: A Useful But Hidden
Formula
1001 Activating And Deactivating
1504 Text Manipulation Using Functions
Worksheet Protection
1505 Use The Text Function To Format
1002 Protecting Part Of A Worksheet To
Numbers
Aid Data Entry
1506 Date Manipulation Functions
1003 Password Protecting The Whole
1507 Introducing Sumif, Countif, And
Workbook
Averageif
1508 Use Of Rank To Calculate Placings
0509 Finding And Replacing Formats
1101 Using The 2013 Templates
1509 Flash Fill: The Magic Touch
0510 Clearing Cell Contents Vs. Clearing
1102 Creating And Using Your Own
16. Conditional Formatting
12. Graphics Objects
0601 Worksheet Navigation And Coloured
Images
1202 Using SmartArt Graphics
Within And Between Workbooks
1203 Inserting Shapes And Screenshots
0603 Viewing And Scrolling Multiple
1204 Formatting Graphical Objects
Workbooks At The Same Time
1205 The Stacking Order
0604 Hiding And Un-Hiding Sheets
1206 Grouping Multiple Objects Together
0605 Modifying More Than One
1207 Using Graphical Objects And
Worksheet At A Time
Mathematical Formulas
13. Using Charts In Excel
1601 Altering Cell Appearance Based On
The Cell Value
1201 Obtaining And Inserting Online
0602 Moving Or Copying Worksheets
07. Page Setup And Printing
Template
Worksheet Tabs
11. Excel 2013 Templates
06. Workbook And Worksheet Management
1407 Using Text To Columns Effectively
Cell Formatting
Range
0508 The Format Painter
Data
0901 Enhancing Worksheets Using
1501 Using An If Formula
0507 Applying A Date Format To A Cell Or
1406 Adding Subtotals To A Worksheet Of
0506 Adding And Removing Borders From
0903 Creating Your Own Autofill List
A Selection
Data
Formatting
1405 Removing Duplicate Entries In The
Comments
Orientation
09. Advanced Formatting
05. Formatting Worksheets
Size
Ranges
Contents
1302 Create A Chart Using The Long Or
04. Math Basics
Page Layout Views
Worksheet
1301 The New Recommended Charts
Option
And Scaling Options
Columns And Rows
1602 Displaying Data Bars, Color Scales,
Or Icon Sets
1603 Using Top And Bottom Rules For
Formatting
1604 Creating A Formatting Rule From
Scratch
1605 Managing The Conditional
Formatting Rules
17. What's Next
1701 The New Office Apps For Excel 2013
