Excel at Excel: Getting Down to the Basics
18

Monday, 18 November

6 8 pm PST

GA Seattle

1218 Third Avenue, 3rd Floor
Seattle, WA 98101
$65 USD
Regular Ticket
$65 USD
Total

Questions? Read our FAQs

Excel at Excel: Getting Down to the Basics | November 18

Michael Valeri Photo


Sr. Analytics Consultant, Avenue In Consulting

18

Monday, 18 November

6 8 pm PST

GA Seattle

1218 Third Avenue, 3rd Floor
Seattle, WA 98101
$65 USD
Regular Ticket
$65 USD
Total

Questions? Read our FAQs

About This Class

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. It 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.

Agenda (Not necessarily taught in the order below):

  • Terminology and Navigation
  • Formatting
  • Data Organization
  • Conditional Formatting
  • Hiding and Grouping
  • Introduction to Formulas
  • Functions
  • Basic Math Functions
  • Conditional Math Functions
  • Reference Functions
  • Filling
  • Defined Name
  • PivotTables
  • Chart

Takeaways

  • Input, gather, massage, and format data for more productive use and sharing.
  • Analyze data to improve decision making.
  • Output and package data for external consumption.

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 Office 7 or 10 installed (PC recommended, Mac acceptable. Most functions/features should work on a Mac although there may be minor differences. The instructor will be using a PC. It is also highly recommended that you bring a mouse. Students will also 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.

About the Instructor

Michael Valeri Photo

Sr. Analytics Consultant,
Avenue In Consulting

Michael Valeri is a senior analytics professional with 7 years of experience mining, refining, and presenting big data across multiple Fortune 500 companies including Amazon, Microsoft, T-Mobile, GoDaddy, Expedia, and Big Fish Games. His areas of expertise include SQL, Tableau, Excel and PowerBi.

Valeri believes everyone has the "right" to understand how their data is being used, regardless of their technical aptitude, experience, age, or background.

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.