100 megs data gift for every genuine quote requested

Every business uses spreadsheets one way or another, developing your skills in MS Excel 2013 should be an essential part of your professional development plan.

The Microsoft Excel 2013 Beginner Training Course teaches you the basic features of Excel 2013, including formatting, printing, entering data, filter tools, editing, graphics and a thorough understanding of the interface. This course creates a solid foundation on which you can create your next spreadsheet with confidence.

This dynamic training course is available now Gauteng, Durban and Cape Town.

Contact us today for a group quote.

Excel

Word

PowerPoint

Outlook

Access

Project

Who Should Attend

This course is designed for people with no prior knowledge of Excel or Excel spreadsheets. They may be able to enter data into their Excel spreadsheets, however, would like to be able to format the spreadsheet to give it a more professional look and feel for printing.

They may want to learn how to enter a formula so that it automatically updates when changes are made or learn how to make a chart out of the data already entered into their existing Excel worksheets.

It would be beneficial to have a basic understanding of computers and basic typing skills.

As a result of this course, students will gain an understanding of the concepts and terminologies used in Microsoft Excel.

They will be able to confidently enter, edit, navigate and format data, create and edit basic formulas and print their workbooks.

Students will also gain an insight into working with Excel charts, understand and navigate the new Excel ‘ribbon’ and work with multiple windows.

Learning Outcomes - Microsoft Excel 2013 Beginner Training Course

This extensive training course in Excel 2013 Beginner develops basic skills and an understanding of the application. After this course, participants will be able to use all of Excel 2013’s basic functions to complete tasks expertly.

  • Get started with Excel 2013.
  • Perform calculations.
  • Modify a worksheet.
  • Format a worksheet.
  • Print workbook contents.
  • Manage large workbooks.
  • Customise the Excel environment.

Course Content - Microsoft Excel 2013 Beginner Training Course

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: 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 4: Formatting a Worksheet
Topic A: Modify Fonts
Topic B: Add Borders and Colour to Cells
Topic C: Apply Number Formats
Topic D: Align Cell Contents
Topic E: Apply Cell Styles

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

Lesson 7: Customising the Excel Environment
Topic A: Customise General and Language Options
Topic B: Customise Formula Options
Topic C: Customise Proofing and Save Options
Topic D: Customise the Ribbon and Quick Access Toolbar
Topic E: Customise the Functionality of Excel by Enabling Add-Ins
Topic F: Customise Advanced and Trust Centre Options