UAH PD Solutions - Microsoft Office and Quickbooks

PROFESSIONAL CERTIFICATES AND SHORT COURSES:

MICROSOFT OFFICE QUICKBOOKS

ove Impr lace kp Wor ctivity! u Prod

MICROSOFT TRAINING Today’s professional workforce is expected to possess intermediate to expert-level skills in most Microsoft products.

UAH PD Solutions Training Advantage: • Expert instructors ensure accurate, comprehensive, and up-to-date training • Hands-on courses taught in state-of-the-art computer labs • Participants are provided home access to classroom training computer environment for skills practice

MICROSOFT EXCEL SHORT COURSES NEW

Introduction to Excel

In this introduction, learn the basics of Excel including spreadsheet terminology, basic functions and features, how to use the Help system, and how to navigate worksheets and workbooks. In hands-on labs create, edit, format, and manage text, values, and formulas. This course is geared toward participants who have little to no familiarity with Excel.

7 hrs, $265 Feb 7, 2020 | F | 8:30 am – 4:30 pm Aug 14, 2020 | F | 8:30 am – 4:30 pm

Excel: Formulas and Functions

Excel: Introduction to PivotTables and PivotCharts

Formulas and functions are useful in all types of spreadsheet applications.

Manipulate data and obtain useful information from your Excel workbooks.

Learn to create formulas, import, export and validate data, plus more. Prerequisite: Intermediate level Excel users familiar with general concepts of Excel features.

Become more valuable by discovering the power of PivotTables and PivotCharts. Learn to use data sets that work with PivotTables.

Organize and summarize data, format reports and data, and create PivotCharts to visualize pivoted data. Prerequisite: Intermediate level Excel users familiar with general concepts of Excel features.

7 hrs, $265 Mar 6, 2020 | F | 8:30 am – 4:30 pm Sep 18, 2020 | F | 8:30 am – 4:30 pm

7 hrs, $265 Apr 17, 2020 | F | 8:30 am – 4:30 pm Oct 23, 2020 | F | 8:30 am – 4:30 pm

NEW

THE VALUE OF TRAINING NEW

NEW

IN ACTION

Powerful Presentations Using PowerPoint

Delivering effective and powerful presentations is critical to success whether you are presenting a new initiative or asking a manager for budget resources. Learn PowerPoint tips that make an impact to influence your audience. This course will provide examples of what makes the best PowerPoint presentations utilizing layout, themes, graphics, objects, builds, slide transitions, and more. Knowing your audience and delivery techniques will also be explored. Practice building easy-to-create powerful, engaging, professional, and custom presentations that ensure an attentive audience. Prerequisite: Experience with PCs and Windows.

7 hrs, $265 | Call 256.824.4430

CPCS.uah.edu/Microsoft | 256.824.4430

Visit CPCS.uah.edu/Microsoft for dates.

SHORT COURSES Access Essentials

PowerPoint Essentials

Learn Access basics of planning, creating, and manipulating databases using tables.

Master data entry rules and properties using them to your advantage. Prerequisite: Experience with PCs and Windows.

Create basic PowerPoint presentations, and gain hands-on experience in formatting text, adding and modifying graphical objects, and adding charts and tables. Prerequisite: Experience with PCs and Windows.

7 hrs, $265 Feb 3 – 10, 2020 | M, W | 5:30 – 7:50 pm Jun 23, 2020 | T | 8:30 am – 4:30 pm Nov 3 – 10, 2020 | T, Th | 5:30 – 7:50 pm

7 hrs, $265 Feb 21, 2020 | F | 8:30 am – 4:30 pm

Using SharePoint Effective communication is vital to successful organizations. SharePoint combines the latest technology, functionality of applications, and the web into a single environment to share information and collaborate. Learn how to create, edit, and manage content on your team’s site. Prerequisite: Experience with PCs and Windows.

14 hrs, $425 | Call 256.824.4430

MICROSOFT PROJECT CERTIFICATE

SAVE $50 by taking the 2-course certificate or take just 1 course.

Using Project

Project Power User

