Excel at Excel: Getting Down the Basics (Downtown LA)
David Bickham
Data Analytics Manager,
Fandango
About This Class
The Excel at Excel workshop is designed for participants who are relatively familiar with other office productivity software, for example Microsoft Word. (The participants 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 participants 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 participants 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 this order) - Terminology and Navigation - Filtering, Sorting, Formatting - Removing Duplicates - Hiding and Grouping Data - Conditional Formatting - Introduction to Formulas - Basic Math Functions - PivotTables - Charts and Graphs
The best parking structure to use is at 350 E. 2nd Street. It is directly next door (to the right) of our building. The cost is $2.00/15 min ($10 max), $5.00 flat rate after 4pm.
Gold line stop in Little Tokyo is a 5 minute walk to campus. Red line stop at Grand Park and Civic Center is about 10-15 minute walk.
Takeaways
- Accelerate the internalization of key time-saving shortcuts for navigation and editing.
- Work smarter and take advantage of the most helpful functions and features
- Enhance the presentation of your data by adding charts and formatting
Preparation
Participants 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 Excel installed (PC recommended, Mac acceptable). Most functions/features also work on a Mac although there may be minor differences. The instructor will be using a PC. It is also recommended that you bring a mouse. This is an interactive class, and your participation and questions are encouraged.
About the Instructor
David Bickham
Data Analytics Manager,
Fandango
David is a proven analytics leader within the Media/Entertainment space. Currently at Fandango, he supports various departments by providing analytical solutions and actionable insights that drive business decision making. His previous roles include working as an analyst for Warner Bros. Entertainment Group and a leading digital marketing agency, where he enabled digital marketing teams to improve their CRM and email marketing programs through data-driven segmentation and customer focused analyses. His specialties include manipulating and extracting data for analysis via SQL, visualizing data using Tableau, and statistical analysis in R. He holds a BA in Economics from the University of California, Riverside and an MBA with a focus in Decision Sciences & Marketing from the Graziadio School of Business & Management at Pepperdine University.
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.
