Excel at Excel: Getting Down the Basics Remote Bootcamp (Online)
27

Thursday, 27 February

4 10 pm GMT

GA London (Online)

Online Class
Livestream
£190 GBP
Regular Ticket
£190 GBP
Total

Questions? Read our FAQs

Excel at Excel: Getting Down the Basics Remote Bootcamp (Online) | February 27

Celia Fryar Photo


Founder, Managing Partner, Data Divers, LLC

Craig Fryar Photo


Data Executive, Platform Architect and Technologist, Consultant

27

Thursday, 27 February

4 10 pm GMT

GA London (Online)

Online Class
Livestream
£190 GBP
Regular Ticket
£190 GBP
Total

Questions? Read our FAQs

About This Workshop

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example, Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential that can be achieved with Excel and touches briefly on everything from navigation and layout to using functions and charts. This workshop was not designed to go over any topic in extreme detail, but more as a "sampler" of topics. The expectation is for students to be able to leave and be familiar with several of the Excel skills necessary for most positions that require some "basic to intermediate" Excel knowledge. This course is excellent prep for General Assembly's Data Analytics Courses.

Agenda (Not necessarily taught in the order below):

  • Terminology and Navigation
  • Formatting and Filling
  • Data Organization and Filtering
  • Conditional Formatting
  • Hiding and Grouping
  • Introduction to Formulas
  • Functions
  • Basic Math Functions
  • Conditional Math Functions
  • Reference Functions
  • Basic Data Cleaning
  • Defined Names
  • PivotTables
  • Charts
  • Freezing Views
  • Adding Notes and Comment

Takeaways

  • Input, gather, prep, and format data for more productive use and sharing.
  • Analyze data to improve decision making.
  • Save or export data, tables, and charts for others to use or view

Preparation

Students should have a general familiarity with Excel including knowing how to navigate a spreadsheet and how to copy & paste. Please bring a laptop with Microsoft 2016 or 2019 installed (PC or Mac) but please note there may be minor differences between Microsoft's implementation on the two platforms. It is also highly recommended that you have a mouse. A second monitor or tablet is not required but highly recommended.

Students will be emailed case study files prior to class that they should download to their desktop. This is an interactive class, and your participation and questions are encouraged.

This class will occur completely online so students should also have a laptop or computer with at least 4GB RAM and a working microphone and camera. Class pre-work will be distributed via email which will include detailed instructions for downloading Zoom and Slack (where the class will be hosted). An internet connection of at least 10 Mpbs download speed is also highly recommeded.

About the Instructors

Celia Fryar Photo

Founder, Managing Partner,
Data Divers, LLC

Celia is a data nerd who loves to translate data into business insights, drawing from over 17 years in systems engineering, data communications and data analytics. She's provided technical instruction for corporate and government users, administrators and OEM resellers. She has developed curriculum and taught courses in analytics, SQL, networking and communications and contributed to network engineering certification training. She has managed, mentored and trained technical systems engineers, software developers, and application support specialists. Celia currently serves as Chair of the GA Analytics Product Advisory Board and is a Distinguished Faculty Member. Equipping professionals with market ready skills is her passion and commitment. When not elbow deep in data or in the classroom, she likes to scuba dive or travel to new places!

Craig Fryar Photo

Data Executive, Platform Architect and Technologist,
Consultant

Craig is a data-driven product design and development executive. He is an experienced Chief Data Officer, and previously served as Global Director of Enterprise Strategy at Tableau.

As a BI platform architect, he defined and deployed 2 global-scale data analytics tech stacks and teams. He is a thought-leader in DX, specializing in data transformation road-maps, process, privacy and secure access. His EDW platform design at Wargaming.net collected 300+ billion daily data events that fueled analysis for product design, development, monetization, marketing, competitive intel and executive strategy.

Craig served in data and technology executive positions at a Fortune 500 company, a $1B multi-national and at numerous startups. He is an experienced investor, securing over $30M in early stage funding for data virtualization, virtual reality, AI, gaming, simulations and biotechnology. He currently serves as COO and EVP Data for a FinTech platform that simplifies and accelerates Startup funding. He is a Partner at Data Divers, LLC.

While a Technology Evangelist for database and applications software at Apple, he co-authored the first-ever 3D, online multiplayer, VR video-game called “Spectre”.

Craig lives in Austin with his wife and data-geeky family. He is an advanced PADI diver, golfer, author, eschatologist, instructor and industry speaker, and is widely traveled. He is also a Distinguished Faculty Member at General Assembly.

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.

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.