Advanced Excel: Beyond the Basics
18

Wednesday, 18 December

7 10 pm PST

GA Los Angeles (Santa Monica)

1520 2nd Street
Santa Monica, CA 90401
$65 USD
Regular Ticket
$65 USD
Total

Questions? Read our FAQs

Advanced Excel: Beyond the Basics | December 18

18

Wednesday, 18 December

7 10 pm PST

GA Los Angeles (Santa Monica)

1520 2nd Street
Santa Monica, CA 90401
$65 USD
Regular Ticket
$65 USD
Total

Questions? Read our FAQs

About This Class

In this class we will move beyond the basics of spreadsheet creation. Topics will include data manipulation/troubleshooting and advanced functions to summarize and analyze data having multiple attributes. We will also introduce Pivot Tables, advanced graphs, and macros. Class exercises will be utilized to facilitate understanding.

Takeaways

Students will learn how to effectively streamline and analyze data using some of the more advanced features of Excel.

Preparation

  • A basic understanding of the Excel spreadsheet layout and Pivot Tables

  • Common uses such as entering data into a blank spreadsheet and copying/pasting

  • An understanding of common functions such as SUM, IF, and VLOOKUP

  • Ability to create a graph from two or more sets of data points

Instructions for setting up the Developer tab for Macros:

    PC: File > Options > Customize Ribbon > check "Developer"
    Mac: Excel > Preferences > View > in Ribbon > check "Developer tab"

About the Instructor

Vahan Yoghourdjian Photo

Vahan completed his PhD in Computer Science at Monash University, in Australia, in 2018. His thesis is titled “All Diagrams Neat and Beautiful, All Networks Great and Small”, and introduces advanced and novel techniques for the visualization and analysis of data in a way that is scalable from small and relatively simple networks to very large and complex networks in fields such as Biology and the Social Sciences. The research involved algorithm engineering, optimization, user studies, user-centered design, and statistical analysis and modeling. Vahan has presented parts of his work at the premier international conference on Data Visualization (IEEE VIS) in Germany (2018) and Chicago (2015). In the course of this research, and in his Masters and Undergraduate studies, Vahan has mastered various Computer Science paradigms.
In addition to a rich education and research experience, Vahan also has experiences in teaching and developing software. As a lecturer, he has helped create material for data exploration and visualization units. He has taught design principles, methodologies, tools and languages (Python, R, JavaScript and Tableau); evaluated and provided feedback on assignments, presentations, and projects. As a Software Engineer, Vahan has managed development teams and projects, distributed and prioritized tasks, designed enhancements and new features, participated in requirements gathering, developed software, and prepared and presented training material.

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.