Roses wilt. Skills don't. Our Valentine's Day gift to you? Savings on a bootcamp, short course, or workshop of your choice.
This is IT. Learn the skills you need to break into a career in information technology with our newest bootcamp.
Adobe Digital Academy, now available for marketers and creatives in the US, UK, and India.
Adobe Digital Academy, now available for marketers and creatives in the US, UK, and India.
Join our Alumni Spotlight on Wednesday, February 26 with an ascending design leader from one of the world's biggest insurance brands.
$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.
Conduct exploratory data analysis (EDA) in Excel to familiarize yourself with a dataset and generate descriptive statistics.
Utilize Excel formulas to apply data cleaning best practices, including splitting or combining columns, working with text data, and handling NULLs.
Use absolute references, relative references, and named ranges to effectively manipulate data.
Connect data across multiple spreadsheets using LOOKUP, INDEX, and MATCH functions.
Create PivotTables and use Excel aggregation functions to quickly summarize data.
Apply conditional formatting and create common Excel charts to visualize trends and outliers in data.
This workshop is for beginners. No prior knowledge or experience required.
You’ll need an Excel account for this workshop — Google Sheets will not be covered. If you don’t have an Excel account already, you can sign up for a Free 1-Month Trial of Microsoft 365.
Look out for an email one day before, and one hour before the workshop begins with the Zoom link. If you don’t see the email, please reach out to help@ga.co and we’ll get you set up ASAP.
There is no certificate for completing this workshop.
Your registration for or attendance at any 足球竞彩网 Assembly offering indicates your agreement to abide by this 足球竞彩网 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](/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=/education/excel-fundamentals-two-day-evening-workshop/online/204281&picture=https://ga-core.s3.amazonaws.com/production/uploads/program/default_image/18020/GA-Workshops-Horizontal.jpg&redirect_uri=/education/excel-fundamentals-two-day-evening-workshop/toronto/204281)
