Microsoft Excel Course
This is a full and free computer course for Microsoft Excel, for any version 2007 or later. If you're not sure whether or not you're in the right place take a look at Section 1.1 below, A First Look at Excel. By the time you've finished the course you'll be an intermediate Excel user. So good luck!
Section One - Make a Start with Excel | ||
1 A first look at Microsoft Excel 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 7 How to change the colour of a Cell 8 How to Save your work in Excel 9 Currency Symbols in Excel 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 to 2016 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 9 Finishing your spreadsheet for this section 10 How to Add a Comment to a Cell 11 Review Number Two | |
| Section Three - Microsoft Excel 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 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 13 Predict the future with a Trendline Chart 14 Sparkline Charts | |
| Section Four - Formulas in Excel | ||
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 | ||
1 The Average Function 2 The Date Function 3 | 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 | 3 CountIF 4 SumIF | |
| Section Seven - Processing Data in Excel | ||
1 Flash Fill - your new best friend! 2 Data Tables in Excel 3 A Second Data Table 4 Excel Scenarios 5 Goal Seek 6 Absolute Cell References 7 Named Ranges in Excel 8 Create a Custom Name in Excel 9 More on Named Ranges | 10 Excel Pivot Tables 11 Pivot Tables, Part Two 12 Reference other Worksheets 13 The LOOKUP Function 14 The VLOOKUP Function in Excel 15 Searching with MATCH and INDEX 16 Create a Business Invoice, Part One 17 Excel Business Invoice, Part Two 18 Business Invoice, Part Three | |
| Section Eight - Intermediate to Advanced Excel | ||
1 How to Create an Excel Template 2 Data Forms in Excel 3 Drop Down Lists in Excel 4 Add your own Error Messages 5 Array Formulas 6 Frequency Distribution 7 Standard Deviation, Excel Bell Curves | 8 Excel Standard Error 9 Confidence Intervals 10 Binomial Distribution (Probability) 11 Excel and Web Integration 12 Hyperlinks in Excel 13 Object Linking and Embedding 14 Insert Drawing Objects |
No comments:
Post a Comment