March 2016 schedule of Access, Project, Excel & VBA training in Atlanta, GA.
Tag Archive: excel 2013
Excel VBA, Access, Project Training – Feb 2016
February 2016 schedule of Access, Project, Excel & VBA training in Atlanta, GA.
Excel File Corrupted? Here’s 1 Way to Recover Data
Do you think your Excel file is corrupted? Recovering corrupted Excel files can be a challenging process. If you are able to open the file, this method may save you time and headaches.
#1 Cause of Pivot Table Headaches
The key to maximizing Excel Pivot Table’s powerful features is making sure your source data is properly formatted.
Excel VBA, Access, Project Training – Jan 2016
January 2016 schedule of Access, Project, Excel & VBA training in Atlanta, GA
Excel Tip – How to Protect Specific Cells
Wondering how to protect specific cells in Excel? This blog post has the step-by-step instructions.
Paste Values Keyboard Shortcut (Excel Tip)
Excel Tip – Find yourself pasting values often? Here’s a keyboard shortcut to speed up the process.
Ask Jackie: How to Copy Excel Subtotals to A New Workbook
Excel Tip: “When I do subtotals, how can I copy just the subtotals to a new Excel workbook?”
Hey! What Happened to My Ribbon?
The steps you used to un-hide the ribbon in Office 2010 will not work in version 2013. For step-by-step instructions, read this article.
Excel Tip: Summarize Multiple Worksheets Quickly with 3D Formulas
Looking for an almost instant way to summarize a workbook that has multiple sheets? Whether your workbook has 5 sheets or 50, here’s a solution.
