fullscreen background
Skip to main content

Fall Quarter

Fall Quarter Underway
Late-Start Classes
Still Available
shopping cart icon0

Courses

« Back to Professional & Personal Development

WSP 06 — Excel Tips and Tricks

Quarter: Fall
Day(s): Saturdays
Course Format: On campus
Duration: 2 days
Date(s): Nov 5—Nov 12
Time: 10:00 am—4:00 pm
Drop Deadline: Oct 29
Unit(s): 1 Units
Tuition: $280
Limit: 20
Status: Open
Fall
On campus
Saturdays
10:00 am—4:00 pm
Date(s)
Nov 5—Nov 12
2 days
Drop By
Oct 29
1 Units
Fees
$280
Limit
20
Open
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 how to quickly summarize a large database (pivot tables). On day two, you will learn how Relative and Absolute Cell References behave differently when copied and filled to other cells (Relative References change; 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 must have a working knowledge of Excel and the ability to navigate around a spreadsheet. Students are required to bring a 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 the Mac platform as well.

Maria Pribyl, Founder and President, Snippet Training

Maria Pribyl provides technology training for many universities and companies in the Bay Area, including Stanford, Santa Clara University, San Jose State, Adobe, Blue Coat, Cisco, NVIDIA, Samsung, SanDisk, Symantec, Toyota, Yahoo, PayPal, and others.

Textbooks for this course:

No required textbooks
DOWNLOAD THE PRELIMINARY SYLLABUS » (subject to change)