Excel 1-Day Fundamentals Workshop
About This Workshop
Whether you are in business, management, or simply interested in getting more organized, this Excel 1-Day Fundamentals Workshop will cover the tools and functions you need to automate and enhance the way you analyze and restructure your data. Dive into formula writing, combining formulas, creating basic to intermediate charts, and, of course, leveraging the ultra-powerful PivotTable in Microsoft Excel.
This 5-hour Excel 1-Day Fundamentals Workshop is the interactive and hands-on way to start learning to leverage your data. You will dive head first into Excel, skill up with exercises, and by the end of the day you'll know how to ask — and answer — the right questions of your data sets.
Takeaways
- Apply basic formula logic using absolute or relative references.
- Quickly pull necessary information out of large data sets.
- Execute advanced Excel functions, such as VLOOKUP and IF variants such as SUMIF and COUNTIF.
- Combine formulas to clean, edit, or analyze data sets with greater efficiency, compiling accurate spreadsheets.
- Build and modify PivotTables to quickly and effectively analyze large quantities of data.
- Create visualizations to clearly communicate insights.
Preparation
- This workshop is for beginners. No prior knowledge or experience required.
- Install Mircosoft Excel.
- You will need access to a laptop or computer with a working webcam and microphone as well as a strong internet connection.
- This class will occur completely online using Zoom.
- Class setup information will be emailed to all students signed up around 24 hours before (and again an hour before) your class launches.
- Each individual class participant must have purchased a ticket.
- NOTE: Some domains block our automated emails, so If you don’t receive sign-in instructions within 1 hour of the livestream, please reach out to help@generalassemb.ly and we’ll send sign-in instructions right away! This class will not be recorded, however, slides will be sent within 7 days following the session. If you have any questions please reach out to help@generalassemb.ly
About the Instructor
Senior Actuarial Analyst, Superannuation & Investment Platforms, National Australia Bank
Marcus Sheather-Burton is a Senior Actuarial Analyst at NAB with a passion for Excel, SQL and Tableau. Marcus started his career as an Actuary, but has since discovered his passion for data.
His journey has taken him to become the Data Analytics Strategy Co-ordinator at the Actuaries Institute Australia, as well as instructing many classes and workshops with General Assembly Sydney.
In his spare time, he enjoys volunteering as a Visitor Services Officer at the Sydney Opera House.
Refund Policy
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.
Community Code of Conduct
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.
