Excel tutorials, functions and advanced formula examples
Back to Basics: Sharing, moving and protecting the data in Google Sheets
Moving on to another stop of our "Back to Basics" journey, today I will tell you more about managing your sheets. Learn how to share, move and protect your data in Google Sheets. Continue reading
How to use Data Validation in Excel - custom validation rules and formulas
In last week's tutorial we started to look at Excel Data Validation - what its purpose is, how it works, and how to use built-in rules to validate data in your worksheets. Today, we are going to take a step further and talk about the nitty-gritty aspects of custom data validation in Excel. Continue reading
Data validation in Excel: how to add, use and remove
When setting up a workbook for your users, you may often want to control information input into specific cells to make sure all data entries are accurate and consistent. Among other things, you may want to allow only particular data type such as numbers or dates in a cell, or limit numbers to a certain range and text to a given length. Continue reading
Google Sheets Chart Tutorial
Whether you analyze business indicators, make presentation or write a report, charts and graphs will help your audience to understand complex dependencies and regularities. This tutorial will teach you different ways to build charts and graphs in Google Sheets to make your presentations informative and impressive. Continue reading
How to track changes in Excel
When collaborating on an Excel workbook, you may want to keep track of the changes that have been made to it. On a printed copy, you could use a red pen to mark edits. In an Excel worksheet, you can review, accept or reject changes electronically by using the Track Changes feature. Continue reading
Back to Basics: Google Sheets for newbies
It's not a secret that most people are used to work with the data tables in MS Excel. However, now it has a worthy competitor. Allow us to introduce you to Google Sheets. Continue reading
How to share Excel file for multiple users and co-author a shared workbook
The recent versions of Excel make it easy to share and collaborate on workbooks. By sharing an Excel file, you allow multiple users edit the same document simultaneously, which saves you the trouble of keeping track of multiple versions. Continue reading
How to flip data in Excel: reverse columns vertically and rows horizontally
Flipping data in Excel sounds like a trivial one-click task, but surprisingly there is no such inbuilt option. In this tutorial, you will find a few quick ways to flip tables vertically and horizontally preserving the original formatting and formulas. Continue reading
How to create and use dynamic named range in Excel
If you are working with a continuously changing data set, you may want to make your named range dynamic so that it automatically expands to accommodate newly added data. In this tutorial, you will find detailed step-by-step guidance on how to do this. Continue reading
Excel named range - how to define and use names in Excel
Names in Excel are a paradoxical thing: being one of the most useful features, they are often considered pointless or nerdy. This tutorial will teach you different ways to create a named range in Excel to make your formulas much easier to write, read, and re-use. Continue reading
