Class 15: Review and Final Project
Topics
1. Review of Key
Features and Functions
- Data Entry and Formatting:
- Understanding how to input data
accurately into Excel.
- Applying formatting options such as font
styles, colors, and borders to enhance readability.
- Formulas and Functions:
- Recap of essential Excel functions such
as:
- SUM: Adds up a range of cells.
- AVERAGE: Calculates the mean of a range of
cells.
- IF: Performs a logical test and returns different values based on
the outcome.
- VLOOKUP: Searches for a value in the leftmost
column of a range and returns a value in the same row from a specified
column.
- COUNTIF: Counts the number of cells that meet a
specified condition.
- Charts and Graphs:
- Creating various types of charts (e.g.,
bar, line, pie) to visualize data.
- Customizing charts by adding titles,
legends, and data labels.
- Data Import and Export:
- Importing data from CSV, text files, and
other Excel workbooks.
- Exporting data to various formats such as
PDF and CSV.
- Advanced Tools:
- Using PivotTables for data summarization
and analysis.
- Utilizing Goal Seek and Solver for
advanced data analysis.
2. Final Project
Instructions
- The final project will require students to
create a comprehensive Excel workbook that combines multiple skills
learned throughout the course. Here’s what is expected:
Project Components:
- Data Entry:
- Import or manually enter a dataset
relevant to a chosen topic (e.g., sales data, inventory, budget).
- Formatting:
- Apply appropriate formatting to make the
data clear and presentable.
- Formulas:
- Use various Excel functions to analyze
the data (e.g., calculate totals, averages, and other necessary
computations).
- Charts and Graphs:
- Create at least two different types of
charts to visualize important aspects of the data.
- Data Analysis:
- Use tools like PivotTables, Goal Seek, or
Solver if applicable to derive insights from the data.
- Documentation:
- Include a brief write-up explaining the
data source, objectives of the analysis, and conclusions drawn from the
results.
Exercise
- Complete the Final Project:
- Students will work independently or in
pairs to complete their final project based on the provided instructions.
- Ensure that all components are included
and properly formatted.
- Present and Discuss the Final Project:
- Each student or pair will present their
project to the class, highlighting key findings, challenges faced, and
skills applied.
- Encourage questions and feedback from
peers to foster a collaborative learning environment.
Conclusion
This final class
serves as a culmination of all the skills learned throughout the course.
Students should feel confident in their ability to utilize Excel for various
tasks and analyses. The final project is an opportunity to showcase their
knowledge and creativity in applying Excel functions and features effectively.
