Learn How to Use VBA and Python in Microsoft Excel by Loretta Jones

Add Time Macro:

• Adds time from daily time sheet to Open Projects and Effort Hours Worksheets

• Time savings per day with 150 employees: approximately 2 hours

Accrue Time Macro:

• Accrues Hours and Billing Amount

• Applies Standard and Overtime Rates

• Creates Accrual Detail Sheet for Verification

Time savings: 5 to 6 hours per week

Microsoft Excel with Python: Python extracts data from an Access Database and creates a weekly schedule. Formerly, both the database and an Excel spreadsheet required maintenance, resulting in duplicate data entry. The program applies multiple conditions and cell formatting to produce the desired result with data directly from the database.

About the presenter:

Loretta Jones is a computer programmer specializing in systems integration. She enjoys working with multiple programming languages, ERP systems, databases, and file formats. Python is her preferred language, and Raspberry Pi is one of her favorite devices to work with. Her hobbies include farming, gardening, and hiking. She treasures spending time with family.