Excel 2013 Beginner to Advanced Training

Key Topics Excel 2013: Part 1 Lesson 01 - Getting Started with Microsoft Excel 2013 Topic A: Identify the Elements of the Excel Interface Topic B: Create a Basic Worksheet Topic C: Use the Help System Lesson 02 - Performing Calculations Topic A: Create Formulas in a Worksheet Topic B: Insert Functions in a Worksheet Topic C: Reuse Formulas Lesson 03 - Modifying a Worksheet Topic A: Manipulate Data Topic B: Insert, Manipulate, and Delete Cells, Columns, and Rows Topic C: Search for and Replace Data Topic D: Spell Check a Worksheet Lesson 04 - Formatting a Worksheet Topic A: Modify Fonts Topic B: Add Borders and Color to Cells Topic C: Apply Number Formats Topic D: Align Cell Contents Topic E: Apply Cell Styles Lesson 05 - Printing Workbook Contents Topic A: Define the Basic Page Layout for a Workbook Topic B: Refine the Page Layout and Apply Print Options Lesson 06 - Managing Large Workbooks Topic A: Format Worksheet Tabs Topic B: Manage Worksheets Topic C: Manage the View of Worksheets and Workbooks Lesson 07 - Customizing the Excel Environment Topic A: Customize General and Language Options Topic B: Customize Formula Options Topic C: Customize Proofing and Save Options Topic D: Customize the Ribbon and Quick Access Toolbar Topic E: Customize the Functionality of Excel by Enabling Add-Ins Topic F: Customize Advanced and Trust Center Options Excel 2013: Part 2 Lesson 01 - Creating Advanced Formulas Topic A: Apply Range Names Topic B: Use Specialized Functions Lesson 02 - Analyzing Data with Logical and Lookup Functions Topic A: Leverage Questions and Testing to Write Formulas Topic B: Use Logical and Lookup Functions to Find Answers to Questions Lesson 03 - Organizing Worksheet Data with Tables Topic A: Create and Modify Tables Topic B: Sort and Filter Data Topic C: Use Summary and Database Functions to Calculate Data Lesson 04 - Visualizing Data with Charts Topic A: Create Charts Topic B: Modify and Format Charts Topic C: Create a Trendline Topic D: Create Advanced Charts Lesson 05 - Analyzing Data with PivotTables, Slicers, and PivotCharts Topic A: Create a PivotTable Topic B: Filter Data by Using Slicers Topic C: Analyze Data by Using PivotCharts Lesson 06 - Inserting Graphics Topic A: Insert and Modify Graphic Objects Topic B: Layer and Group Graphic Objects Topic C: Incorporate SmartArt Lesson 07 - Enhancing Workbooks Topic A: Customizing Workbooks Topic B: Manage Themes Topic C: Create and Use Templates Topic D: Protect Files Excel 2013: Part 3 Lesson 01 - Automating Worksheet Functionality Topic A: Update Workbook Properties Topic B: Create and Edit a Macro Topic C: Apply Conditional Formatting Topic D: Add Data Validation Criteria Lesson 02 - Auditing Worksheets Topic A: Trace Cells Topic B: Troubleshoot Invalid Data and Formula Errors Topic C: Watch and Evaluate Formulas Topic D: Create a Data List Outline Lesson 03 - Analyzing and Presenting Data Topic A: Create Sparklines Topic B: Create Scenarios Topic C: Perform a What-If Analysis Topic D: Perform a Statistical Analysis with the Analysis ToolPak Topic E: Create Interactive Data with Power View Lesson 04 - Working With Multiple Workbooks Topic A: Consolidate Data Topic B: Link Cells in Different Workbooks Topic C: Merge Workbooks Lesson 05 - Exporting Excel Data Topic A: Export Excel Data Topic B: Import a Delimited Text File Topic C: Integrate Excel Data with the Web Topic D: Create a Web Query

Learning@Home is an international learning provider and is committed to excellence in training delivery. We aim to make the option of further education accessible to everyone, allowing you to truly take control over your learning by focusing on those who are unable to attend classroom or taught sessions. We currently offer over 600 distance learning courses accredited by a number of established Awarding Bodies including Active IQ, AQA, CISCO, Edexcel, ICB, Microsoft, NCFE, and Sage.