Blog
Practical Tips on Spreadsheet
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...

Timeline Template Google Docs
This Google Docs timeline template is made in Google Sheets. You can use it as a Gantt Chart or project timeline template by changing project dates. The intention of the template is to provide project managers with an easy-to-use Google Sheets doc for project...

First and Last Working Day of Month
The idea behind the formulas for first working day of the month is very similar to finding the last working day. Essentially you find the last day of the month, then you add one to it or subtract from it. Below we will see how the combination of WORKDAY() function and...

Excel Sum Colored Cells
In solving Excel sum colored cells problem without macro, it is best to think of a process that will let Excel recognise the cells you want to sum. Suppose you want to highlight cells in column B and have cell E2 sum up those coloured cells. Essentially we want to...

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

Excel Slicer Not Working
Slicers can be used on either tables or pivot tables. If your Excel Slicer is disabled, grayed-out or not working, following the steps below: Excel Slicer Not Working Before Inserting Slicer Excel Slicer Grayed Out If your Excel file is in Compatibility Mode, it will...

Calculate Percentage
The concept of percentage is very similar to fractions. To calculate a percentage we would think of the whole (the denominator in fractions) as a number that can be divided into 100 parts. We then ask ourselves what is the share of the smaller number (the part, not...

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

Convert Date to Month in Excel
To convert date to month in Excel, you can use TEXT() function to change the format to show month only or use Month() function to extract month as a numeric value. Excel Convert to Date Datevalue() function is the function that will turn a date in text format to a...