MICROSOFT ACCESS 2016
In this publication, my contributions include a variety of topics regarding the development of database applications using Microsoft Access. Topics include modifying field properties to ensure accurate and consistent data in tables, creating simple and complex queries that not only select data but also create calculations and perform various database actions, and developing a user interface that allows inexperienced users to realize the benefits of relational databases.
MICROSOFT EXCEL 2016
My contributions to this publication include techniques to import, organize, and clean data sets in preparation for analysis as well as utilizing Excel's forecasting and optimization tools, such as data tables, Scenario Manager, and Solver to support decision-making.
ADVANCED PROBLEM SOLVING CASES FOR MICROSOFT OFFICE 2013
In this publication, I cover topics such as developing custom database applications using Microsoft Access for managing employees' time sheets, building spreadsheet models in Excel to make better decisions, and some statistical methods useful in business.
Microsoft Excel 2013
In this publication, I cover topics such as building statistical and financial models in Excel, analyzing relational data and developing executive dashboards with Excel's PowerPivot, as well as, visualizing data with Excel's Power View.
Microsoft Excel 2010
In this publication, I cover topics such as building interactive dashboards in Excel with enhancements using VBA. Dashboards provide a way to monitor key performance indicators about your business.
Microsoft Access 2010
In this publication, I cover topics such as using Data macros to process complex business logic as well as regular macros to automate routine tasks in Microsoft Access.