Excel Saturday | Online
About this workshop
Excel Bootcamp
About This Workshop
For most professionals, the ability to organize information is quickly becoming a fundamental part of the job description. Whether you already consider yourself an expert or are just getting started with spreadsheets, this hands-on workshop will allow you to take your skills to next level and become a “power” user. We’ll start with the absolute basics, and move on to lesser known shortcuts, functions, features that you will be able to immediately put to use on the job.
Takeaways
Accelerate the internalization of key time-saving shortcuts for navigation and editing. Work smarter and take advantage of the most helpful functions and features. Enhance the presentation of your data by adding charts and formatting.
Advanced Topics in Excel
About This Class
Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put students in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize and analyze data and go through situational overviews of time-saving shortcuts to improve your efficiency dramatically.
Takeaways
Learn how to easily manipulate datasets using pivot tables and other functions. Find out how to leverage the onboard statistical analysis tools to make effective conclusions on data. Master the art of shortcuts to streamline the process of analysis in Excel.
Prereqs & Preparation
Students should have a basic understanding of Excel and rudimentary functions (IF, SUMIF statements) as well as how to organize data into functional tables (i.e. how to create a data table in Excel with a simple understanding of sort and filter functionality). Students should bring a laptop with Excel 2010 installed. PC-based laptops are preferable, though not required (certain shortcuts may not transfer directly into Excel for Mac). Students should try to arrive a few minutes early to class, if possible.
