Excel Bootcamp
When:
Saturday, Sep 23, 2017 10:00a -
4:00p
Where:
GA Boston
125 Summer St 13th Floor
Boston, MA 02110
Admission:
$250
Categories:
Business, Tech
Event website:
https://generalassemb.ly/education/excel-bootcamp/boston/37457
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.
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.