Monday 12 August 2013

Section One - Make a Start with Excel

1 A first look at Excel 2007/2010
2 Excel Rows and Columns
3 Enter text and numbers in a Cell
4 How to Edit text in a Cell
5 How to Centre text and numbers
6 Font Formatting in Excel 2007/2010
7 How to change the colour of a Cell
8 How to Save your work in Excel
9 Currency Symbols in Excel 2007/2010
10 How to Merge Cells
11 Review Number One
Section Two - A more complex spreadsheet

1 Introduction to Section Two 2 How to use AutoFill in Excel 2007/2010
3 Entering Simple Addition Formula
4 The SUM Function in Excel
5 The SUM Function Continued
6 Copy and Paste
7 How to use Paste Special
8 How to Multiply in Excel 2007/2010
9 Finishing your spreadsheet for this section
10 How to Add a Comment to a Cell
11 Review Number Two

Section Three - Excel 2007/2010 Charts

1 How to Sort Data in Excel 2 Create an Excel Chart
3 Move and Resize your Chart
4 Chart Styles and Layouts
5 Chart Titles and Series Titles
6 Chart Layout Panel in Excel 2007/2010
7 The Format Chart Panel
8 Create a Pie Chart in Excel
9 Add Labels to a Pie Chart
10 Format Pie Chart Segments
11 Create a 2D Line Chart in Excel
12 Format your Axis Titles
Section Four - Formulas in Excel 2007/2010

1 The SUM Function 2 How to Multiply in Excel
3 Subtract and Divide
4 Combining the Arithmetic Operators
5 A Budget Spreadsheet
Section Five - Functions in Excel 2007/2010

1 The Average Function 2 The Date Function
3 Time Functions in Excel
4 A TimeTable Project
5 Financial Functions
6 The Student Averages Project
Section Six - Conditional Logic in Excel

1 The IF Function 2 Conditional Formatting in Excel 2007/2010
3 CountIF
4 SumIF
Section Seven - Processing Data in Excel

1 Data Tables in Excel 2007/2010 2 A Second Data Table
3 Excel Scenarios
4 Goal Seek
5 Absolute Cell References
6 Named Ranges in Excel 2007/2010
7 Create a Custom Name in Excel
8 Excel Pivot Tables
9 Pivot Tables, Part Two
10 Reference other Worksheets
11 The LOOKUP Function
12 The VLOOKUP Function in Excel
13 Create a Business Invoice, Part One
14 Excel Business Invoice, Part Two
15 Business Invoice, Part Three
Section Eight - Advanced Excel 2007/2010

1 How to Create an Excel Template 2 Data Forms in Excel 2007/2010
3 Drop Down Lists in Excel
4 Add your own Error Messages
5 Excel and Web Integration
6 Hyperlinks in Excel
7 Object Linking and Embedding
8 Insert Drawing Objects

No comments:

Post a Comment