Microsoft Office Excel L1 2013

Cost: R1 200.00 excl. Vat Duration: 1 Days

Target Audience

This course is intended for people who want to gain the foundational understanding of Microsoft Office Excel 2013 that is necessary to create and develop worksheets.

Course Overview

In this course, you will learn how to create reports on data, perform calculations, store and share your workbook using Microsoft® Office Excel® 2013.

Prerequisites:

To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should be comfortable in the Windows® 8 environment, and be able to use Windows 8 to manage information on their computers. Specific tasks the students should be able to perform include: launching and closing applications, navigating basic file structures, and managing files and folders.

Topics

Lesson 1: 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 2: Performing Calculations
  • Topic A: Create Formulas in a Worksheet
  • Topic B: Insert Functions in a Worksheet
  • Topic C: Reuse Formulas
Lesson 3: Modifying a Worksheet
  • Topic A: Insert, Manipulate, and Delete Cells, Columns, and Rows
  • Topic B: Search for and Replace Data
  • Topic C: Spell Check a Worksheet
Lesson 4: Formatting a Worksheet
  • Topic A: Modify Fonts
  • Topic B: Add Borders and Colors to Worksheets
  • Topic C: Apply Number Formats
  • Topic D: Align Cell Contents
  • Topic E: Apply Styles and Themes
  • Topic F: Apply Basic Conditional Formatting
  • Topic G: Create and Use Templates
Lesson 5: Printing Workbook Contents
  • Topic A: Define the Basic Page Layout for a Workbook
  • Topic B: Refine the Page Layout and Apply Print Options
Lesson 6: Managing Large Workbooks
  • Topic A: Format Worksheet Tabs
  • Topic B: Manage Worksheets
  • Topic C: Manage the View of Worksheets and Workbooks
  • Appendix A: Microsoft Office Excel 2013 Exam 77-420
  • Appendix B: Microsoft Office Excel 2013 Expert Exams 77–427 and 77-428
  • Appendix C: Microsoft Excel 2013 Common Keyboard Shortcuts