Excel Intermediate

Learn the techniques for handling large spreadsheets. Use the Solver Add-In analysis tool, the conditional IF function, cell references linking formulas between worksheets, cell and range naming and using named ranges in functions, formatting and customizing charts, the VLOOKUP function and creating a basic macro to automate a regularly used process. Flash drive required: Students must activate their My Northshore account prior to first class.

Audit Paper Trail: Best Practices for Financial Documentation

This course provides a comprehensive guide to establishing and maintaining a solid audit paper trail. You will learn essential documentation techniques to support financial records, including income, expenses, and asset management. The course covers key topics such as understanding audit triggers, which explains who gets audited and why, and income documentation, which details the types and best practices for accurate reporting. You will also learn about record retention, including how long to keep financial records and documents, as well as efficient filing systems to help organize documents for quick access and compliance. Additionally, the course covers expense management, focusing on how to properly document business and office expenses, including those related to sub-contractors and fixed assets. It will also explore best practices for tracking income and expenses related to rental properties. The course will teach you how to develop internal procedures for a robust audit trail to ensure accuracy and accountability. By the end of this course, participants will have the skills to create and maintain a reliable audit trail, ensuring compliance and reducing audit risk. Course Requirement: Students must activate their My Northshore account prior to the first class.