Blog

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

read more
Timeline Template Google Docs

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

read more
First and Last Working Day of Month

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

read more
Excel Sum Colored Cells

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

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

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

read more
Excel Slicer Not Working

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

read more
Calculate Percentage

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

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

read more
Convert Date to Month in Excel

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

read more

Archives

Pin It on Pinterest

Share This