Top 10 Excel websites
Are you looking to improve your Excel skills and become a spreadsheet pro? Look no further! In this blog post, we've compiled a list of the best Excel websites that...read more
Category: Excel
Simple Worksheets Commands
As seen in the previous section "What is a worksheet" once we have a brand new worksheet, we can do some commands in regards to that worksheet. To access a...read more
The excel ribbon
When first introduced, the ribbon was not liked by many experienced Excel users. Personally I hated the ribbon. Now, I can't even imagine how Excel looked before the ribbon. If...read more
Today’s date and time in Excel
Use Excel to calculate today's date and today's date and time with the functions TODAY() and NOW() plus variations and keyboard shortcuts. These guides work for Google Sheets as well....read more
Multi-Level Row Pivot Table
If in the previous example we studied how to create a simple pivot table from a simple data-set, in this example we add an additional column to categorize our products...read more
Multi-row and Multi-column Pivot Table
In the previous tutorials for Pivot Tables we looked at the simple Pivot tables with one row and one column, then we added a category to the data-set to create...read more
How to use XLOOKUP in Google Sheets
XLOOKUP may be a new function to Excel but it is not new to spreadsheet software. Google Sheets already has the LOOKUP function that works exactly like Excel's XLOOKUP. What...read more
How to use the CONCATENATE function in Excel
If you want to join multiple texts, numbers or function values into one cell, Excel has a function called CONCATENATE(). You can use the function is some very creative ways....read more
How to use SUMIF in Excel
SUMIF formula is great for summarizing data in a large dataset. A better method to summarize the data is a pivot table. But if only a quick summary is required,...read more
How to update Excel 365
If you think you may not be running the latest version of Excel as part of the Office 365 subscription, follow he steps below to check and update your desktop...read more