Microsoft Office Excel is a spreadsheet application that works with text, numbers, and date information. It gives you the ability to manipulate data easily, to your disposal. You can perform basic calculations, create tables, charts, and pivot tables.
Excel is widely used for organization of information and tracking data as in a list of sales leads, contact list, or inventory levels. Excel is also useful for statistical analysis with large data sets using graphing and charting tools.
This powerful microsoft excel training courses can analyze data that you have imported from or exported to other applications. Excel gives the user the option of using VBA (Visual Basic Application) to code directly using the Visual Basic Editor.
Microsoft Office programs are integrated into almost every type of business/corporation. From entrepreneurs to Government offices, proficiency in programs such as Word, Excel, and Outlook are usually required qualifications for any job description. Maximize your chances of employment by being familiar with the most current Microsoft Office version. Learn Microsoft Office Excel for your small business needs.
We offer courses in Excel Level 1, Excel Level 2, Excel Level 3, Excel Level 4, and Custom Excel courses. Courses can be delivered in 3-hour blocks, and scheduled in the morning, afternoon, or early evenings. Yes, we also provide weekend training classes.
Who should attend: This course is intended for new Microsoft Excel users.
Prerequisites: Windows 7, Windows 8, or Windows 10.
Duration: 6 Hours
Course Objectives:
Upon completion of the course, participants will be able to accomplish the following:
Course Content
Getting Started with Excel:
Modifying Worksheets:
Using Formulas and Functions:
Formatting and Viewing Worksheets:
Printing Workbooks:
Who should attend: This course is intended for participants who are familiar with Microsoft Excel.
Prerequisites: Microsoft Excel – Level 1 or Equivalent.
Duration: 6 Hours
Course Objectives:
Upon completion of the course, participants will be able to accomplish the following:
Course Content
Worksheet Organization:
Advanced Formulas:
Using Multiple Workbooks and Worksheets:
Working with Charts:
Applying Formatting:
Who should attend: This course is intended for participants who are familiar with Microsoft Excel.
Prerequisites: Microsoft Excel – Level 2 or Equivalent.
Duration: 6 Hours
Course Objectives:
Upon completion of the course, participants will be able to accomplish the following:
Course Content
Maintaining Data:
Sorting Lists:
Filtering Lists:
Summarizing Data:
Working with PivotTables:
Working with External Data:
Who should attend: This course is intended for participants who are familiar with Microsoft Excel.
Prerequisites: Microsoft Excel – Level 2.
Duration: 6 Hours
Course Objectives:
Upon completion of the course, participants will be able to accomplish the following:
Course Content
Using Functions:
Projecting Figures:
Performing What-If Scenarios:
Using Solver:
Auditing Workbooks:
Who should attend: This course is intended for participants who are familiar with Microsoft Excel.
Prerequisites: Microsoft Excel – Level 3.
Duration: 6 Hours
Course Objectives:
Upon completion of the course, participants will be able to accomplish the following:
Course Content
Building Solutions:
Macro Basics:
VBA Programming Basics:
VBA User Form Basics:
Deployment Basics:
Customizing Macros:
Enhancing VBA Code:
Handling Errors:
Accessing External Data:
Excel Automation:
The Vancouver Island Works Project acknowledges that our members, live, play and do business on the Traditional Territory of the Lək̓ʷəŋən speaking peoples. It recognizes the First Nations governments across this region — Lək̓ʷəŋən (Songhees) and Xwsepsum (Esquimalt) Nations in the core area, the W̱SÁNEĆ Nations {W̱JOȽEȽP (Tsartlip), BOḰEĆEN (Pauquachin), SȾÁUTW̱,(Tsawout) W̱SIKEM (Tseycum)} out on the Saanich Peninsula and Gulf Islands, to the west Sc’ianew (Beecher Bay), T’Sou-ke, and Pacheedaht, and MÁLEXEȽ (Malahat) and Pune’laxutth’ (Penelekut) Nations.
As the world continues to shift towards remote work, more and more Canadians are finding themselves working from home or other remote locations. While
