Excel at Excel: Getting Down the Basics Remote Bootcamp

Placeholder

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!

Connor Fryar Photo

Instructional Associate ,
General Assembly

Music performer, collaborator and educator. Data investigator and analytical thinker. Lover of art, music and the sea!

With the goal of equipping colleagues with new tools and techniques, Connor leads Excel workshops and bootcamp (on campus and online) for beginner through advanced concepts. As a data investigator, he has served as an Instructional Associate for Data Analytics classes and SQL Bootcamps. He brings experience from a variety of programming environments, from robotics to Python. He is always in pursuit of the “why behind the what” and in search of effective ways to communicate insights!

Connor has deep appreciation and respect for orchestral, chamber and jazz music. Having studied saxophone, woodwind studies and piano for 15 years, he has a strong and diverse music background. He began his professional life training middle school and high school students with woodwind pursuits. Three time performer at Chicago’s Annual Midwest Clinic, twice at the prestigious TMEA conference and grand champion of the 2015 Houston Underground, Connor has stories to share about life as a music performer.

 

Refund Policy
Plans change. We get it. But if you can't make it to a class/workshop, please email us at least 7 days before the scheduled event date. No refunds will be given after this time frame.

General Assembly

General Assembly is a pioneer in education and career transformation, specializing in today’s most in-demand skills. The leading source for training, staffing, and career transitions, we foster a flourishing community of professionals pursuing careers they love.

What began as a co-working space in 2011 has since grown into a global learning experience with campuses in 15 cities and over 25,000 graduates worldwide.

As individuals and companies struggle to compete in an increasingly technological economy, General Assembly provides award-winning, dynamic training to close the global skills gap.

More classes from General Assembly

Class Fee: $250

  Mar 30, 2020 - Mar 30, 2020
Days/Times:
Class Type: Online
Location
General Assembly
Seattle Tower Third Floor, 1218 3rd Ave
Seattle, WA 98101

Why Register on Connect2Classes

  • Lowest Price Guarantee
  • Satisfaction Guarantee
  • Cancellation Guarantee

Reviews of General Assembly

(3 Reviews)
Cody B.
I went to GA Seattle WDI (Web Development Immersive) course. It changed my life. Within 1 1/2 months of graduation, I was offered a great job at a company that's considered one of the top 5 to work for in the pacific NW. Starting next week I'll be a Software Engineer making more than twice what I made in my previous career, and I enjoy the work much more. I can't heap enough praise onto the General Assembly Web Development program. Like I said, it's changed my life in ways I didn't think possible.
Daren Y.
GA WDI has been a great decision, not only was I able to learn such an extensive knowledge of multiple languages and frameworks to build web apps, but also being a part of an awesome ever growing family. I would highly recommend GA WDI to anyone.
Samantha B.
I loved taking the FEWD class with General Assembly. My teachers were the head developers at Nordstrom and such cool guys! In just a 10 weeks I learned how to code HTML, CSS, and intermediate JavaScript. I wish we had spent more time with GitHub but apparently all future classes are using it for every homework assignment so that's good to hear. I would recommend GA to anyone serious about learning a difficult 21st century skill like web development or user experience or digital marketing. I got so much more out of it than I feel I would have with any online course.