In this lesson I show you how to draw a simple flowchart using Microsoft Visio. You learn how to use the start/end blocks, process blocks and how to link them up with arrows (to represent direction of flow).
Month: March 2020
Once you set up a recurring appointment in Outlook, is there a way you can make it show the list of dates so you can send it to someone else? The answer is Yes 🙂
A feature that is so easy in Microsoft OneNote but a bit harder in Word. Don’t worry, here’s a big shortcut. Just download the word file below. PDF version also available. If you prefer to make it yourself, I also show you how to do that.
Have you tried adding numbers in Excel where one of the numbers is an error? Here is a possible fix.You can also apply this fix with the average function.
Do you find that Excel automatically guesses what you’re about to type in every cell based on what you typed before? This video shows you how to disable it.
One of my students accidentally converted her data into a table in Excel, and all these random headings called “column 1” and “column 2” showed up, and she can’t get rid of that row by using the normal delete row function. Here’s the tutorial on how to get rid of those column names / headers …
In this lesson we talk about 3 more decision making functions in Excel – the IF function, which lets Excel output data based on whether the input condition is true or false, the nested if function (an If function inside another if function), and the AND function, which tests whether 2 or more conditions are …
In this lesson you learn how to use the functions count and countif to count how many cells contain specific values.
In this tutorial we talk about what a function does (receives input, process the input, presents the output). We use the randbetween function to generate random numbers between 1 and 6 to simulate dice throws, then we use the fill down feature to simulate multiple throws with multiple dice. We then copy the values we …
In this tutorial, you will learn how to draw a scatter plot in Excel, as well as drawing the trend line and displaying the equation. You will also learn how to draw a line graph, fix the x axis labels and change the y axis scale. Note: This video has no sound.