Excel Pro Hacks – 101 Tips to Boost Your Productivity

Course Curriculum

Chapter 1: Introduction to the course and your tutor

Lecture 1: Introduction to what we'll cover and how

Chapter 2: Data

Lecture 1: Enter numbers and fractions

Lecture 2: Dates and Times

Lecture 3: Name Cells and Ranges

Lecture 4: Validate Data entry using a pick list

Lecture 5: Extend a series of dates with autofill

Lecture 6: Add a symbol or special character

Lecture 7: Compare multiple spreadsheets using freeze panels

Lecture 8: Hide rows

Lecture 9: Keyboard

Lecture 10: Speak Cells

Lecture 11: Find and replace data

Chapter 3: Formulas and Functions

Lecture 1: Add values

Lecture 2: Function wizard

Lecture 3: Formulas with comments

Lecture 4: OneNote

Lecture 5: Define a constant

Lecture 6: Apply names in functions

Lecture 7: Figure out the best loan terms

Lecture 8: Internal Rates of Return

Lecture 9: Nth largest value

Lecture 10: Large, Small, Max, Min

Lecture 11: Conditional formula

Lecture 12: Conditional formula with names

Lecture 13: Count If

Lecture 14: Conditional sum

Lecture 15: Inner calculator

Lecture 16: Square Roots

Lecture 17: Calculate the duration between two times

Lecture 18: Calculate days between two dates

Chapter 4: Copying Data, Formats etc.,

Lecture 1: Copy a range

Lecture 2: Transpose a row into a column

Lecture 3: Copy styles to another workbook

Lecture 4: Chart formatting

Lecture 5: Paste special and copying worksheets

Lecture 6: Track changes while Editing

Chapter 5: Lists

Lecture 1: Enter list data using a form

Lecture 2: Searching through a data list

Lecture 3: Import a word list into excel

Lecture 4: Sort a list

Lecture 5: Filter a list

Lecture 6: Sort by multiple criteria

Lecture 7: Find averages in a sorted group

Lecture 8: Filter by multiple criteria

Lecture 9: Remove duplicate records from a list

Lecture 10: Count filtered records

Lecture 11: Filter by multiple criteria in the same column

Lecture 12: Chart a filtered list

Lecture 13: Look up information in a List

Chapter 6: Data Patterns

Lecture 1: Create a PivotTable

Lecture 2: Modify a PivotTable and layout

Lecture 3: Find the average of a field

Lecture 4: Create a calculated field

Lecture 5: Calculated fields and charts

Lecture 6: Hide rows and columns in a PivotTable

Lecture 7: AutoFormat a PivotTable

Lecture 8: Create a PivotChart

Lecture 9: Turning on the Data Analysis function so that statistical information can be run

Lecture 10: Describe Data with Statistics

Lecture 11: Discover associations within your data

Lecture 12: Product Numbers

Lecture 13: What-if analysis

Lecture 14: Goal seek

Chapter 7: Creating Charts

Lecture 1: Create a Chart

Lecture 2: Modify Chart details

Lecture 3: Change the Chart Type

Lecture 4: Add a Trendline to a Chart

Lecture 5: Remove Chart Data

Lecture 6: Add chart data

Lecture 7: Missing chart data

Lecture 8: Error bars

Lecture 9: Pull a slice from a Pie Chart

Lecture 10: Label slices of a Pie Chart

Lecture 11: Histogram

Lecture 12: Paste a chart into Word

Lecture 13: Amending a chart in Word

Lecture 14: Paste-link a Chart into Word

Chapter 8: Worksheets

Lecture 1: Format Numbers as Percentages

Lecture 2: Format Currencies in Currency and Accounting Formats

Lecture 3: Format Column Headings

Lecture 4: Format Quickly with Format painter

Lecture 5: Insert a background image into your worksheet

Lecture 6: Create a Transparent image

Chapter 9: Saving and Printing Worksheets

Lecture 1: Save a workbook as a Template

Lecture 2: Save a workbook as an XML spreadsheet

Lecture 3: Print multiple cell ranges on One Page

Lecture 4: Page set up, header, footer, margins – 1 page printing

Lecture 5: Print multiple areas of a workbook

Lecture 6: Print multiple worksheets of a workbook

Lecture 7: Repeat Headings of a Row or Column

Lecture 8: Print functions to show calculations & comments