$350 USD each
-
Over two live, three-hour sessions, you’ll learn why Excel is the leading tool — and how to use it — to enhance the way you analyze and restructure your data.
We’ll start with the basics of exploratory data analysis (EDA) to familiarize yourself with a dataset, and how to apply Excel formulas and best practices to clean a dataset and get it ready for analysis.
From there we’ll get into the actual analysis using references and ranges to manipulate the data, connecting data from multiple spreadsheets with popular functions like LOOKUP and creating PivotTables to quickly summarize your data. And what analysis is complete without some basic visualization? You’ll get hands-on practice with charts and conditional formatting to make your analysis easy to interpret.
By the end of this workshop, you’ll be equipped with the tools and knowledge to ask — and answer — the right questions of your data in Excel. You might even be inspired to pursue a career in data analytics with your new skills.
Please Note: Registration for this workshop will close 24 hours before the scheduled start date.
We understand that, sometimes, plans change. If you can no longer make it to a class or workshop, please email us at least 7 days before the scheduled event date. No refunds will be given to cancellations made within a week of the class or workshop.
Your registration for or attendance at any General Assembly offering indicates your agreement to abide by this Community Code of Conduct policy and its terms.
%20to%20familiarize%20yourself%20with%20a%20dataset,%20and%20how%20to%20apply%20Excel%20formulas%20and%20best%20practices%20to%20clean%20a%20dataset%20and%20get%20it%20ready%20for%20analysis.%0D%0A%0D%0AFrom%20there%20we%E2%80%99ll%20get%20into%20the%20actual%20analysis%20using%20references%20and%20ranges%20to%20manipulate%20the%20data,%20connecting%20data%20from%20multiple%20spreadsheets%20with%20popular%20functions%20like%20LOOKUP%20and%20creating%20PivotTables%20to%20quickly%20summarize%20your%20data.%20And%20what%20analysis%20is%20complete%20without%20some%20basic%20visualization?%20You%E2%80%99ll%20get%20hands-on%20practice%20with%20charts%20and%20conditional%20formatting%20to%20make%20your%20analysis%20easy%20to%20interpret.%0D%0A%0D%0ABy%20the%20end%20of%20this%20workshop,%20you%E2%80%99ll%20be%20equipped%20with%20the%20tools%20and%20knowledge%20to%20ask%20%E2%80%94%20and%20answer%20%E2%80%94%20the%20right%20questions%20of%20your%20data%20in%20Excel.%20You%20might%20even%20be%20inspired%20to%20pursue%20a%20[career%20in%20data%20analytics](https://generalassemb.ly/students/courses/data-analytics-bootcamp)%20with%20your%20new%20skills.%0D%0A%0D%0A**Please%20Note:**%20Registration%20for%20this%20workshop%20will%20close%2024%20hours%20before%20the%20scheduled%20start%20date.&link=https://generalassemb.ly/education/excel-fundamentals-two-day-evening-workshop/new-york-city/203440&picture=https://ga-core.s3.amazonaws.com/production/uploads/program/default_image/18020/GA-Workshops-Horizontal.jpg&redirect_uri=https://ga-core-production-herokuapp-com.global.ssl.fastly.net/education/excel-fundamentals-two-day-evening-workshop/new-york-city/203440)
