WSP 06 — Excel Tips and Tricks
Course Format: On-campus course
Duration: 2 days
Date(s): Feb 10—Feb 24
Time: 10:00 am—4:00 pm
Drop Deadline: Feb 3
Instructor(s): Maria Pribyl
Status: Registration opens on 12/04/2017
10:00 am—4:00 pm
Feb 10—Feb 24
Registration opens on 12/04/2017
Microsoft Excel has become the tool of choice for analyzing and reporting data, yet many users have never received any formal Excel training. This interactive, hands-on workshop will teach you sophisticated and time-saving techniques for accomplishing your Excel tasks more productively. On day one, you will learn how to navigate and select data more efficiently, color-code your data if cells meet a certain criterion (conditional formatting), ensure the integrity of your data upon entering information into your database (data validation), and quickly summarize a large database (PivotTables). On day two, you will learn how to work with the different behaviors of relative and absolute cell references when they are copied and filled to other cells (relative references change while absolute references remain constant), name a range of cells (named ranges), create a decision-making function to help analyze your data (“IF” statements), and ask Excel to look up information and return an answer based on your criteria (VLOOKUP). By the end of the workshop, you will have learned many tips, tricks, and techniques to improve your Excel productivity and accuracy.
Students are required to bring a fully charged laptop computer to class.
Note to Mac users: Although the workshop will be taught on the Windows platform, the techniques and handouts presented will be applicable to Excel for Mac as well.
Maria Pribyl, Founder and President, Snippet TrainingMaria Pribyl provides technology training for many universities and companies in the Bay Area, including Stanford, Santa Clara University, San Jose State, Adobe, Blue Coat Systems Inc., Cisco Systems, NVIDIA, Samsung, SanDisk, Symantec, Toyota, Yahoo, PayPal, and others.
Textbooks for this course:
There are no required textbooks; however, some fee-based online readings may be assigned.