Data to Decisions: Crafting Excel Reports with Ease Part II

Building on our previous Excel session, this CETL session will focus on employing fundamental Excel functions to generate informative reports. Our goal is to craft a straightforward budget workbook for projects, utilizing a range of Excel formulas and functions to achieve this.

Objectives:

1. Identify the proper functions to create a simple budget workbook
2. Construct a budget workbook building on the functions and formulas used in the previous August projects.
3. Apply the following list of actions in Excel:

1. • Create main reference sheet
   • Connect data from multiple worksheets
   • Lock cells for scrolling
   • Sum formula
   • Percentage formula
   • Format Cells
   • Create Pie Chart
   • Remove Gridlines
   • Color Code Tabs
   • Lock and Protect Worksheet
   • View Excel Templates