Book Last Minute and Save!

Current Course Offers

Courses are live and fully interactive.  Speak with the Instructor at any time during the course or use the Chat and Q&A features.  Each course is 3 ½ hours in length and includes a PDF reference manual and 30 days of technical support. 

There are no last minute course offers at the moment.   Please check back again later.

Contact Us if you have a question.

Current Course Offers

All courses are live and fully interactive.  Speak with the Instructor at any time during the course or use the Chat and Q&A features.  Each course is 3.5 hours in length and includes a PDF reference manual and 30 days of technical support. 

1200px-Microsoft_Office_SharePoint_(2018–present).svg

SharePoint for Microsoft 365
Course 2: Overview Part 2

*** Now $ 75.00 ***

Thu Jul 22 (1:30pm to 5pm)

The main focus in this course is working in document Libraries.  We look at what you can do with files and folders, how to modify the screen, and ways to find documents and know when changes are made. We also look at working in Lists (adding, editing and deleting information) and modifying the Home page.

Libraries
-Create Folders / Special Folders
-Adding Alerts / Using Search
-Deleting Documents / Recycle Bin
-Working with Versioning
-Modify Library Appearance
     -Move Columns / Add Columns
     -Group By Columns
     -Sort & Apply Filters
     -Create & Use Views
-Share Documents / Create a Library
 
Lists
-Add/Edit/Delete List Data
-Add Excel Data to List
-Use Task, Calendar, Contact & Announcements Lists
-Classic vs Modern Experience
-Create a List / Create a List from Excel
 
Pages/Navigation
-Using Search
-Edit Home Page
-Add Sections & Web Parts to a Page
-Promote a Page / Delete a Page
-Edit Quick Launch Navigation
Using Site Contents
-What are Subsites & Hub Sites
ezgif.com-webp-to-png.png

Excel
Course 11: Dynamic Arrays

*** Now $ 75.00 ***

Wed Jul 28 (9am to 12:30pm)

Dynamic Array formulas, new to Excel 365, are by far the biggest change ever made to Excel formulas, allowing you to quickly and easily produce results that were difficult before.

This course is for intermediate and advanced Excel users who are already familiar with basic formulas, relative and absolute cell referencing and functions such as SUM, COUNT, IF and VLOOKUP, etc. 

Arrays
– What is an Array?
– Old CSE Arrays vs DA Arrays
– How to “Spill” a Formula
– The #SPILL! Error
– Implicit Intersection
– Compatibility with other Features
– Forward & Backward Compatibility

New Dynamic Array Functions
– Sort / SortBy
– Filter
– Unique
– Sequence
– RandArray

Existing Functions
– SUMPRODUCT vs SUM
– TRANSPOSE & FREQUENCY Now Easy

Register

To register for a course, please complete this form.    
Each course is $ 75 per person (that’s 40% OFF the regular price of $ 125).
Payment must be made at time of booking.  We accept Visa, Mastercard and American Express (secure payment using Stripe).
Note: All last minute registrations are non-cancellable and non-refundable (see below).

Half Price Courses

Registrations

Summary & Payment

Credit Card *
Please read the following BEFORE you SUBMIT this registration:

All last minute course bookings are NON-CANCELLABLE and NON-REFUNDABLE. If the participant does not attend the course(s), you will be forfeiting the entire course fee paid (no alternate date selection is allowed). Substitutions are welcome, so you can have someone else take this course in place of the participant.

What You Need to Attend

To attend our live online courses you will need a computer (desktop or laptop), an internet connection and a web browser. 

If you work with a laptop, it might be difficult to show the Instructor’s screen and work in the program at the same time, so for smaller screens, we recommend you have a second monitor or second computer.

It would be helpful if you have a microphone so you can speak during the course, but if you don’t you will still be able to ask questions and make comments using the Q&A or Chat features.