Loading... Please wait...

Blog

Excel 2016: Single and Multicell Array Formulas

Excel 2016 tutorial how to work with single and multi-cell arrays, and they're used to do multiple calculations on a group or range of cells, known as an array, simultaneously.

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 »


Word 2016: Modifying Tables

Word 2016 tutorial on how to modify a table including: inserting, deleting, shifting and modifying the table's cells.

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 »


Word 2016: Reveal And Clear Formats

Word 2016 tutorial on the Reveal Formatting feature that will display the formats currently applied to your selected text, and you'll also see how to clear the formatting as well.

Read More »


Excel 2016: Combining And Nesting Functions AND and IF

Excel 2016 tutorial how to combine and nest functions including the AND and IF functions.

Read More »


Word 2016: Applying And Modifying Styles

Word 2016 tutorial on how to apply and modify Word styles. Styles are a collection of complimentary formats that can be applied in a single click. Also, important is to know that Heading Styles are to be used when using other more advanced features in Word like for example, when it comes to [...]

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