Fast Starter Salary Analysis

A step-by-step Excel assignment for business and accounting students that builds core spreadsheet skills through hands-on salary data analysis.

This presentation is a step-by-step Excel tutorial designed for business courses. Students follow 34 PowerPoint slides with individually numbered steps that guide them through analyzing salary data, applying core Excel functions, and interpreting results using spreadsheet tools commonly used in business and accounting contexts

Spreadsheet Setup and Navigation
- Creating and saving Excel workbooks
- Navigating worksheets and locating key input areas

Formulas and Core Functions
- Building formulas using cell references
- Using functions such as SUM, AVERAGE, and basic calculations
- Decision making with IF, IFERROR, MOD, and MAX
- Financial calculations with PV and FV
- Understanding relative vs. absolute references

Data Analysis
- Analyzing salary data using formulas
- Comparing values across roles or categories
- Interpreting calculated results

Formatting and Presentation
- Applying number formatting for clarity
- Crafting custom number formats
- Using basic formatting to improve readability and professionalism
- Presenting results in PivotCharts
- Formatting charts and creating dynamic titles
- Applying cell styles

Building in Interactivity
- Enabling the Developer tab in Excel’s ribbon
- Controlling user inputs with spin buttons
- Creating text boxes

Workbook Accuracy and Review
- Verifying results
- Ensuring required cells are completed correctly
- Preparing the file for submission

Step 1: Record your 4-digit Spreadsheet ID

The Spreadsheet ID is used throughout the assignment to help ensure each student submits unique work.

Students: Your Spreadsheet ID appears on your dashboard.
Faculty/Teaching Assistants: You may use any 4-digit number as your Spreadsheet ID.

Step 2: Complete the assignment alongside the instructional video

You will start the assignment with a blank Excel workbook. Choose the tutorial that matches your Excel environment:

Watch the 1 hour, 34 minute step-by-step MP4 video

Watch the 1 hour, 34 minute step-by-step MP4 video.

View background on why this assignment requires Excel for Windows or Mac.

Step 4: Submit your completed spreadsheets via your dashboard

return to your dashboard

Keep these tips in mind to ensure clean submission of your work:

Close Excel completely before attempting to upload your work.
Make use of the alternate submission methods if needed.

How This Assignment Is Graded

An automated tool is used to grade your work based on completion and accuracy, including partial points for incorrect steps. Your instructor determines how scores are applied toward course credit.

Need help?

FAQs

Click here to access of list of frequently asked questions about this assignment.

Learn More

Support

Support is email-based. In rare instances Zoom meetings are available when issues cannot be resolved otherwise.

Get Support

Fast Starter Salary Analysis Assignment