Microsoft Excel 2010/2013 Foundation is the basic course designed for people who need to learn how to start using Microsoft Excel 2010/2013. The Course Highlight section below has in detail what features you will learn in this course.

Pre-requisites
To ensure success, participants are required to be familiar with using personal computers and should have experience using a keyboard and mouse. The training will be provided on Windows® 7 platform, therefore if participants are able to use Windows 7 to manage information on their computers it will help them concentrate on the specifics of the training. Some basic tasks include: managing files and folders, launching and closing applications and navigating basic file structures.

Section 1: Getting Started In this section you will learn: Starting Excel 2010/2013 Selecting the Blank Worksheet Template The Excel 2010/2013 Cell Referencing System Entering Numbers and Text Default Text and Number Alignment Summing a Column of Numbers Entering a Date Worksheets and Workbooks Saving a Workbook to Your Hard Disk Closing a Workbook Creating a New Workbook Opening a Workbook Opening a Recently Used Workbook Pinning Files and Folders Switching between Workbooks Saving a Workbook Using another Name Saving a Workbook Using a Different File Type Getting Help within Excel 2013 Searching For Help The Help ‘Table of Contents’ Printing a Help Topic Alt Key Help Using Other Excel Templates	Section 2: Selection Techniques In this section you will learn about: Why Are Selection Techniques Important? Selecting a Cell Selecting a Range of Connecting Cells Selecting a Range of Non-Connecting Cells Selecting the Entire Worksheet Selecting a Row Selecting a Range of Connecting Rows Selecting a Range of Non-Connected Rows Selecting a Column Selecting a Range of Connecting Columns Selecting a Range of Non-Connecting Columns Recommended Techniques When Creating or Editing Lists
Section 3: Manipulating Rows and Columns In this section you will learn how to: Inserting Rows into a Worksheet Inserting Columns into a Worksheet Deleting Rows within a Worksheet Deleting Columns within a Worksheet Modifying Column Widths Modifying Column Widths Using ‘Drag and Drop’ Automatically Resizing the Column Width to Fit Contents Modifying Row Heights	Section 4: Manipulating Cells and Cell Content In this section you will learn how to: Copying a Cell or Range Contents within a Workbook Deleting Cell Contents Moving the Contents of a Cell or Range within a Workbook Editing Cell Content Undo and Redo Copying Data between Worksheets (Within the Same Workbook) Moving Data between Worksheets (Within the Same Workbook) Moving Data Worksheets (Between Different Workbooks) Copying Data between Worksheets (In Different Workbooks) AutoFill Copying a Data Range Using AutoFill Sorting a Cell Range Searching and Replacing Data
Section 5: Worksheets In this section you will learn how to: Switching between Worksheets Renaming a Worksheet Recommended Techniques with Naming Worksheets Inserting a New Worksheet Deleting a Worksheet Copying a Worksheet within a Workbook Moving a Worksheet within a Workbook Copying or Moving Worksheets between Workbooks	Section 6: Font Formatting In this section you will learn how to: Font Formatting Options Font Type Font Size Bold, Italic, Underline Formatting Cell Border Formatting Formatting the Background Colour Formatting the Font Colour
Section 7: Alignment Formatting In this section you will learn how to: Horizontally Aligning Contents in a Cell Range Centring a Title over a Cell Range Cell Orientation Text Wrapping within a Cell Aligning Cell Contents Vertically Format Painter	Section 8: Number Formatting In this section you will learn how to: Number Formatting Decimal Point Display Applying and Removing Comma Style Formatting (To Indicate Thousands) Currency Symbol Date Styles Percentages
Section 9: Freezing Row and Column Titles In this section you will learn how to: Freezing Row and Column Titles	Section 10: Customising In this section you will learn how to: Modifying Basic Excel Options
Section 11: Formulas & Functions In this section you will learn how to: Creating Formulas The Easy Way to Create Formulas Copying Formulas Operators Using Operators in Formulas Formula Error Messages Relative Cell Referencing within Formulas Absolute Cell Referencing within Formulas What Are Functions? Common Functions Sum Function Average Function Max Function Min Function Count Function The Counta Function The Countblank Function What Are ‘If Functions’? Using the If Function	Section 12: Charts In this section you will learn how to: Inserting a Column Chart Inserting a Line Chart Inserting a Bar Chart Inserting a Pie Chart Resizing a Chart Deleting a Chart Chart Title or Labels Changing the Column, Bar, Line or Pie Slice Colours in a Chart Modifying the Legend Fill Colour Changing the Chart Type Modifying Charts Using the Layout Tab Copying and Moving Charts within a Worksheet Copying and Moving Charts between Worksheets Copying and Moving Charts between Workbooks