Excel Level 1 Course
Microsoft Office Excel Beginner's course is intended for anyone who desires to gain the skills necessary to create, edit, format and print basic Microsoft Office Excel worksheets.
Anyone that needs to know Microsoft Office Excel and perform daily tasks on it.
Windows or iOS: Basic or equivalent experience.
Hours are 08:30 to 16:00 unless specified otherwise
1. Getting Started
2. Entering and Editing Data
3. Modifying a Worksheet
4. Functions
5. Formatting
6. Charts
7. Graphics
8. Printing
Our goal is to make sure your training meets your objectives, not ours. Therefore, all of our outlines are used as guidelines for particular courses. This outline does not guarantee that all the topics listed will be covered in the time allowed. The amount of material covered is based on the skill level of the student audience. We may change or alter course topics to best suit the classroom situation.
Excel Level 2 Course
Microsoft Office Excel Basic is followed by Microsoft Office Excel Intermediate, you created edited, formatted and printed basic spreadsheets. You now have to streamline repetitive tasks and display spreadsheets in more visually effective ways. In this course you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics and formulas.
Anyone that desires to gain necessary skill to create templates, sort and filter data, import and export data, analyse data and work with Excel on the Web.
Excel: Basic or equivalent experience.
1. Managing Workbooks and Worksheets
2. Advanced formatting
3. Outlining and Subtotals
4. Cell and Range Names
5. Data Structure and Tables
6. Web and Sharing Features
7. Documenting and Auditing
8. Application Settings and Templates
Excel Level 3 Course
Microsoft Office Excel Intermediate course is followed by Microsoft Office Excel Advanced, this course will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.
This course was designed for students desiring to gain the skill necessary to create macros, collaborate with others, audit and analyse worksheet data, incorporate multiple data sources and import and export data.
Excel: Intermediate or equivalent experience.
1. Advanced Functions and Formulas
2. Lookups and Data Tables
3. Advanced Data Management
4. Advanced Charting
5. PivotTables and PivotCharts
6. Exporting and Importing data
7. Analytical Tools
MS Excel VBA course
Visual Basic for Applications (VBA) course ware. VBA is a powerful development tool for creating macros in Excel and other Microsoft Office applications. By the end of this course, users should be comfortable with creating, recording, editing, and debugging a macro; formatting worksheets using macros; creating an interactive worksheet; and performing custom calculations using VBA.
This course is intended to help all intermediate to advanced Excel users get up to speed quickly with Visual Basic for Applications. We will cover different features of the Visual Basic Editor interface; show users how to record, edit, debug, and manage macros; and learn about the syntax that VBA uses to create macros..
This course assumes that the user understands the basics of using a Windows-based computer. Students should also be comfortable using the Microsoft Excel 2016 interface, and have a firm understanding of how Excel works and what it is used for. Understanding and experience with formulas, functions, and PivotTables within Excel 2016 is strongly recommended. No previous experience with Visual Basic for Applications is required.
Sorry, we currently do not have any MS Excel VBA courses scheduled at this time. Please contact us to see if we can put one on the schedule for you.
Module 1: Developing Macros
Module 2: Formatting Worksheets Using Macros
Module 3: Creating an Interactive Worksheet
Module 4: Working with Multiple Worksheets
Module 5: Performing Calculations
Would you prefer to take a private Excel course with one of our certified trainers?
We offer Excel training:
From 1 to 100 delegates, On-site at your offices.
Group rates, Flexible dates, Customised courses & Ongoing support for Adobe Excel
Live, Online instructor-led Excel training. Flexible dates and times to suit. All taught in real time wherever you are to individuals or groups.
If you would like to see our Excel Testimonials, please either contact us directly or view our client list and their experiences with our company.
We offer 3 Excel courses. A beginner, intermediate and advanced. Each is 1-day. Please read the course oulines above to determine which is best for you. We taking the advanced course if you are knowledgable of at least 70% of the beginner course.
Wherever your office is located, we can come to you and deliver a private custom Excel course. The larger the group the bigger the discount. However we also offer Excel training for individuals, either at your offices or your home.
For on-site courses, you will need to have a computer with Excel and if there are 3 or more delegates, a projection system is required for our Excel instructor.
Currently we offer Public Excel courses in the Johannesburg, Cape Town, Durban, Gqeberha and Bloemfontein areas. We can however provide a private onsite course or of course an online Excel course is also available
If you are unable to attend a public Excel course, or simply prefer the convenience of an online course, these are regularly offered. For online Excel courses you will need Excel installed, an internet connection of 5MB/s or faster and a headset with a mic or use your laptop's built in mic and speakers. All Excel course materials are provided digitally. The course is of course, live and fully interactive with engaging teaching.
Excel users tend to use the product for specific purposes. We can tailor a course to meet your specific goals.
Firstly, get the basics done. It is absolutely essential for you to have a good working knowledge of Excel. More and more companies are demanding expertise in Excel, whether it is formula’s, pivot tables or dashboard. Taking the Excel level 2 and level 3 class is highly recommended. In addition to Excel, most office users will use PowerPoint, Word and Outlook.
Whether you are using the most recent Excel version, or earlier releases such as Excel 2010,2013,2016 or 2019, our Excel training courses will help you learn the tools you use. When attending a public Excel course, we will use the most recent versions for your Excel course. If you wish to use an older version of Excel for your training, simply let us know and we will work with you on that version. Our Excel instructors have been teaching and developing courses for over 15 years, and are happy to address questions and deliver training on all versions of Excel.
Microsoft Excel is installed on almost every device today. Computers, tablets and mobile devices. It is the most common spreadsheet used by over 500 million people and it is an office tool you can’t live without. Our instructors have been using and teaching Excel for over 20 years. Whether you are a beginner or advanced we can assit you.
For the beginner course, no previous experience is required. For the intermediate and advanced Excel courses, we recommend using Excel for at least 3 months or having attended the beginner course. If you are not sure which level would benefit you, please have a look at the course descriptions for each level. Most of our classrooms, are equipped with Windows computers for use during your Excel training class. If you are an Excel mac user, you are welcome to bring your Mac with with you. It is strongly recommended that you have a personal installation of Excel to use directly after your training
All delegates receive digital materials which are the official Microsoft training manuals. Our instructors may provide addtional training lessons and information especially for custom courses
These Excel courses are the perfect preparation to become a Microsoft Office Specialist
Excel is used by almost every computer user. Simply put if you want to be employed or run your own business, knowledge of Excel is imperative. We cannot show you all our clients and their reviews on our site, and you can view a sample by using this link, however if you contact us directly, we will be happy to put in you in touch with some of our students who have taken our Excel courses.
You can rely on the expertise of our instructors who have been teaching courses over 15 years. Our trainers are developers too. It’s essential to learn from professionals.
When you attend our courses, all delegates receive course materials, a certificate on completion and 3 months support from our certified instructors.
We guarantee your course and offer a full refund if you are not satisfied with your training experience. Just let us know within the first 2 hours of your course.
