General Assembly - ADVANCED TOPICS IN EXCEL

When: Tue July 29, 2014 6:30 pm

Organization: General Assembly

Location: GA Boston 51 Melcher Street Boston, MA 02210

Website: https://generalassemb.ly/education/advanced-topics-in-excel/boston/6472

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).

About the Instructor

Matthew Macarty Photo

 Consultant & Lecturer in Decision Sciences

Matthew Macarty was principal of EMME Consulting, an early stage venture capital consulting and research organization. He has held management positions in the healthcare and hospitality industries and has served as project manager for a large-scale e-commerce development. Matthew holds a Master in Business Administration degree from Whittemore School of Business and Economics, and a Bachelor of Science in Biology and Nutritional Sciences from the University of New Hampshire. 

Matthew currently is consulting on a DoD SBIR grant and teaches topics in Decision Sciences such as business statistics, quantitative methods and introductory programming at the Paul College of Business & Economics and Bentley University.

Refund Policy

Plans change. We get it. But if you can't make it to a class/workshop, please email us at least 7 days before the scheduled event date. No refunds will be given after this timeframe.