Give Us A Call +2711 882 8853

Excel 2007 Essentials Course

Quick Look Course Summery: Excel 2007 Essentials Course
  • Next Public Course Date: 23/08/2019

  • Length:1 day

  • Price: 1 Person R ex vat3 Person R 0 ex vat10 Person R 0 ex vat

  • Certification Type: Certificate of Attendence

  • Locations & Venues: Call Centre Training Courses are held in JHB, Cape Town, Durban, Port Elizabeth

Excel 2007 Essentials Course: Introduction

Our essentials course for users who need to be able to use and understand EXCEL 2007, this course will teach participants all the advanced features and functions and also show you how 2007 is compatible with later versions.

Excel 2007 Essentials Course :Course Outline

You get your first look at Excel and all you see are little blocks, rows upon rows and column upon column. You feel something beginning in the pit of your stomach and you remonstrate with yourself: You are sure you have bitten off more than you can chew this time. Stop. Breathe slowly. Relax – it’s not half as intimidating as you initially think. Welcome to the workshop on Excel 2007 – Essentials. Excel is a spreadsheet application, this is where you would create, maintain and manage your household budget. In a working environment excel can be used across the board from human resources to accounting and credit control. Excel is used to analyse numbers, keep track of data and present information in a spreadsheet. As this is the Essentials workshop we strongly advise participants to attend the Advanced workshop on Excel 2007 for a fully rounded learning experience. As always, this is a practical workshop where participants will practice what they learn on computers, we also provide learners with a pre workshop review form to enable the trainer to see what functions of excel students are already using and what aspects they wish to learn or know more about. Excel 2007 has a new interface and larger worksheet and workbook sizes. It also has powerful tools to help you format your data into usable information. Some of the objectives of the Essentials workshop are: To differentiate between worksheets, workbooks, rows, columns and cells; enter values and labels; use and copy formulas; learn the basic functions and format text and numbers. If you have used Excel before, you will notice the change in the interface, all the menus and toolbars have been replaced with a ribbon interface, each tab on the ribbon contain selections, commands and features. The screen tip provides information about the selection. A worksheet is a collection of cells, text, data and calculations are entered into these cells. TIP: Choosing the proper format to save your file: Click the Office button and then select Save As. To save in Excel format, choose Excel workshop, if you need the file to be accessible in previous formats, choose Excel 97-2003 Workbook. Use Control + S to quick save and to save as a PDF, add the PDF add-in and save. Our workshop begins with learning how to create a worksheet and enter data. Worksheets are created with a purpose, usually for numbers. Sometimes text is entered and a useful command for text to keep the column alignment is to wrap the text. We take a moment to explain the new format as well. Most of the workshop focuses on building formulas which is the backbone of Excel, we will also teach participants to edit and copy formulas. The next part of the workshop focuses on using the functions of Excel and students will learn the basic Excel functions. We end off our workshop with some time saving tools and formatting. 1. Setting Up a Workbook Creating Workbooks Terminology Excel Environment Customising Quick Access Toolbar Creating a New Workbook Entering Data into Workbook Saving a workbook Open a workbook Zoom Insert a new worksheet Renaming a new worksheet Changing the tab colour of worksheet Rearranging the order of worksheets Move or Copy worksheets Hide or Unhide Worksheets Switch windows Modifying Workbooks and Worksheets Changing column widths and row heights Insert Columns or Rows Delete Columns or Rows Hide or Unhide columns or rows Insert Cells Moving Data by dragging Customising Excel 2010 Arranging multiple workbook windows. Customising the ribbon Minimising the ribbon 2. Working with Data and Excel Tables Entering Data Copy, Cut and Paste Pick from drop down list Find and Replace data Spell Check Thesaurus Defining an Excel Table Format as table Table design Basic Formulas How to create a basic formula Operators Copy formula down Absolute cell reference Basic Functions Insert a function Autosum, sum, min, max and average 3. Changing Workbook Appearance Format Cells Changing Font, Font size and Font Colour Borders Bolt, Italic and Underline Fill Colour Themes Format Numbers as percentage, currency and general Insert a Picture Picture Styles, remove background, picture effects Insert Background 4. Printing Inserting Headers and Footers Print Preview Page Setup Page break preview Print active worksheets Print entire workbook Print Selection Print titles Set Print area Centre data on page

Excel 2007 Essentials Course: Course Duration

1 day/s

Who should attend: Excel 2007 Essentials Course

This course is intended for novice users of Microsoft Excel. **Quote does not include Any Exam Fees (if applicable) IMPORTANT ACTION: Do Not Wait To Improve Your Skills.   Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal

Get Free & personalised Training Advice

Enjoy incredible savings the more delegates you send. See for yourself...

BOTi COURSE COST CALCULATOR

Simply Select a date to see cost

 
m banner