Loading... Please wait...

Blog

Excel 2016: Subtotals

Excel 2016 training video on how to use the Subtotals feature which is used to quickly calculate rows of related data by inserting subtotals and totals.

Read More »


Excel 2016: Advanced Filter & Macros

Excel 2016 training video on how to use the Advanced Filter feature on a list range, or database in conjunction with a criteria range. And to help the process go fast, I've also included a Macro!

Read More »


Excel 2016: AutoFilter

Excel 2016 tutorial on how to apply the AutoFilter feature to your database, allowing you to filter your records by column label, or header.

Read More »


Excel 2016: Top 6 Database Design Flaws To Avoid

Excel 2016 tutorial on the top 6 design flaws when it comes to creating a database in Excel so it's recognized by Excel as a database. For example, where Excel will be able to sort and keep all your records together in your database and not split, or break it up from a poorly [...]

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: Table Sorting And Filtering

Excel 2016 tutorial on how to sort and filter your records in an Excel table.

Read More »


Word 2016: Modify Document's Layout

Word 2016 tutorial on how to modify your document's layout including orientation: landscape, and portrait, margins, paper size and center vertically.

Read More »


Excel 2016: Modifying Tables

Excel 2016 tutorial on how to modify tables including: add, remove rows or columns, removing duplicate records, adding a total row and more!

Read More »


Excel 2016: Create Tables

Excel 2016 tutorial on how to have Excel treat a part of your worksheet as a separate datasheet by converting that range of cells into a table.

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