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