This is an intermediate Excel tutorial video on how to graph in Excel using columns. An Excel Graph with Columns is a great way to visualize lots of information with an easy to understand graph. [click to continue…]
This video is an intermediate tutorial on the Excel Count Function. Let’s start with a definition of the Count Function, provided by Excel:
“Counts the number of cells in a range that contain numbers.”
Sounds simple… and it is! Once you develop a grasp of the Excel Count Function, you’ll realize that there is so much you can do with this function. [click to continue…]
Watch this Beginner Excel Tutorial to learn how to filter in Excel. Also learn a keyboard shortcut and watch an introduction to sorting and advanced filtering in excel.
Filtering and sorting through information in Excel is necessary for the everyday Excel user. Knowing how to filter in Excel can save you hours every week, especially when you have huge sets of data! Imagine trying to search through [click to continue…]
This is a free Intermediate Excel Tutorial that teaches you how to chart in Excel. There are two Excel charts that you will learn in this tutorial: a pie chart and a line graph. This is a fundamental Excel skill to have and can take you really far when it comes to presentations at work or at school. This will also be a great help in quickly communicating information to your boss or colleagues. And as you’ll see in my video below, creating charts in Excel is perfect for everyday needs like analyzing your personal expenses, finances, loans, and credit card spending.
This video is a free beginner Excel tutorial. You’ll learn how to calculate average in Excel using the AVERAGE Function or by using the ‘eyeball method’. This video also introduces you to the MIN and MAX functions in Excel. [click to continue…]
This video is a free beginner Excel tutorial that teaches you about the SUM function in Excel. You’ll learn three ways to SUM in Excel: the classic way to SUM plus two Excel SUM tips and tricks! The video below will walk you through an Excel SUM Function example, step by step, and teach how to efficiently SUM in Excel!
The SUM Function is a fundamental skill for any Excel user. [click to continue…]
This video is a free intermediate Excel tutorial that teaches you the fundamentals behind the IF Function in Excel and it builds upon the tutorial in the previous post.
In this video, we go through three examples on how to use the IF Function in Excel. These three examples are also designed to show you the logic behind the IF Function. The three examples are meant to demonstrate typical scenarios that people come across and how Excel can be used to quickly analyze information and make decisions. [click to continue…]
This video is a free intermediate Excel tutorial that introduces you to the Excel IF Function. You’ll learn to create the IF Function in Excel, and gain a core understanding of the Excel IF Function with the help of some simple IF Function definitions and basic examples to show you the logic of the IF Function.
The IF Function is one of the most fundamental and important functions in Excel. Learning the IF Function early on in your Excel education will be a huge help in developing your Excel skills. Learning the IF Function will also save you lots of time in your day-to-day. You can apply this function to virtually any scenario and save yourself time and energy.
The Excel IF Function, on its own, is already a very powerful function [click to continue…]