Category Archive: Excel

Excel Dashboards

Excel Dashboards Training Excel Dashboards are reports that allow senior management or directors to get high-level overview of the business or organisation. Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner. You will learn how to explore and analyse your data by creating an …

Continue reading »

Excel – Moving to Excel 2013 / Excel 2016

Moving from Excel 2003 to Excel 2016 (or ( Excel 2007, Excel 2010 or Excel 2013 ) can be fraught with difficulty if not done correctly. Where to find menu-to-ribbon reference guides, training, and other useful resources for Excel 2013 / Excel 2016 ? Where to find things you might be looking for, such as …

Continue reading »

Spreadsheet Training – Microsoft Excel

Among some of the many top­ics that I cover are the following: Design­ing Workbooks Enter­ing and Edit­ing Data Format­ting Worksheets Func­tions Charts Vlookups, Hlookups Data­base Features Print­ing Tam­ing the Rib­bon in Excel 2007 / 2010 / 2013 Mac­ros VBA Pro­gram­ming Work­ing with Pro­ced­ures and Functions Under­stand­ing Objects Using Expres­sions, Vari­ables, and Intrinsic Functions Con­trolling Pro­gram Execution …

Continue reading »