Excel 2011 for Mac

 

Microsoft Excel 2011 for Mac Level 1

 Period: 1 Day

Prerequisites: Introduction to PC and Mac operating system. Basic or equivalent experience

Prices for groups vary according to the number of trainees. From R 750 to R 1500 per person.

Individual training from R 1750 per day.Prices exclude VAT. Check out our current specials.

 This course will get the learner started with the basics of Excel 2011. It takes the learner through spread sheet terminology, explores the Excel window, examines various components, how to get Help and how to open and navigate workbooks.

the learner will learn how to enter and edit data, including creating and editing labels, values and formulas, change views and how to save and update workbooks; how to modify a worksheet; and how to use functions such as SUM, AVERAGE, MIN and MAX.  Absolute and relative cell referencing and how they are used in formulae.

Formatting, format painter, printing worksheets is discussed in detail, as is the creation, formatting and printing of charts. The learner will also be taught how to use Web features to save your workbook as a Web page or template.

Excel 2011 for Mac: Level 2

Period: 1 Day

Prices for groups vary according to the number of trainees. From R 750 to R 1500 per person.

Individual training from R 1750 per day.Prices exclude VAT. Check out our current specials.

Prerequisites: Excel 2011 for Mac: Basic or equivalent experience

This Level 2 course will teach the learner how to work with large worksheets using different viewing and printing options and/or hiding/displaying/outlining specific data for better comprehension. The learner will also learn how to work with and navigate between multiple worksheets and workbooks, linking the tabs using formulas, consolidating data and editing links between workbooks.

Customise Excel views and calculation options, toolbars and menus and use advanced formatting to ensure the spread sheet displays well. Use sorting and filtering, as well as apply advanced functions and range names. There is also a section on advanced charting which includes adjustment of scale, using combination charts and inserting graphic elements and hyperlinks.

A section on documenting and auditing shows the learner how to use auditing features, insert and view comments, protect the whole or parts of a worksheet, and share workbooks. The learner will also learn to make use of built-in templates, create your own templates and create a basic macro and array formula.

Excel 2011 for Mac: Standard Advanced 1 day course

 

Period: 1 Day

Prerequisites: Excel 2011 for Mac: Level 2 or equivalent experience

Prices for groups vary according to the number of trainees. From R 750 to R 1500 per person.

Individual training from R 1750 per day.Prices exclude VAT. Check out our current specials.

This course teaches the learner to work with auto shapes, graphics, Word Art and clip art. Work with data lists and using comments. Learn the magic of PivotTables and Pivot Charts and learn how to manage exporting and importing of files and data and query external databases. Use analytical options such as Goal Seek, as well as with scenarios and views.  Create custom styles and use/modify the various toolbars.

More advanced Charting options are covered.

Excel 2011 For Mac – Executive Excel, Advanced Excel techniques for the Executive or Financial Manager

Prerequisites: Excel 2011 for Mac: Level 2 or equivalent experience

Period: 2 Days R 2950 per person excluding VAT.

This specially designed course is for executives and financial managers who have to deal with analysing data. This additional training deals with the main analytical features in Excel.

The emphasis is on business and the analysis of data using Excel. If Budgeting, Wage negotiations, Price lists, Stock, Finance and other business-related tasks form part of your daily responsibilities, this course is an absolute must.

Course content includes:  Formulae, vlookup, mid, right, left and others, Subtotalling, Tables - Relative and Absolute referencing, Range names, Advanced Filtering, Pivot tables and Pivot charts

  Advanced Mac Excel training modules

 

Excel Advanced courses

Period: Three hour sessions

Prerequisites: Excel Intermediate/Level 2 or equivalent experience

ADVANCED EXCEL

All the advanced Excel courses are three hour sessions and cost R 999 excluding VAT per person. Groups rates are available.

The trainee will complete practical exercises during these courses. Additional training can be arranged.

Excel Advanced - Pivot Tables

Prerequisites: Excel Intermediate level 1 and 2

This specially designed Pivot table course is for executives and financial managers who have to deal with analysing data. This additional training deals with the main analytical feature in Excel.

Excel Advanced -Advanced formulae

Prerequisites: Excel Intermediate level 1 and 2

The emphasis is on business and the analysis of data using Excel. For Budgeting, Wage negotiations, Price lists, Stock, Finance and other business-related tasks form part of your daily responsibilities; this course is an absolute must.

Course content includes:  Formulae, vlookup, mid, right, left and others, Subtotaling, Tables - Relative and Absolute referencing.

Excel Advanced -Advanced filtering

Prerequisites: Excel Intermediate level 1 and 2

This course deals with Wordart, Smartart, Clipart, Range names, Advanced Filtering and subtotals.

Excel Advanced - Scenario manager

Prerequisites: Excel Intermediate level 1 and 2

This course deals with the scenario manages and sparklines.

Excel Advanced - Macros

Prerequisites: Excel Intermediate level 1 and 2

This course deals with the creation of more advanced macros.

B This e-mail address is being protected from spambots. You need JavaScript enabled to view it