Basic Calculations in LiveCycle Designer. Uses FormCalc. An important initial step is not shown in the video - choosing the scripting language. In the video I am using FormCalc To set the form to use FormCalc 1.Select File Menu 2.Choose Form Properties 3.Click the Default Tab or Page 4.Select FormCa...

How to take an equation in slope-intercept form, y=mx+b, put it in the TI84, make the graph, set the window, and see the table of values...

Create formulas in a table in Word 2007 or 2010. If you have complex formulas, don't attempt this in Word. Use Excel and do a copy/paste which is much more user friendly! This covers the basics, addition, subtraction, multiplication, division plus totaling...

Using Excel to calculate compound interest with the Future Value (FV) formula and Excel's built in FV function...

This series is for anyone who wants to know Excel in a non-intimidating, soup-to-nuts manner. If you've never used Excel, this is your starting point. No prior experience is necessary. If you've used Excel but never had formal training, this course will fill in the gaps so it all makes sense and so ...

Registration Link : Microsoft Office EXCEL Workshop GLORIOUS MINDMINE presents One Day Excel (Basic + Advanced) Workshop Excel Workshop Course Details Excel Basics Format Cells - Worksheets - Edit Cells - Rows & Columns - Find & Replace - The Fill Handle Calculations Sum - Average - Countif ...

Surely one of the most useful projects Norm's ever built for the shop is this work table. It's a light weight, yet sturdy, assembly table that is easily raised up on casters to move around the shop as necessary. The mechanism for the caster assembly was borrowed from a nearby scenic shop where mobil...

Proper rpm on the lathe and mill increases tool life and productivity. This lesson discusses how to determine the proper cutting speed for various metals and how to convert that cutting speed to the correct rpm for the tool or part...

Operations Management 101: Introduction to Decision Analysis In this video we discuss the very basics of quantitative decision analysis. After talking through a few example scenarios we work a simple example by setting up a decision table. Using the table we learn to calculate the following: Maximax...

Compound interest is the amount that a dollar invested now will be worth in a given number of periods at a given compounded interest rate per period. Although Microsoft Excel does not include a function for determining compound interest, you can use the following formula for this calculation =(PV*(1...

Download file (ALL THE WAY AT BOTTOM OF PAGE): Keyboards 0:01:47 Jump: Ctrl + Arrow 0:02:20 Go To Cell A1: Ctrl + Home 0:02:36 Highlight column: Click, Shift, Click 0:02:50 Toggle Ribbon tabs On/Off: Ctrl + F1 0:03:18 Format Cells dialog box or in a chart Format Chart dialog box: Ctrl + 1 0:03:40 Cu...

Excel Tables are a special feature of Excel. You simply click on a button that says "Insert Table" and then Excel automatically inserts filters for you and lets you perform easy calculations on your dataset (e.g., min, max, average)-without having to memorize any formulas. Ann K. Emery Exp...

This is the second video dealing with GCSE compound interest question. This time the question uses the formula: Amount after n years = (starting amount) x (multiplier)^n "Raj invested 4500 for 3 years in a savings account. He was paid 4% compound interest per year. How much did Raj have in his ...

With a Frequency Distribution Report, you can quickly see how often certain results occur. For example, how frequently are daily sales "under $75.00? In this lesson, I demonstrate two ways to produce a Frequency Distribution: 1) Use the =FREQUENCY Function - an Array Function 2) Group Row Label...

Download Excel File: See how to 1) (00:08 min) Intro. 2) (01:21 min) Approximate Match with VLOOKUP. 3) (02:20 min) Approximate Match with AGGREGATE (to simulate logic that is present in DAX formula). 4) (05:11 min) Approximate Match Lookup in PowerPivot DAX using CALCULATE, MAX, FILTER and Boolean ...

Get my free 3 hour Introduction to Excel 2013 course. Get 17 training videos to help you learn MS Excel 2013. Click here to get the free course: During this Excel 2013 tutorial, the trainer explains formula tab in the ribbon interface. Moreover, you will discover the different functions within the f...

How to work out drug dosages. This part of a series looking at math calculations used by nurses. To do IV calculations go here...

During Tableau training we often get asked whether you can offer a hide/show option for reference lines on a published dashboard. Tableau doesn't have a native option to support this, but we can leverage parameters and table calculations to implement the functionality ourselves. This video demonstra...

Published on Nov 14, 2014 14th November 2014 AUT SPRINZ Conference & Workshop Excel Tricks Session - Project #2 A more detailed run-through of the Test Data Management Project Demonstration of both Pivot Table and Formula reporting using a large dataset. Excel 2013 has capability with Pivot Char...

Download Excel file: Learn about: 1)VLOOKUP to lookup an exact match 2)VLOOKUP to lookup an approximate match 3)VLOOKUP can return a value to a cell 4)VLOOKUP can return a value to a formula 5)VLOOKUP can lookup values on a different sheet (Name table and use name in VLOOKUP function) 6)Use VLOOKUP ...

The MFTC is a homemade multi function tool cart, it is a folding workbench on wheels that can carry all the tools you need for a quick set up on site or in the workshop. It has extension tables that allow you to adapt the size of the workbench to your needs. Go to my website on the above link for mo...

Microsoft Excel is a powerful spreadsheet program. Please note that in this class we will use Excel 2007 or 2010. We will explore how to create a formula, copy and manipulate calculations, work with functions and operators, and handle relative and absolute references...

This tutorial video will be looking at reviewing calculated fields and columns, as well as choosing which one we should use and why...

Download file: Scroll to down to PowerPivot Section. See how to create 9 different DAX functions or Calculated Fields 1. (00:08 min mark) Overview of Reports we need to create 2. (01:05 min mark) Calculated Fields Overview 3. (01:58 min mark) Calculated Column For Net Revenue using ROUND and RELATED...

Build a simple workbench for around $60 in less than an hour! This is a great addition to your garage or workshop and can me made with simple tools. Makes working on car parts and DIY projects much easier! The lengths you'll need are: 1 X Bench top (1200mm X 600mm) 2 X 1200mm (Bench frame) 2 X 540mm...

Excel 2013 Tutorial This is a Crash Course on Microsoft Excel 2013 Office 365 Tutorial for Beginners. By the end of this 4 video Excel course you should have a decent understand of the most common and basic Excel functions and commands. In this video we show you how to do basic math formulas in Exce...

In this video, we will create a custom formula to calculate values that are not stored in the data source. Visit us at to view our full catalog of interactive SAP BusinessObjects BI Suite tutorials...

To help you make your angle calculations and not have to worry too much about the math, we've compiled these handy tables and diagrams...