• Blog Homepage
  • Website Homepage

Magic Monk's Blog

Follow Magic Monk's Journey

IT Education

How to draw flowcharts using Microsoft Visio lesson 1

By Magic Monk on Wednesday, March 11, 2020

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).

Continue Reading
0
IT Education

How to export recurring apointment dates in Microsoft Outlook

By Magic Monk on Tuesday, March 10, 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 🙂

Continue Reading
0
IT Education

Lined paper in Microsoft Word, PDF

By Magic Monk on Monday, March 9, 2020

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.

Continue Reading
0
IT Education

Excel Sum function ignore error

By Magic Monk on Sunday, March 8, 2020

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.

Continue Reading
0
IT Education

Excel Disable word prediction autocomplete autofill autocorrect auto finish words add on

By Magic Monk on Saturday, March 7, 2020

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.

Continue Reading
0
IT Education

Excel can’t get rid of column 1 column 2 header names fix

By Magic Monk on Friday, March 6, 2020

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 …

Continue Reading
0
IT Education

Microsoft Excel Lesson 6 – If function, nested if function, AND function

By Magic Monk on Thursday, March 5, 2020

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 …

Continue Reading
0
IT Education

Microsoft Excel lesson 5 – count and countif functions

By Magic Monk on Wednesday, March 4, 2020

In this lesson you learn how to use the functions count and countif to count how many cells contain specific values.

Continue Reading
0
IT Education

Microsoft Excel lesson 4 – Dice Simulator (randbetween function, paste as values)

By Magic Monk on Tuesday, March 3, 2020

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 …

Continue Reading
0
IT Education

Microsoft Excel Lesson 3 – How to draw a scatter plot and line graph in Excel

By Magic Monk on Monday, March 2, 2020

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.

Continue Reading
0

Posts navigation

← Previous 1 2 3 4 … 75 Next →
Theme by Scissor Themes Proudly powered by WordPress