# Category: Excel Training Tutorials

### Complete QuickBooks Shortcuts

Complete list of QuickBooks shortcuts…   Source.

### Complete Excel Shortcuts with Explanations

Complete list of excel shortcuts…

### Microsoft Excel Cheat Sheet and Quick Reference Guides

Hello, I just wanted to list a few available guides (PDF) for Microsoft Excel I found on the web: Excel 2013 2-page Quick Reference Guide

### Learn Excel Pivot Table in 1 hour

I saw a webinar today by John Michaloudis by myOnlineTraininghub… and it ws fantastic.  Learn how to work pivot tables in one hour! Here is the

### 468 Excel Functions from the “Excel Function Bible”

I recently discovered The Excel Function Bible: http://www.rondebruin.nl/efb/efb.htm This site has explanations about all 468 Excel Functions, check it out… This is a copy/paste from

### VLOOKUP Video Tutorial

The microsot website posted a Video Tuorial series on Vlookup for Excel.  I strongly recommend you check it out: http://office.microsoft.com/en-us/excel-help/overview-RZ101862716.aspx?section=1   Also be sure to

### Advanced IF function in Excel

First, you can download the Full Course here from the Microsoft website, or watch the videos online: 1 – Advanced IF Function Before we get started

### VLOOKUP: Quick Reference & Troubleshooting Guides (PDF)

VLOOKUP is one of the most popular, useful functions in Excel, but it’s hard to remember the formula if you don’t use it that often.

### Import Transactions from Excel into QuickBooks: Create your own .QBO files

Updated 01/20/2015 Hello, first of all let me explain what a .QBO file is.  This is the File your bank usually allows you to manually

### QuickBooks Video: Import data from Excel into QuickBooks

This video is a great intro to importing data from excel or copy/paste data from excel into QuickBooks.  This works in QuickBooks 2011, 2013, 2014,

### Basic Excel Training: Moving Columns

The ability to move columns around where they are needed is extremely helpful when working in Excel. The entire column; along with its text, values,

### Basic Excel Training: Inserting New Rows

When working with spreadsheets, it is often necessary to add extra rows and insert columns as your data grows. It frequently occurs that new information