Excel tutorials, functions and advanced formula examples, page 2
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
Google Sheets VLOOKUP with examples
A widespread opinion is that VLOOKUP is one of the most difficult and obscure functions. But that's not true! In fact, it's easy to do VLOOKUP in Google Sheets, and in a moment you will make sure of it. Continue reading
Google Spreadsheet COUNTIF function with formula examples
We continue exploring the possibilities of Google Spreadsheets with COUNTIF function. Learn why you may need it and how it can be applied to your daily work with the tables. Continue reading
Excel calculations: automatic, manual, iterative
To be able to use Excel formulas efficiently, you need to understand how Microsoft Excel calculates them. Not less important are calculation settings that can speed up, slow down or even stop your Excel calculations as well as maintain their accuracy. Continue reading
How to do calculations in Excel
When it comes to calculations, there is almost noting that Microsoft Excel cannot do, from totaling a column of numbers to solving complex linear programming problems. Apart from that, you can use Excel as a calculator to do math - add, divide, multiply, and subtract numbers as well as raise to power and find roots. Continue reading
Basic Excel formulas & functions with examples
Being primarily designed as a spreadsheet program, Microsoft Excel is extremely powerful and versatile when it comes to calculating numbers or solving math and engineering problems. This tutorial aims to teach you the essentials of Excel functions and show how to use basic formulas in Excel. Continue reading
