Professional Certificates >> Microsoft Programs
« back to courses page

Classes offered to provide students with information about a variety of Microsoft programs.

If an offering appears full, there MAY STILL BE SPACE!  Call (209) 384-6224 to check!
 

 
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 exists as row after row of numbers. Participants will also learn how to use conditional formatting to emphasis 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.

9870001

Start date: 10/20/17

End date: 11/03/17

Instructor : Ahmad Ahmadi 

3 sessions.

Weekly - Fri 8:30 AM - 11:30 AM (10/20/2017-11/3/2017)

Cost: $145.00

Materials Cost: $0.00

Location : Merced College Business Resource Center Location : 
  Merced College Business Resource Center.

Room :  #216



View Details »
In this hands-on workshop series, you will learn how to create informative data representation using advanced functions of Excel such as VLOOKUP, INDEX, and MATCH. Financial functions such as PMT, FV, and NPV are explored. Text manipulation functions such as FIND, SEARCH, MID, LEFT, RIGHT, PROPER, TRIM, and RIGHT are explained. The use and advantage of Excel’s “Pivot Table: will be discussed and practiced in details. The locking, and unlocking of the whole or part of the spreadsheet will be demonstrated. The users will also learn how to create and use Macros to become efficient in using data.

9870001

Start date: 12/01/17

End date: 12/15/17

Instructor : Ahmad Ahmadi 

3 sessions.

Weekly - Fri 8:30 AM - 11:30 AM (12/1/2017-12/15/2017)

Cost: $145.00

Materials Cost: $0.00

Location : Merced College Business Resource Center Location : 
  Merced College Business Resource Center.

Room :  #216



View Details »
In this hands-on nine hour introductory workshop series you will learn about Microsoft Office products (Word, Excel, Access, and PowerPoint). In word, you will learn different ways to format text, add graphics, create signs. In Excel, you will learn the basic creation of a table and how to calculate various mathematical operations. Access will show you how to design a simple database and produce simple forms and reports. Using PowerPoint will allow you to create an eye-catching presentation incorporating music and video. Upon successful completion of this course, you will be very comfortable to take other individual intermediate and advanced courses in Excel and Access.

9870001

Start date: 09/08/17

End date: 09/22/17

Instructor : Ahmad Ahmadi 

3 sessions.

Weekly - Fri 8:30 AM - 11:30 AM (9/8/2017-9/22/2017)

Cost: $145.00

Materials Cost: $0.00

Location : Merced College Business Resource Center Location : 
  Merced College Business Resource Center.

Room :  #216



View Details »
In this hands-on nine hour introductory workshop series you will learn about Microsoft Office products (Word, Excel, Access, and PowerPoint). In word, you will learn different ways to format text, add graphics, create signs. In Excel, you will learn the basic creation of a table and how to calculate various mathematical operations. Access will show you how to design a simple database and produce simple forms and reports. Using PowerPoint will allow you to create an eye-catching presentation incorporating music and video. Upon successful completion of this course, you will be very comfortable to take other individual intermediate and advanced courses in Excel and Access.

9870001

Start date: 09/08/17

End date: 09/22/17

Instructor : Ahmad Ahmadi 

3 sessions.

Weekly - Fri 1:30 PM - 4:30 PM (9/8/2017-9/22/2017)

Cost: $145.00

Materials Cost: $0.00

Location : Merced College Los Banos Campus Location : 
  Merced College Los Banos Campus.

Room :  A119



View Details »
 

You may also be interested in these classes