Loading... Please wait...

- function

Microsoft Access 2016 Reports: Ceate Custom Calculating Fields

Posted by

Microsoft Access 2016 training video on how to create a field that you can add a formula, or function to and do some calculations by itself, or with other fields in your reports!

View Comments


Access 2016 Queries: Basics On Adding Calculating Fields

Microsoft Access 2016 training video on how to create a field that performs a calculation on other fields using functions, or formulas.

Read More »


Word 2016: Table Formulas, Functions & Calculations

Word 2016 training video on how to add a formula, or function to do calculations with the numbers in your table cells.

Read More »


Excel 2016: Date And Time Functions

Excel 2016 tutorial on how to calculate the difference between two dates, like the number of days, as well as inserting the exact time.  Also, how to exclude holidays from your calculations.

Read More »


Excel 2016: DSUM DAVERAGE DCOUNT Functions

Excel 2016 tutorial on how to add, average or count up a range of cells in a column (field) of records in a list or database, based upon the criteria you specify in a mini or sub database using the DSUM, DAVERAGE and DCOUNT functions in this Excel 2016 training video.

Read More »


Excel 2016: HLOOKUP Function

Excel 2016 tutorial on the Horizontal Look Up or HLOOKUP function that allows you to look up a value, in a table, and compares the look up value to the values listed in the top most row of the table, and then returns the value from the column you specify as you'll see in this [...]

Read More »


Excel 2016: VLOOKUP Function

Excel 2016 tutorial on the Vertical Look Up or VLOOKUP function that allows you to look up a value, in a table, and compares the look up value to the values listed in the left most column of the table, and then returns the value from the row you specify as you'll see in this [...]

Read More »


Excel 2016: LOOKUP Function

Excel 2016 tutorial on the LOOKUP function that will look in one row, or column range, or vector range, for a value and a return value from the same position in one row or column.

Read More »


Excel 2016: SUMIFS, COUNTIFS And AVERAGEIFS Functions

Excel 2016 tutorial on how to place conditions, or criteria on what you want to sum or add up, count up, or average out by using the SUMIF, COUNTIF and AVERAGEIF as well as the plural SUMIFs, COUNTIFs and AVERAGEIFs functions respectively.

Read More »


Excel 2016: PMT or Payment Function

Excel 2016 tutorial on the PMT or Payment function that is used to calculate the monthly payment amount on a loan like a car or house using the three variables in the syntax including: interest rate, number of payments and the principle amount.

Read More »



Sign up to receive information about new videos:

Contact Info

Professional & Certified Training
on Microsoft's Office: Access, Excel, Outlook, PowerPoint, Project and Windows.

Dream Force, LLC
10348 S. 2420 E.
Sandy, UT 84092

800-978-9790
801-278-0892

Kirt Kershaw
Microsoft Certified Trainer

Kirt has over a decade of training experience with Microsoft's Office and Windows. He holds Microsoft Certifications from the year 2000 to the present, and can help you certify too!


Access 2016 Training Videos | Excel 2016 Training Videos | Word 2016 Training Videos | Office 2013 Training Videos | Access 2013 Training Videos | Excel 2013 Training Videos | Outlook 2013 Training Videos | PowerPoint 2013 Training Videos | Project 2013 Training Videos | Word 2013 Training Videos | Office 2010 Training Videos | Access 2010 Training Videos | Excel 2010 Training Videos | Outlook 2010 Training Videos | PowerPoint 2010 Training Videos | Project 2010 Training Video | Word 2010 Training Videos | Office 2007 Training Videos | Access 2007 Training Videos | Excel 2007 Training Videos | Outlook 2007 Training Videos | PowerPoint 2007 Training Videos | Project 2007 Training Videos | Word 2007 Training Videos | Windows 7 Training Videos | Windows Vista Training Videos

Microsoft Office Training Videos Home | DVD | Download | Reviews | About | Contact