Excel Time Shift

How To : Do time calculations with Microsoft Excel's MOD

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 286th installment in their series of digital spreadsheet magic tricks, you'll learn how to calcula ...more

How To : Reverse two way lookup for date & time in Excel

In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he sho ...more

How To : Look up a time value with Excel's VLOOKUP function

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 48th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP, ISTEXT, ISBLANK, ...more

How To : Use Excel date math & time formatting

Once you learn some of the basics, Excel is an easy program to use. With the use of some simple formulas, you can streamline your whole data entry process. Just by typing in =SUM you can set a row or column to show the sum of other entries. It really is that easy. This video w ...more

How To : Break up hours worked by shift in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 624th installment in their series of digital spreadsheet magic tricks, you'll learn how to break a ...more

How To : Format time and make time calculations in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 501st installment in their series of digital spreadsheet magic tricks, you'll learn how to work wi ...more

How To : The Best Video Chat Apps to Use with Your Infant

You know your infant is advanced. Maybe you want to give her or him a head start at learning things like writing code to develop the next big Fortnite game. Or maybe you just want to play Fortnite with your infant. But the American Academy of Pediatrics discourages screen time ...more

How To : Count times exceeding 5 minutes in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 17th installment in their joint series of digital spreadsheet magic tricks, you'll l ...more

How To : Create podcasts in Audacity

Learn how to use Audacity, a free audio editing application that can be used to record music, podcasts, and more. You will learn how to install the LAME Encoder, set your preferences, save the project, record, preview your recordings, edit content, remove noise, adjust volume, ...more

How To : Calculate hours worked in days in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 598th installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more

How To : Drive a manual transmission car or truck

Need to know how to drive a stick shift and have no time to learn? Simple, watch this quick automotive video tutorial to learn how to drive a manual transmission with ease. You will of course learn how to start the car, the clutch pedal, the brake pedal, the gas pedal, the tr ...more

How To : Create a basic array formula in Microsoft Excel

Looking for a primer on how to create and work with arrays in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the very first installment in his series of Excel array formula serie ...more

How To : Create a formula timer in Microsoft Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Formula E ...more

How To : Use the SUMPRODUCT function in Microsoft Excel

Are you looking for a way to make your Microsoft Excel formulas more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the very first installment in his "Excel Formula Efficiency" se ...more

How To : Create a Tangent Line with Excel

Given a function, you can easily find the slope of a tangent line using Microsoft Excel to do the dirty work. That is to say, you can input your x-value, create a couple of formulas, and have Excel calculate the secant value of the tangent slope. This is a fantastic tool for S ...more

How To : Drive a manual car

This is a presentation from WatchMojo detailing the operation of a manual/standard automobile. Explanation includes the placement of pedals listed from left to right as the clutch, the brake, and the gas. There is also an explanation on the gearshift which includes a diagram o ...more

How To : Format dates & calculations in Excel

This is an Excel magic trick video in which the instructor shows how is time represented in Excel and how it is formatted before displaying it to us. He talks about the decimal representation of the time. He says that if O hour is mapped to the number zero and 24th hour of a d ...more

How To : Build a 15-minute schedule in Microsoft Excel

Want to make a time schedule in Microsoft Excel partitioned into perfectly regimented 15-minute intervals? It's easy, provided you know how to go about it. And in this Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how ...more

How To : Do a reverse two way look up in Excel

In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he sho ...more

How To : Use the filter & sort feature in Excel

In this Software video tutorial you will learn how to use the filter & sort feature in Excel. First create a column chart on an excel sheet. In this example, it is a date and sales chart. Click alt+F1 and the chart is displayed. Then click and delete the legend and the horizon ...more

How To : Convert Excel spreadsheet data to XML

Here is a quick video on how to convert Excel spreadsheet data to XML for import into Flash or Flex. Don't spend time typing all that data again, instead create a schema in Excel and convert it to XML.

How To : Take a screenshot on an Apple Macintosh

This video teaches the secrets of taking a screenshot on an Apple Macintosh in simple steps. First open any colorful web page of your choice to take the screenshot. Now hold down the Command, Shift and 3 keys together at a time to take the screenshot. Now close or minimize the ...more

How to Mod Need for Speed : Shift 2 for Xbox 360

We all feel the need for speed from time to time, but sometimes speed alone is not enough. Maybe you feel the need for Need for Speed: Shift 2 career prize money as well. If that's the case, check out this video and learn how to mod NFS Shift: 2 to get maximum career prize money.

How To : Alphabetize in Excel

Need to sort a ton of data in Excel? Why waste time cutting and copying cells? In this tutorial, learn how make Microsoft Excel automatically sort columns or rows alphabetically. You Will Need: • Microsoft Excel • Data to be alphabetized Step 1: Select a row or column Click ...more

How To : Create an animated loading screen style gif

In this how to video, you will learn how create an animated loading gif in Photoshop. First, open the design you want to use for the animation in Photoshop. It should be similar to the design shown. Go to window and click animation to view the animation panel. First, change th ...more

How To : Use the dynamic RAM preview feature in Sony Vegas

One of the most common problems with any video editing software is the preview lag- a result of high quality video slamming your CPU. There is a great fix in Sony's Vegas editing software to allow previews to run full-frame with a slight tweak called the dynamic RAM preview fe ...more

How To : Use container fields with FileMaker Pro 10

This lynda.com video tutorial shows how to use container fields with FileMaker Pro 10. When you want to create fields in FileMaker database you have the choice on what kind of fields you want to make. Many general fields are self explanatory like text, date etc., but there is ...more

How To : Understand car battery basics

For most automotive applications a battery needs to supply a lot of current for a short period of time to turn over the engine and get the car started. With the engine running, the car's alternator produces all the power the car needs. Thin plates inside a starting battery inc ...more

Prev Page
  • Hot
  • Latest