This Blog is dedicated to articles we write on this site related to learning Excel vis these Excel Training Tutorials.  Some of these articles are also links from other Excel Blogging Sites.  If these articles are not enough for self-training and you need a live in-person Excel Basic/Intermediate Course in South Florida, contact us.  We also have custom Advanced Excel Training solutions.

Complete QuickBooks Shortcuts

Complete list of QuickBooks shortcuts…   Source. Hector GarciaMore Posts Follow Me:

Posted in Excel Course, Excel Tips / Miami Broward, Excel Training Tutorials | Leave a comment

Complete Excel Shortcuts with Explanations

Complete list of excel shortcuts… Hector GarciaMore Posts Follow Me:

Posted in Excel Course, Excel Tips / Miami Broward, Excel Training Tutorials | Leave a comment

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 http://www.customguide.com/cheat_sheets/excel-2013-cheat-sheet.pdf Excel MAC 2011 Cheat Sheet http://www.customguide.com/cheat_sheets/excel-2011-cheat-sheet.pdf Excel 2013 8-page comp http://www.towson.edu/adminfinance/ots/Training/documentation/Excel2013/Excel2013qrg.pdf Microsoft’s Basic Getting Started Guide http://download.microsoft.com/download/9/8/5/985e8eca-48ea-401d-a3b8-4121c2ea0df3/AF103733534_en-us_excel2013quickstartguide.pdf Most Important Shortcuts in Finance 2007-2010-2013 https://samples-breakingintowallstreet-com.s3.amazonaws.com/BIWS-Excel-Shortcuts-2007-to-2013-Plus.pdf Excel 2013 Missing Manual eBook […]

Posted in Advanced Excel, Blog Postings & Tips, Excel Course, Excel Tips / Miami Broward, Excel Training Tutorials, Hector Garcia, Shortcuts | Leave a comment

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 replay video: http://bit.ly/PivotTable022615 Improve Your Excel and Analytical Skills Overnight: PivotTables enable you to take massive amounts of data and quickly summarise and analyse it with just a few clicks of […]

Posted in Blog Postings & Tips, Excel Course, Excel Tips / Miami Broward, Excel Training Tutorials | Leave a comment

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 their downloadable spreadsheet: ABS Returns the absolute value of a number ACCRINT Returns the accrued interest for a security that pays periodic interest ACCRINTM Returns the accrued interest for a […]

Posted in Advanced Excel, Excel Course, Excel Tips / Miami Broward, Excel to QuickBooks, Excel Training Tutorials | Leave a comment

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 download the VLOOKUP Quick Reference Guide: http://office.microsoft.com/en-us/excel-help/redir/AF101984660.aspx?CTT=5&origin=HA101873816   Hector GarciaMore Posts Follow Me:

Posted in Excel Course, Excel Tips / Miami Broward, Excel Training Tutorials, Videos, VLOOKUP | Leave a comment

Quick Pivot Tables in Excel with QuickBooks Data – Export Excel to QuickBooks

UPDATED MARCH 2015 This article is a combination review of a 3rd party utility called “QB2Excel” by InformationActive and a step by step instruction on how to quickly you can produce a seemingly complex pivot table in excel using QuickBooks data in a matter of minutes!  AT THE BOTTOM OF THIS ARTICLE IS THE LINK […]

Posted in Advanced Excel, Advanced QuickBooks, Blog Postings & Tips, Excel to QuickBooks, Excel Training Tutorials, Hector Garcia, Import Excel Data into QuickBooks, QuickBooks to Excel | Leave a comment

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 with advanced IF functions, let’s do a quick IF function refresher first. Watch this video for some examples.       2 – Nested IF Function Nested IF functions, meaning one […]

Posted in Advanced Excel, Blog Postings & Tips, Excel Course, Excel Tips / Miami Broward, Excel Training Tutorials | Leave a comment

Blog Postings from Microsoft’s Excel Blog:


For More Information

Call us to 954-633-2718 or email: hector@quickbooks-training.net