Back to All Events

Beginner/Intermediate Microsoft Excel


Screen Shot 2017-09-21 at 8.36.22 PM.png

This is an introductory hands-on nine-hour course where the participants will learn the basic operations of Microsoft Excel.

This course will show how to use various functions of Excel to create tables to increase the productivity. It will also show how to unlock the potential of their data, by using formulas across a grid of cells.

Data is inserted into individual cells in rows or columns, allowing it to be sorted and filtered, and then displayed in a visual presentation. Using pie charts, graphs and clustered columns

adds meaning to data, which otherwise may just exist as row after row of numbers. Participants will also learn how to use conditional formatting to emphasise the most important part of the data.

Using conditional formatting, the users will be able to display icons which represent related data, highlight a row based on a single value, compare values. The users will learn about statistical functions such as MIN, MAX, SUM, SUMIFS, AVERAGE, MODE, COUNT, COUNTA, and MEDIAN. Logical functions such as IF, IFS, AND OR, FALSE, and TRUE will be demonstrated.

Date or dates of event -- -Fridays, 10/20/17-11/3/17

Start Time- - -8:30 AM - 11:30 AM

Street Address - - -630 W 19th Street

City - - -Merced

For more information call:(209) 384-6224

See our website at - - -mercedcommunityservices.com

Earlier Event: October 19
Merced Business Startup Workshop
Later Event: October 21
UC Merced Homecoming