Excel Therapist

Excel Therapist

Share

Excel can be used to solve all kinds of real-life problems. We committed to sharing our learning's and growing knowledge of Ms Excel with you all.

25/01/2022

Free Webinar....

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

Working with COMBO BOXES [Form Controls] 08/10/2021

Working with COMBO BOXES [Form Controls] This blog post demonstrates how to create, populate and change comboboxes (form control) programmatically. Form controls are not as flexible as ActiveX

How to copy Excel tables programmatically 06/10/2021

How to copy Excel tables programmatically 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.

Want your school to be the top-listed School/college in Dhaka?

Click here to claim your Sponsored Listing.

Location

Category

Website

Address


Dhaka