Averageif and Averageifs In Depth

Averageif and Averageifs In Depth

Averageif and Averageifs are used to calculate the arithmetic average of cells that meet specified criteria(s). The functions are available in MS Excel 2007 onward, and Mac Excel 2011 onward. Averageif Syntax =AVERAGEIF (range, criteria, [average_range]) Range...

Excel LEN Function

Finding Length of Text Excel LEN() function returns the length of a text string. It is often used with LEFT(), RIGHT() and MID() function to perform text manipulation. Together, these functions allow one to find a substring that is to the left or right of a certain...
Project Collaboration with Gantt Chart Google Sheets

Project Collaboration with Gantt Chart Google Sheets

You are a project manager with a universe upon your shoulder. You want to collaborate tasks easily on GSuite just because you subscribed. What do you do? Answer: Create a Gantt Chart Google Sheets template. Below is a simple action plan: Create a Timeline Template or...
Excel Filter Function Comprehensive Guide and Examples

Excel Filter Function Comprehensive Guide and Examples

Description Excel Filter function is used to return multiple results matching a search criteria. It is available in Microsoft 365 current channel subscribers only. If you use Office 2019 or older versions to open a workbook built with FILTER() or other dynamic array...
7 Important Excel Functions to Know

7 Important Excel Functions to Know

Key Excel Functions to Know What are the 10% of Excel functions to know to achieve 90% efficiency? There was a Tweet on the 4 functions you cannot live without in 2020. While consensus do not always coincide, SUM(), IF() and VLOOKUP() are most frequently mentioned. IF...
Excel Crashing, File Issues and Solutions

Excel Crashing, File Issues and Solutions

As you use Excel on a daily basis, and as you start to work with files from other people, other companies or large data files, you will encounter issues. There are no standard solutions to each problems. However, you can look at the suggestions provided and see which...
Top 7 Questions on Excel Trend and Platforms

Top 7 Questions on Excel Trend and Platforms

Will Excel Be Replaced Excel is a swiss army knife that fills the gaps of proprietary softwares. It allows fast adaptation of situations, and come up with a solution that will take IT department a long time to come up with the resources to solve. Companies such as...
Set Excel as Default

Set Excel as Default

If your Excel 2016, 2019 is not in default program list, you will need to set Excel as default. Take the following steps: Go to Control Panel\All Control Panel Items\Default ProgramsChoose Set Defaults by App to set Excel as default.Click on Excel then click ManageFor...
Online Alternatives to Microsoft Excel

Online Alternatives to Microsoft Excel

Granted, a desktop version of MS Excel is not everyone’s cup of kombucha. There is the cost associated with it, and then you might be using an operating system that makes it impossible to download one. Here are some great alternatives: Microsoft Excel Online...
Wedding Planning Template

Wedding Planning Template

Natalie MacDonald, an editor at LinkedIn, recently posted an article “The end of the big white wedding?”, mentioning the concerns would-be couples have on suppliers and the future of wedding in light of the impact of COVID-19. The post reminds of the...

Pin It on Pinterest