CPCC login and textbook required. Recommended: DPT 8014 or equivalent knowledge. In this course, you will work on real-world problems like the ones you encounter in the work environment. Learn how to format and manage worksheets, and create ranges to manipulate your data with macros and functions. Create analytical and financial reports and begin building a workbook cross-referencing multiple worksheets.