About This Workshop
The Excel & Analytics workshop is designed for students who are relatively familiar with other office productivity software, for example, Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential that can be achieved with Excel and touches briefly on everything from navigation and layout to using functions and charts. This workshop was not designed to go over any topic in extreme detail, but more as a “sampler” of topics. The expectation is for students to be able to leave and be familiar with several of the Excel skills necessary for most positions that require some “basic to intermediate” Excel knowledge. This course is excellent prep for other Data Analytics Courses.
Agenda (Not necessarily taught in the order below):
- Terminology and Navigation
- Formatting and Filling
- Data Organization and Filtering
- Conditional Formatting
- Hiding and Grouping
- Introduction to Formulas
- Basic Math Functions
- Conditional Math Functions
- Reference Functions
- Basic Data Cleaning
- Defined Names
- Freezing Views
- Adding Notes and Comment
- Input, gather, prep, and format data for more productive use and sharing.
- Analyze data to improve decision making.
- Save or export data, tables, and charts for others to use or view
Students should have a general familiarity with Excel including knowing how to navigate a spreadsheet and how to copy & paste. Please bring a laptop with Microsoft 2016 or 2019 installed (PC or Mac) but please note there may be minor differences between Microsoft’s implementation on the two platforms. It is also highly recommended that you have a mouse. A second monitor or tablet is not required but highly recommended.
Students will be emailed case study files prior to class that they should download to their desktop. This is an interactive class, and your participation and questions are encouraged.
This class will occur completely online so students should also have a laptop or computer with at least 4GB RAM and a working microphone and camera. Class pre-work will be distributed via email which will include detailed instructions for downloading Zoom and Slack (where the class will be hosted). An internet connection of at least 10 Mpbs download speed is also highly recommeded.