≡ Menu

Intermediate Lessons

Excel Graph with Columns

Excel Graph

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.  In the example in the tutorial, you'll see how an Excel graph with columns can be used to analyze and visualize credit [...]

{ 0 comments }

Excel Count Function

Excel Count Function

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

{ 0 comments }
Chart in Excel

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

{ 0 comments }

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

{ 0 comments }

Excel IF Function Tutorial

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

{ 0 comments }

This video is a free intermediate Excel tutorial that will teach you how to make really long and time consuming lists in Excel in just seconds using the Fill and Series functions! Creating lists is part of everyday life in Excel. Whether you're preparing a report for your boss, planning a wedding, analyzing the results [...]

{ 0 comments }