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!
 

 
Take your data management to the next level! This course is for the intermediate and advanced database user. This course will show you how to utilize the full power of Microsoft Access 2013. In this 3-day practical and project-oriented workshop series, you will learn how to use Microsoft Access 2013 to create and customize tables. You will have the opportunity to make your database more user-friendly with smart lists and other sophisticated controls. Learn how to start automating routine tasks with labor-saving macros. You will aslo receive tips and techniques for optimizing your database, including ways to build crosstab and summarize queries so you can access information quickly and easily as well as outer table joins that can make your queries more effective, and reports using conditional formatting to highlight key data points, and explore Visual Basic, a powerful programming language that allows you to automate simple and complex tasks. Finally, you will put the finishing touches on your database as you build a navigation form to make it easy for your users to find what they need. 

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 »
Take your data management to the next level! This course is for the intermediate and advanced database user. This course will show you how to utilize the full power of Microsoft Access 2013. In this 3-day practical and project-oriented workshop series, you will learn how to use Microsoft Access 2013 to create and customize tables. You will have the opportunity to make your database more user-friendly with smart lists and other sophisticated controls. Learn how to start automating routine tasks with labor-saving macros. You will aslo receive tips and techniques for optimizing your database, including ways to build crosstab and summarize queries so you can access information quickly and easily as well as outer table joins that can make your queries more effective, and reports using conditional formatting to highlight key data points, and explore Visual Basic, a powerful programming language that allows you to automate simple and complex tasks. Finally, you will put the finishing touches on your database as you build a navigation form to make it easy for your users to find what they need. 

9870001

Start date: 12/01/17

End date: 12/15/17

Instructor : Ahmad Ahmadi 

3 sessions.

Weekly - Fri 1:30 PM - 4:30 PM (12/1/2017-12/15/2017)

Cost: $145.00

Materials Cost: $0.00

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

Room :  A110



View Details »
In this hands-on workshop series, you'll learn how to create informative, eye-catching charts and graphs, and master charting, PivotTables, and other advanced features of Microsoft Excel 2013. Harness the power of Excel's data analysis tools and AutoFilter commands, and see how easy it is to create macros that eliminate repetitve tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire. In addition, you'll master the art of conditional formatting to highlight duplicate entries, become adept at importing external data using Excel's built-in Power Query tool, learn how to use Excel's consolidation function to efficiently summarize data from multiple sources and so much more.

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'll learn how to create informative, eye-catching charts and graphs, and master charting, PivotTables, and other advanced features of Microsoft Excel 2013. Harness the power of Excel's data analysis tools and AutoFilter commands, and see how easy it is to create macros that eliminate repetitve tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire. In addition, you'll master the art of conditional formatting to highlight duplicate entries, become adept at importing external data using Excel's built-in Power Query tool, learn how to use Excel's consolidation function to efficiently summarize data from multiple sources and so much more.

9870001

Start date: 10/20/17

End date: 11/03/17

Instructor : Ahmad Ahmadi 

3 sessions.

Weekly - Fri 1:30 PM - 4:30 PM (10/20/2017-11/3/2017)

Cost: $145.00

Materials Cost: $0.00

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

Room :  A110



View Details »
Go beyond the basics of desktop publishing with Microsoft Word 2013. In this course, you'll learn how to automate Word 2013 to help you write more while typing less. You'll also learn different ways to format text; how to add graphics to create signs, newsletters, or greeting cards; and how to generate documents with indexes and tables of contents.  You'll go through tips on automating Word using macros, shortcut keys, and templates so you can create even the most complex formatted documents quickly and easily. You'll also learn how to create and organize text in tables, add graphics to a document, mix graphics and text together, and merge spreadsheet and data to create mailing labels and form letters.  Along the way, we'll go through lots of short examples and hands-on exercises so you can see how Word's advanced features work - but more importantly, you'll see how you can use these advance features for your projects. By the end of this course, you'll know how to use Word more effectively and take advantage of all its features so you can get your work done more quickly and easily than you thought possible. 

9870001

Start date: 09/15/17

End date: 09/22/17

Instructor : Ahmad Ahmadi 

2 sessions.

Weekly - Fri 8:30 AM - 11:30 AM (9/15/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 »
Go beyond the basics of desktop publishing with Microsoft Word 2013. In this course, you'll learn how to automate Word 2013 to help you write more while typing less. You'll also learn different ways to format text; how to add graphics to create signs, newsletters, or greeting cards; and how to generate documents with indexes and tables of contents.  You'll go through tips on automating Word using macros, shortcut keys, and templates so you can create even the most complex formatted documents quickly and easily. You'll also learn how to create and organize text in tables, add graphics to a document, mix graphics and text together, and merge spreadsheet and data to create mailing labels and form letters.  Along the way, we'll go through lots of short examples and hands-on exercises so you can see how Word's advanced features work - but more importantly, you'll see how you can use these advance features for your projects. By the end of this course, you'll know how to use Word more effectively and take advantage of all its features so you can get your work done more quickly and easily than you thought possible. 

9870001

Start date: 09/15/17

End date: 09/22/17

Instructor : Ahmad Ahmadi 

2 sessions.

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

Cost: $145.00

Materials Cost: $0.00

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

Room :  A110



View Details »