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 list of QuickBooks shortcuts… Source. Hector GarciaMore Posts Follow Me:
Complete list of excel shortcuts… Hector GarciaMore Posts Follow Me:
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 […]
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 […]
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 […]
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:
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 […]
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 […]
Blog Postings from Microsoft’s Excel Blog:
No items to display at this time.