# Category: Excel Tips / Miami Broward

### 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

### PDF Quick Reference Guide to Microsoft Excel 2013

This is a really good free PDF Quick Reference Guide online: http://www.towson.edu/adminfinance/ots/Training/documentation/Excel2013/Excel2013qrg.pdf Excel2013qrg   Also, here is Microsoft’s Quick Start Guide: http://www.enliten-it.com/sites/default/files/QRC/QRC%20-%20excel2013.pdf QRC – excel2013

### 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.

### 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

### Basic Excel Training: Inserting New Columns

Among the most frequently used functions in Excel, inserting new columns and rows is an essential aspect of creating professional spreadsheets. You are able to

### Basic Excel Training: Finding Specific Data

There is nothing worse than having volumes of data and needing to find specific information within it. Fortunately, you are able to search for text