Videos uploaded by user “Magic Monk”
How to stop a program from running automatically when computer starts (Windows)
Do you want to stop programs such as Spotify, Skype, Dropbox, Adobe update, Java update etc. from running when Windows starts? This tutorial shows you how.
Views: 196977 Magic Monk
How to translate a whole Chinese webpage to English in 2 seconds
In this video I show you guys how to use a Google chrome extension to translate webpages from Chinese into English.
Views: 41294 Magic Monk
SQL with Microsoft Access 2016 lesson 1 - Create table
In this lesson we run you through how to create a table in SQL. You learn about the syntax for the create table statement and some data types such as Integer, Varchar and float.
Views: 74813 Magic Monk
We can't install the 64-bit version of Office because we found the following
Warning: After I did this I found that I needed to reinstall Microsoft Outlook for it to work. It is not my responsibility if something bad happens to your computer / software if you choose to follow the instructions in this video. Do your own research. I was trying to install Microsoft Visio Professional 2013 and this error message showed up: "We can't install the 64-bit version of Office because we found the following 32-bit programs on your PC: Office 15 Click-To-Run Extensibility Component. Please uninstall all 32-bit Office programs, then try re-installing 64-bit Office.." So what I'm going to do is show you how to fix this error! Or how to uninstall Office 15 Click-to-run extensibility component.
Views: 118330 Magic Monk
Basketball spinning tutorial
Eddie teaches you step by step how to spin a basketball like a pro. Not to be missed!
Views: 34915 Magic Monk
How to stop your computer from turning itself on
Recently I have discovered my computer turns on by itself every morning without me touching it. I did a bit of research and found the reason. Here is how you make it stop doing that.
Views: 84918 Magic Monk
How to snip drop-down menu in Windows
Sometimes you need the shortcut key to snip something that disappears with a mouse click (e.g. a context menu). This video shows you how. Operating System: Windows 8
Views: 9252 Magic Monk
How to hardcode subtitles with VLC media player
a.k.a. Subtitles not showing up after hardcoding in VLC fix. a.k.a. Subtitles showing up multiple times after hardcoding in VLC fix. If you're watching this you've probably tried burning subtitles to your video and encountered multiple errors - either subtitles not showing or displaying multiple times. I've tried just about everything to come up with this solution. Check it out :)
Views: 355487 Magic Monk
How to kick or jump attack in Dark Souls
Took me a while to figure out how to kick based on the in game instructions.. Thought I'd make a video to help.
Views: 29904 Magic Monk
Drawing with tablet pen slight delay problem fix (Wacom Bamboo)
So when I am drawing in a PDF with my Wacom Bamboo tablet, I noticed that after I start drawing the lines don't come out, and after a split second it comes out but the line is straightened (which is not what I want). This is how you fix it. (It also gets rid of the annoying circle as well as the right clicking)
Views: 20699 Magic Monk
SQL with Microsoft Access 2016 lesson 3 - Alter Table
So what you've created a table but you made a mistake in the data types of columns or you would like to add / delete columns? We show you how in this video.
Views: 25336 Magic Monk
Anyone can do Algebra lesson 9 - Quadratic expansion and factorisation
In this tutorial you learn how to expand two brackets into a quadratic expression, and then you also learn how to factorise quadratic expressions back into two brackets. Visit http://magicmonktutorials.com/ for more lessons, quizzes and answers.
Views: 6742 Magic Monk
How to type A to Z in under 3 seconds
In this tutorial Eddie will teach you how to touch type from A to Z in under 3 seconds. Watch this video to see how to type fast on your phone: https://www.youtube.com/watch?v=rX4kMJdMAVc
Views: 1715991 Magic Monk
Adobe Premiere Pro shortcuts - How to insert a clip in the middle of the timeline
Have you been selecting clips the hard way?
Views: 45819 Magic Monk
SQL with Microsoft Access 2016 lesson 2 - Inserting records
In this video we cover the Insert Into SQL statement to insert some data into a table. We ran into some problems already - some phone numbers got stripped off a zero at the front, and it accepted some numbers with incorrect number of digits. All these will be fixed in the next tutorial.
Views: 43610 Magic Monk
WIFI disappears after sleep fix for laptop notebook computer wireless Wi-Fi
Recently I found that after I put my computer to sleep and wake it again, I can't connect to the wireless network anymore, so I have to restart the computer to connect to the wireless network. Here is a video on how I fixed it.
Views: 7984 Magic Monk
SQL with Microsoft Access 2016 Lesson 7 - Subqueries
In this lesson we talk about subqueries - using the result from one query as part of the condition of another query. Download the access database so you don't have to create your tables from scratch: http://magicmonktutorials.com/access/lesson7database.zip
Views: 13186 Magic Monk
How to cut a spritesheet into separate picture files
Using Adobe Photoshop CC. Source of sprites: http://opengameart.org/content/platform-character
Views: 6508 Magic Monk
How to recover chrome bookmarks stored locally on an old hard drive (not using google account)
One of my old laptops just went bust and I had a lot of bookmarks that were saved on it in Chrome. This video will show you how to recover them.
Views: 53376 Magic Monk
Windows command prompt tutorial 2 - making folders, deleting folders, creating and deleting files
Continuing from the last tutorial, in this tutorial we learn how to create/delete folders and files. Please do not try these commands with any important folders/files, you cannot get anything you deleted in command prompt back. list of commands: ctrl+c (break) md hello cd hello notepad test.txt del test.txt rd hello
Views: 25508 Magic Monk
Matrices lesson 12 - Use Gaussian Elimination to solve 3-variable simultaneous equations
In this tutorial you can see how Gaussian Elimination can be applied to solve a system of simultaneous equations with 3 variables.
Views: 34243 Magic Monk
DVD drive missing in Windows 8
Updated video description: Some people have been messaging me telling me this video doesn't work for them. Unfortunately I can't physically go to your computer and figure out why it worked for me but doesn't work for you. I am only showing you that it worked for me, MAYBE it will work for you too, if not there's not really anything I can do. Everyone has different hardware, not mentioning the fact that software gets updated all the time and things change. Sorry. ___________________________________________________________________ Original video description: Not soon after I installed Windows 8, I tried to load up a DVD and found that I couldn't find the DVD-ROM drive! Here's the solution I found on the microsoft website. Copy the code below as instructed in the video: reg.exe add "HKLM\System\CurrentControlSet\Services\atapi\Controller0" /f /v EnumDevice1 /t REG_DWORD /d 0x00000001
Views: 130370 Magic Monk
Sybil Cut tutorial part 1
Part 2 is here: http://youtu.be/xJnRi9sWD-g A dummy's guide to the Sybil cut - broken down into the simplest possible steps that anyone can follow. Have a go!!
Views: 19923 Magic Monk
Sybil Cut tutorial part 2
The second part to the dummy's guide to the Sybil cut - broken down into the simplest possible steps that anyone can follow. Have a go!! Part 1: https://www.youtube.com/watch?v=iNT5H2lnbhA Part 2: https://www.youtube.com/watch?v=xJnRi9sWD-g Part 3: https://www.youtube.com/watch?v=cpcf-GDlVPU Part 4: http://youtu.be/iGIOO0DuXTs
Views: 11765 Magic Monk
How much time do you need to transfer planes in Taipei airport between terminal 1 and 2
My plane ticket to Korea from Brisbane involved a transit in Taipei. As I had never changed planes in Taipei before, I wasn't sure what to do when you land in terminal 2 but depart in terminal 1. It turned out that the process was very simple and you didn't need too much time for it (all explained in video).
Views: 4189 Magic Monk
SQL with Microsoft Access 2016 Lesson 4 - Select query
In this video you learn about the select query - how to select specific rows / columns from a table. We also talk about using different comparison operators, such as larger than / smaller than or equal to. Download the file below, unzip the files, then import the table to your database. http://magicmonktutorials.com/access/lesson4.zip
Views: 36850 Magic Monk
Swing Cut tutorial
Trick 2 here: https://www.youtube.com/watch?v=iNT5H2lnbhA This is the first tutorial that you should go through to be able to cut cards like the movie Now you see me!
Views: 60984 Magic Monk
Integral Calculus lesson 1 - Anti-differentiation (also known as integration)
Having done all of the beginning calculus tutorials on differentiation, we now move onto anti-differentiation - the opposite of differentiation. Worksheets containing practice questions and answers available here: http://magicmonktutorials.com/videolist.php?supercat=1&key1=16
Views: 26751 Magic Monk
Pokemon Go failed to detect location fix
Recently I started playing pokemon go and encountered a problem where it keeps saying failed to detect location. Took me a while to find the fix before I can play the game.
Views: 702179 Magic Monk
Lego Mindstorms EV3 Robotics Lesson 14 - Variables, Loop interrupt, Multiple starts
In this lesson we create a robot that randomly roams around the room and avoids obstacles using the ultrasonic sensor. We also cover the concepts below: - What is a variable and how to use it - How to interrupt / resume a loop - How to have multiple programs running (multiple start blocks)
Views: 29848 Magic Monk
SQL with Microsoft Access 2016 Lesson 6 - In, Between, Brackets
More SQL operators - Between - where we want to select rows with values between a certain range, or In, where we want the values to be in a set of specific values. We also talk about linking conditions together using brackets.
Views: 11059 Magic Monk
How to insert headers and footers in Microsoft Visio
In this lesson you will learn how to insert headers and footers in Microsoft Visio.
Views: 7356 Magic Monk
Microsoft Excel lesson 2 - compound interest calculator (absolute referencing, fill down)
In this lesson we build a compound interest calculator to calculate how much interest the bank will pay you if you save a certain amount of money in the bank. We talk about absolute referencing using dollar signs and what happens when you fill down by dragging the corner dot down the screen.
Views: 60128 Magic Monk
Lined paper in Microsoft Word, PDF
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. http://magicmonktutorials.com/teachingresources/linedpaper.docx http://magicmonktutorials.com/teachingresources/linedpaper.doc http://magicmonktutorials.com/teachingresources/linedpaper.pdf
Views: 15597 Magic Monk
SQL with Microsoft Access 2016 Lesson 12 - Having, Update
In this lesson we talk about what the HAVING clause means (adding a condition for the output of the aggregate function when the GROUP BY clause is used), and we also talk about how to update particular values in a row using the UPDATE clause.
Views: 7586 Magic Monk
Compass bearings and true bearings
In this tutorial you learn how a direction can be represented in two different ways: compass bearings (measured from north/south towards east/west) or true bearings (measured clockwise from the north).
Views: 52685 Magic Monk
SQL with Microsoft Access 2016 Lesson 5 - AND, OR, LIKE
In this video we use the special operators AND, OR and LIKE in our select queries, to achieve some slightly more complicated queries.
Views: 16855 Magic Monk
How to save each page in a PDF in a separate file
In this tutorial you learn how to extract pages out of a PDF file and save them in different files using adobe acrobat pro.
Views: 298025 Magic Monk
Expert Systems lesson 2 - What makes up an Expert System
In this lesson we take a deeper look at what makes up an Expert System - The Knowledge Base, the Inference Engine, and the shell program. We explain each one in detail with examples. Subtitles: English Topic covered in: Year 11 IPT Course, Queensland, Australia
Views: 21944 Magic Monk
Zouk lesson 1
Click here to see Eddie & Priya social dancing these moves to music: http://youtu.be/pJVbTkas-qY Eddie provides a recap of what we learned in Zouk lesson 1 (06/12/2012) with Priya. It's only Priya's first night doing Zouk! Isn't it amazing how fast she has learned. Moves taught: Basic steps in closed Basics steps in open (Latin L). Switch from closed to open Girl / Guy turns Switch from open to closed.
Views: 9277 Magic Monk
VBA Excel 2016 Lesson 2 - Create clear contents macro and assign it to a button
In this Visual Basic for Applications lesson, you will create your first Macro and assign it to a button. The macro simply clears the content in a few cells.
Views: 2314 Magic Monk
Top 100 Mars One Australian Brisbane candidate Natalie Lawler demonstrate a card trick
Newsflash 17/02/2015: Natalie is now in the top 100 of the Mars One program! Watch Natalie on Channel 9 news here: http://www.9jumpin.com.au/show/today/videos/4060606795001/ Brisbane teacher Natalie Lawler is currently one of the 100 candidates in the world still in the running for being picked to go on a mission to Mars, and all of Australia is following her progress. Please like Natalie's facebook page to track her progress: https://www.facebook.com/lawler.mars In the video Natalie also talks about her current progress and for those of you who are interested, how to apply to go to Mars yourself! Here is the magic playlist if you're interested in more magic tricks: https://www.youtube.com/playlist?list=PLzr5fRV1AGV9pkMbsxe3hEmh7f0wxg4Mv
Views: 2275 Magic Monk
How to program Flappy Bird in Visual Basic lesson 1 - Gravity
In this series of videos we will learn to create a flappy bird type game in visual basic. In this first lesson, you learn to program gravity into the game to make an object fall down from the sky.
Views: 22188 Magic Monk
Unity 2018 No intellisense in Visual Studio fix
Just installed Unity 2018 and found that there is no intellisense in the coding! Don't worry, you can get it back in a few steps.
Views: 4500 Magic Monk
How to program Flappy Bird in Visual Basic lesson 2 - jumping, drawing obstacles
In this second lesson on programming flappy bird in visual basic, we make the bird "jump" as well as dynamically generating the obstacles on the screen.
Views: 12544 Magic Monk
This tutorial covers: - What is a function - Function notation - Graphing functions - How to tell if a relation is a function using the vertical line test Once you finish the video, do the quizzes on the website: http://magicmonktutorials.com/videolist.php?key1=11
Views: 1101 Magic Monk
Java Programming with Eclipse lesson 3 - String Variables
In this lesson we learn about why we need variables. We declare a string variable, assign value to the variable, output the variable to the screen and also find out how many characters are in the variable.
Views: 9275 Magic Monk
Unlimited free cloud storage with Google Drive for videos and photos
In a recent discovery, you could upload an unlimited amount of photos AND videos to Google Photos, then have them linked to your google drive, so they don't count towards your storage space - but you must enable these settings.
Views: 16037 Magic Monk
Garmin Connect - How to change miles to km
Are you outside of America and can't understand miles in Garmin Connect? Here's how you change it to km.
Views: 2895 Magic Monk
Only hear microphone sound on one side fix (Scarlett Solo & OBS)
I'm enjoying recording on my new Scarlett Solo Studio except the recorded video only plays my voice on the left hand side speaker. Here is how you fix it.
Views: 38394 Magic Monk