|
|
MICROSOFT EXCEL for Macintosh and Windows
Excel is the world's most widely used spreadsheet program for both Windows and Apple Macs, its appeal is due to the fact that it is versatile and easy to use. It performs numerical calculations, creates eye popping business graphs and charts, organises lists and databases, imports data from a variety of sources, and creates pivot tables and graphical dashboards. Using Visual Basic for Applications you can perform macro programming. Microsoft released the first version of Excel for the Mac in 1985, and the first Windows version in 1987. The current versions are Microsoft Excel 2010 for Windows and Microsoft Excel 2011 for Mac. We also cater for previous versions.
We have been training Microsoft applications since 1990, for both Windows and Apple Mac.
Introduction - Level 1 (6 hrs) |
Intermediate - Level 2 (6 hrs) |
Advanced - Level 3 (6 hrs) |
- The Workspace
- The Ribbon
- Office Button or File Tab
- Quick Access Toolbar
- Contextual Menus & Mini Toolbar
- Designing a Worksheet
- Saving Documents
- Navigating a Document
- Enter Text & Titles
- Enter Values
- Write Formulas
- AutoFill
- Function Word Formulas
- Formatting Text
- Spell Checking
- Formatting Values
- Styles & Themes
- Find & Replace Data
- Cell Comments
- Working with Objects
- Special Effects
- SmartArt & WordArt
- Creating Charts & Graphs
- Formatting Charts
- Print Preview & Printing
|
- Cell Referencing
- Absolute References
- Date Calculations
- IF Statements
- Working with Lists
- Sorting Data
- Excel Databases
- SubTotalling
- AutoFilter
- Outlining
- Pivot Tables & Charts
- Big Sheet Essentials
- Multiple Workbooks
- Sheet Protection
- Creating Templates
- Conditional Formatting
- Track Changes
- Creating Scenarios
- Goal Seek
- Using Solver
- Data Validation
|
- LookUp Functions
- Formula Auditing
- Evaluate Formulas
- Watch Window
- Range Finder
- Name Ranges
- Linking Data
- Consolidating Data
- MS Office Diagnostics
- Document Properties
- Finding Files
- Digital Signatures
- Working with Macros
- Viewing VBA Code
- Editing the Code
- Splitting Macros
- Macro Buttons
- Custom Macro Menus
- Web and External Data
- Hyperlinks
- Create Web Pages
|
- Pre-requisites:
No prior experience is necessary, but you should have a good understanding of your computer’s operating system.
|
- Pre-requisites:
You would have completed our Level 1 with us, or can prove you know and understand the Level 1 topics.
|
- Pre-requisites:
You would have completed our Levels 1 and 2 with us, or can prove you know and understand those topics.
|
| |
|
|
Plus you also get:
- a comprehensive training manual
- on-going email support
- certificate of attendance (Scheduled courses only)
All courses are 6 hours duration, but you can take them as:
- a 2 hour session (you will need to take 3 x 2 hr sessions to complete a level.)
- a half day (3 hrs) session (take 2 x 3 hr sessions)
- or the complete level in one day (6 hrs)
Design your Own course: choose from the above topics to design your own custom training session to suit your skill levels.
Price:
- By the hour (min 2 hrs) - individual training: $80 plus gst per hour
- By the hour (min 2 hrs) - group training: $120 plus gst per hour
- Schedule training in our training room: $175 inc gst per 3 hour session
- Corporate 1 day training: POA
Back to Microsoft courses
|
|
|
|
|