Publications

 Click image to purchase

Click image to purchase

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. 

 Click image to purchase

Click image to purchase

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. 

 Click image to purchase

Click image to purchase

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.

 Click image to purchase

Click image to purchase

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.

 Click image to purchase

Click image to purchase

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. 

 Click image to purchase

Click image to purchase

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.