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.
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.
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).
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.