Enjoy the Benefits of Scripts and Power Automation. Excel Automation without VBA Macros is now possible. You can now use Office Scripts and Power Automate instead of Excel VBA macros to automate repetitive tasks. You can also use Power Automate to schedule these tasks to take place at times that your organsiation requires. One of …
Tag Archive: Excel
Excel File and Data Processing
I develop routines for organisations that can quickly process your data and files. The raw data can come from: Excel SAP Oracle Other Database Systems The data is then processed to produce the relevant data for your needs. This data can then be used in: Master Excel file Multiple Excel files Exported out to PDF, …
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 …
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 …
Spreadsheet Training – Microsoft Excel
Among some of the many topics that I cover are the following: Designing Workbooks Entering and Editing Data Formatting Worksheets Functions Charts Vlookups, Hlookups Database Features Printing Taming the Ribbon in Excel 2007 / 2010 / 2013 Macros VBA Programming Working with Procedures and Functions Understanding Objects Using Expressions, Variables, and Intrinsic Functions Controlling Program Execution …