Microosft Excel 2013: Basic

Course details

You will create and edit basic Microsoft Office Excel 2013 worksheets and workbooks.

• Lesson 1: Getting Started with Microsoft Excel 2013
  
  • Identify the Elements of Excel Interface
  • Creating Basic Worksheet
  • Use the Help System
• Lesson 2: Performing Calculations
  • Creating Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formula
• Lesson 3: Modifying a Worksheet
  • Manipulate Data
  • Insert, Manupilate, and Delete Cells, Columns, and Rows
  • Search for and Replace Data
  • Spell Check a Worksheet
• Lesson 4: Formatting a Worksheet
  
  • Modify Fonts
  • Add Borders and Color to Cells
  • Apply Number Formats
  • Align Cell Contents
  • Apply Cell Styles
• Lesson 5: Printing Workbook Contents
  
  • Define the Basic Page Layout for a Workbook
  • Refine the Page Layout and Apply Print Options
• Lesson 6: Managing Large Workbooks
  
  • Format Worksheet Tabs
  • Manage Worksheets
  • Manage the View of Worksheets and Workbooks
• Lesson 7:Customizing Excel Environment
  
  • Customize General and Language Options
  • Customize Formula Options
  • Customize Proofing and Save Options
  • Customize the Ribbon and Quick Access Toolbar
  • Customize the Functionality of Excel by  Enabling Add-Ins
  • Customize Advanced and Trust Center Options

Prerequisites

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper based systems to store data that you run calculations on. You now want to migrate that data to an electronic format.

Students should be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.

Audience

This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft Office, Windows 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2013 worksheets.

Delivery Method

Instructor Led classroom based training. Scheduled classes are normally held in Woodmead - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Light finger meals are supplied for part time courses.