COURSE OUTLINE
Module Duration: Max. 15 Sessions
Lesson 1 – MAKE A START WITH EXCEL
1.1 A First Look at Excel 2010
1.2 Excel Rows and Columns
1.3 Entering text and numbers in a Cell
1.4 Editing text in a Cell
1.5 Centering text and numbers
1.6 Font Formatting in Excel 2010
1.7 Changing the color of a Cell
1.8 Saving your work in Excel
1.9 Currency Symbols in Excel 2010
1.10 Merging Cells
1.11 Review Number One
Lesson 2 – A MORE COMPLEX WORKSHEET
2.1 Introduction to Section Two
2.2 Using AutoFill in Excel 2010
2.3 Entering Simple Addition Formula
2.4 The SUM Function in Excel
2.5 The SUM Function Continued
2.6 Copy and Paste
2.7 Using Paste Special
2.8 Multiplying in Excel 2010
2.9 Finishing your spreadsheet for this section
2.10 Adding a Comment to a Cell
2.11 Review Number Two
Lesson 3 – EXCEL 2010 CHARTS
3.1 Sorting Data in Excel
3.2 Creating an Excel Chart
3.3 Moving and Resizing your Chart
3.4 Chart Styles and Layouts
3.5 Chart Titles and Series Titles
3.6 Chart Layout Panel in Excel 2010
3.7 The Format Chart Panel
3.8 Creating a Pie Chart in Excel
3.9 Adding Labels to a Pie Chart
3.10 Formatting Pie Chart Segments
3.11 Creating a 2D Line Chart in Excel
3.12 Formatting your Axis Titles
Microsoft Excel Intermediate Level
Lesson 4 – FORMULAS IN EXCEL 2010
4.1 The SUM Function
4.2 Multiplication in Excel
4.3 Subtraction and Division
4.4 Combining the Arithmetic Operators
4.5 A Budget Spreadsheet
Lesson 5 – FUNCTIONS IN EXCEL 2010
5.1 The Average Function
5.2 The Date Function
5.3 Time Functions in Excel
5.4 A Time Table Project
5.5 Financial Functions
5.6 The Student Averages Project
Lesson 6 – CONDITIONAL LOGIC IN EXCEL
6.1 The IF Function
6.2 Conditional Formatting in Excel 2010
6.3 CountIF
6.4 SumIF
Microsoft Excel 2010 Advanced Level
Lesson 7 – PROCESSING DATA IN EXCEL
7.1 Data Tables in Excel 2010
7.2 A Second Data Table
7.3 Excel Scenarios
7.4 Goal Seek
7.5 Absolute Cell References
7.6 Named Ranges in Excel 2010
7.7 Excel Pivot Tables
7.8 Pivot Tables, Part Two
Lesson 8 – PROCESSING DATA IN EXCEL
8.1 Data Forms in Excel 2010
8.2 Drop Down Lists in Excel
8.3 Add your own Error Messages
8.4 Excel and Web Integration
8.5 Hyperlinks in Excel
8.6 Object Linking and Embedding
8.7 Reference other Worksheets
8.8 Insert Drawing Objects
Recent Comments