Event

Saturday, January 13, 2018 - 10:00am

Excel Bootcamp

Location: 
GA Boston
125 Summer St 13th Floor
Boston, MA
Organization: 
General Assembly

About This Workshop

We’ve all heard of Microsoft Excel, and yet a surprising number of people have little to no experience using it. In this class — ideal for people working in business, management, or simply interested in getting more organized — you’ll learn the basics of the application, including calculation, formatting, and charts. The class will also 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.

Topics include:

  • Formatting and Conditional Formatting
  • Advanced Copy and Paste Options
  • Handling Text and Dates
  • Basic and Nested Formulas
  • Logical Functions
  • Lookup Functions
  • Efficient Data Entry
  • Creating Drop-Down Lists
  • Pivot Tables
  • Basic Charting

Takeaways

  • Input, transform, and format data for more productive use.
  • Analyze data to improve decision making.
  • Organize and package data for external consumption.
  • Learn how to easily manipulate datasets using pivot tables and other functions.
  • Find out how to leverage the onboard data analysis tools to make effective conclusions on data.
  • Master the art of shortcuts to streamline the process of analysis in Excel.
Event Category: 

60 day posting for only $200