100 megs data gift for every genuine quote requested
Developing basic skills in MS Excel 2010 is an absolute requirement in today’s workplace. Everyone uses spreadsheets in one way or another so it’s crucial to know how to open, edit and save Excel documents.
The MS Excel 2010 Beginner Training Course provides skill building in the primary basic features of Excel 2010 such as finding and opening worksheets, formatting, printing, calculating and analysing data. The training course also includes the handling of graphics, worksheets and data to enable participants to use Excel 2010 efficiently.
This dynamic training course is available now Gauteng, Durban and Cape Town.
Contact us today for a group quote.
Who Should Attend
This course is designed for people with no prior knowledge of Excel 2010 or Excel spreadsheets in general.
They may be able to enter data but would like to be able to format the information and set up the spreadsheet to give it a more professional appearance for presentation purposes or printing.
They may want to learn how to enter an Excel formula so that it automatically updates when changes are made the data stored within the Excel spreadsheet or learn how to make a chart based on the information stored on the worksheet.
It would be helpful to have a basic understanding of computers and basic typing skills.
Upon completion of this course, students will gain an understanding of the concepts and terminology used in Microsoft Excel 2010.
They will be able to confidently enter, navigate, edit and format data, use and enter a range of basic formulas using the inbuilt Excel tools and wizards, and print their existing workbooks.
Students will also gain skills working with the Excel ‘file ribbon’, build and update Excel charts and work with multiple windows within the Excel 2010 environment.
Learning Outcomes - Microsoft Excel 2010 Beginner Training Course
- Get started with Excel 2010.
- Perform calculations.
- Modify a worksheet.
- Format a worksheet.
- Print workbook contents.
- Manage large workbooks.
- Customise the Excel environment.
Course Content - Microsoft Excel 2010 Beginner Training Course
Lesson 1: Getting Started with Microsoft Excel 2010
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