Learn to effectively manage your projects by building a solid foundation in Project. Set up MS Project to facilitate efficiency and ease of use. Utilize entered data to create a valid and dynamic model of the project. This course is tailored for project managers and planners. Prerequisite: Experience with PCs and Windows.

Learn how to maximize your ability to manage tasks and projects. Practice handling delays and conflicts, consolidating project files, and sharing resources. Execute, monitor, and control tasks so that your project is completed on time, within budget, and according to scope. Prerequisite: Using MS Project or six months’ experience using MS Project.

12 hrs, $395 Jan 28 – 29, 2020 | T, W | 8:30 am – 3:30 pm Jul 28 – 29, 2020 | T, W | 8:30 am – 3:30 pm

MICROSOFT WORD CUSTOMIZED EXPERT-LED COURSES Grow Your Team’s Level of Expertise to that of a Microsoft Word Power User! From learning to create, edit, and enhance standard business documents to creating complex documents, our hands-on courses equip users with skills to increase productivity.

12 hrs, $395 Oct 27 – 28, 2020 | T, W | 8:30 am – 3:30 pm

Ways to Register ONLINE: CPCS.uah.edu/PDSolutions PHONE: 256.824.6010 or 800.448.4031, 8:15 am – 5 pm (CST), M – F IN PERSON: UAH College of Professional & Continuing Studies, Wilson Hall 103, Huntsville, AL 35899-0650 WE ACCEPT: MasterCard, Visa, AMEX, Discover, POs, & SF-182s For policies, course info, and instructor bios, visit CPCS.uah.edu

Phone 256.824.2815 or email PDSolutions@uah.edu.

CPCS.uah.edu/Microsoft | 256.824.4430

Visit CPCS.uah.edu/QuickBooks for dates.

QUICKBOOKS SHORT COURSES QuickBooks Foundation Create a fully functioning business financial management system with ease! Track finances, manage payroll, process invoices, manage sales and expenses, and maximize the software’s features. Learn proven techniques and time-saving shortcuts. Prerequisite: Basic computer skills and knowledge of accounting terms.

7 hrs, $265 Mar 10, 2020 | T | 8:30 am – 4:30 pm Oct 20, 2020 | T | 8:30 am – 4:30 pm

QuickBooks for Government Contractors Utilize QuickBooks to be in compliance with DCAA accounting requirements. Structure the chart of accounts in cost pool format to properly segregate direct costs from indirect costs, as well as exclude the unallowable costs outlined in FAR 31. Set up payroll items, projects, and timecards to use in conjunction with the Customer module for job costing. Explore various DCAA audits such as the Incurred Cost Submission, Floor Check and Pre-Award Audit. Prerequisite: QuickBooks Foundation or basic knowledge of QuickBooks and Government contracting.

7 hrs, $265 May 5, 2020 | T | 8:30 am – 4:30 pm Nov 17, 2020 | T | 8:30 am – 4:30 pm

TRAIN YOUR TEAM AND SAVE MONEY! CUSTOMIZED TRAINING IS AVAILABLE T HE R IG HT CO UR S E T HE R IG H T T I ME T HE R IG HT L O CAT I O N Customized training from UAH PD Solutions is the perfect solution to train a group or launch an organization-wide training program.

It is affordable, adaptable to your needs, and hassle-free. Volume discounts are available.

See immediate and measurable organization results!

Call 256.824.2815.

CPCS.uah.edu/Microsoft | 256.824.4430

Microsoft Office and QuickBooks Corporate Training Bundles are a cost-effective and stress-free approach to meet your organizational training needs.

What are the benefits?

• Cost Savings – Save money off regular course rates.

• Employee Development – Invest in sharpening your employees’ skill set and see the increase in your teams knowledge, loyalty, and productivity.

• Quality and Comfort – Provide quality instructional content and instructors in a comfortable hands-on learning environment that meets your learning goals.

• Flexibility – Select the courses your workforce needs, when they need them.

For details, contact PDSolutions@uah.edu or 256.824.4430.

TEAM TRAINING DISCOUNTS 5 Participants

10 Participants

15 Participants

20+ Participants

SAVE 5%

SAVE 10%

SAVE 15%

SAVE 20%

NOTE: Courses with customized locations and/or content may not apply.