Excel Therapist

25/01/2022

Free Webinar....

10/01/2022

https://youtu.be/gfPJV1LkxJM

This quick 00:02:22 video details how to use Microsoft Office Specialist (MOS) certification exams, including benefits of MOS certification, how the exams wo...

30/12/2021

Looking to become a Microsoft Office Specialist - Associate or Expert?
The Microsoft Office Specialist Program now has multiple levels: Associate and Expert

Students still earn a certification for each exam they pass, however if a student earns any three of the four available associate certifications they will become a Microsoft Office Specialist - Associate and earn an additional certification for their accomplishment. If students would like to advance even further and earn their Associate certification and any two of the three available expert certifications they will become a Microsoft Office Specialist - Expert and achieve the highest certification within the Microsoft Office Specialist Program.*

27/12/2021

Success stories:

Microsoft Office Specialist certification is a global phenomenon. All around the world, in dozens of countries, people are getting certified through Certiport.

Check out the collection of global success stories that we have gathered which show just how impactful the Microsoft Office Specialist certification can be in transforming the lives of people who are either offering certifications or earning the credentials for themselves.

https://youtu.be/FBdwt_uJJMA

25/12/2021

https://youtu.be/mE9-1D2FmDs

Interested in Microsoft Office Specialist certification, but not sure if it’s right for your students? In this brief video, you’ll learn what’s changed with ...

22/12/2021

https://youtu.be/dwuzrhwdpdo

Learn about all the new features and benefits of the Office 365 and Office 2019 certification exams for the Microsoft Office Specialist program offered throu...

21/12/2021

https://youtu.be/LGIuSWbgk4Q

Ali Kahn is an Amazon Engineer who got his start with Microsoft Office Specialist certifications. Find out how Ali used his MOS certifications to kick start ...

20/12/2021

https://youtu.be/7sViLbTvDKk

Microsoft certification gives students and workforce candidates the power to chart their own course, fulfill their ambition, and realize their potential. See...

08/10/2021

This blog post demonstrates how to create, populate and change comboboxes (form control) programmatically. Form controls are not as flexible as ActiveX

06/10/2021

The image above demonstrates a macro linked to a button. Click the button and the macro runs. It copies the Excel table in cell range A1:D7 to cell range A1

19/09/2021

PRODUCT function
returns the product of values from a set of records that match criteria. The values to multiply are extracted from a given field in the database, specified as an argument.
Get product from matching records-

Syntax:
=DPRODUCT (database, field, criteria)

Arguments:
Database - Database range including headers.
Field - Field name or index to count.
Criteria - Criteria range including headers.

Usage notes:
The Excel DPRODUCT function calculates the product of values in a set of records that match criteria. The values to multiply are extracted from a given field in the database, specified as an argument.

16/09/2021

Insert data from a picture.