Access Training

 

Excel Level 2

Access Level 1

In this course, you will create and manage an Access 2016 database.

You will:

  • Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.

  • Organize and manage data stored within Access tables.

  • Use queries to join, sort, and filter data from different tables.

  • Use forms to make it easier to view, access, and input data.

  • Create and format custom reports.

Access Level 2

In this course, you will create and manage an Access 2016 database.

You will:

  • Design a relational database.

  • Join tables to retrieve data from unrelated tables.

  • Validate data entered into a database.

  • Use advanced queries to manipulate your data.

  • Organize a database for efficiency and performance, and to maintain data integrity.

  • Customize reports to organize the displayed information and produce specific print layouts.

Access Level 3

In this course, you will learn to create and manage a fundamental Access 2016 database.

You will:

  • Customize a form layout to improve usability and efficiency of data entry.

  • Share data across applications.

  • Use macros to improve user interface design.

  • Use VBA to enhance tasks.

  • Organize data into appropriate tables to ensure data dependency and minimize redundancy.

  • Lock down and prepare a database for distribution to multiple users.

  • Create and modify a database switchboard and set the start-up options.

 

Excel Training

Excel Level 1

Upon successful completion of this course, students will be able to:

  • Get started with Microsoft Office Excel 2016

  • Perform calculations

  • Modify a worksheet

  • Format a worksheet

  • Print workbooks

  • Manage workbooks

Excel Level 2

Upon successful completion of this course, students will be able to:

  • Get started with Microsoft Office Excel 2016

  • Perform calculations

  • Modify a worksheet

  • Format a worksheet

  • Print workbooks

  • Manage workbooks

Upon successful completion of this course, students will be able to:

  • Get started with Microsoft Office Excel 2016

  • Perform calculations

  • Modify a worksheet

  • Format a worksheet

  • Print workbooks

  • Manage workbooks

Excel Level 3

Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

You will:

  • Work with multiple worksheets and workbooks

  • Use Lookup functions and formula auditing

  • Share and protect workbooks

  • Automate workbook functionality

  • Create sparklines and map data

  • Forecast data

Excel Pivot Tables

Upon successful completion of this course, you will be able to use Excel 2016 advanced PivotTable functionality to analyze your raw data.

You will:

  • Prepare data for PivotTable reporting and create PivotTables from various data sources

  • Analyze Data Using PivotTables

  • Work with PivotCharts

Outlook Training

 

Outlook Class

Do you use Outlook everyday? Are there days where you feel overwhelmed with the huge number of emails you receive and afraid that you will drop one of the balls you are juggling? Learn some time saving tips and tricks with our new Outlook Class.

 

This is a 2 hour class conveniently timed at the end of the work day (from 3-5 PM) and includes a handy resource card for you to take with you.

 

Highlights from the class include:

  • Tips and tricks for managing emails

  • Outlook Interface guide

  • Signatures – how to

  • Inline replies guidance

  • How to manage folders & favorites

  • Appointments & Calendars guide

  • Quicksteps help

  • An interactive Q&A portion.

PowerPoint Training

 

Powerpoint Level 1

Upon completing this course, you will be able to create and deliver engaging multimedia presentations that convey the key points of your message through the use of text, graphics, and animations.

You will:

  • Identify the basic features and functions of PowerPoint 2016

  • Develop a PowerPoint presentation

  • Perform advanced text editing operations

  • Add graphical elements to your presentation

  • Modify objects in your presentation

  • Add tables to your presentation

  • Add charts to your presentation

  • Prepare to deliver your presentation

Powerpoint Level 2

Upon completing this course, you will be able to customize the PowerPoint 2016 application, and effectively create, collaborate on, secure, and distribute complex multimedia presentations for a variety of situations.

You will:

  • Modify the PowerPoint environment

  • Customize design templates

  • Add SmartArt and math equations to a presentation

  • Work with media and animations

  • Collaborate on a presentation

  • Customize a slide show

  • Secure and distribute a presentation

Publisher

Publisher Class

What's new for Microsoft Publisher 2016?

Publisher 2016 lets you search for pictures in one place, whether they’re on your computer, in the Office.com clip art gallery, or on the web. Key features include:

  • Creating picture backgrounds and effects

  • Photo center printing

  • Swapping and adding pictures

  • Text effects

Microsoft Publisher Course Topics

  • Newest features of Publisher

  • Working with basic publications

  • Editing and formatting publications in Publisher

  • Working with pictures and graphics in Publisher

  • Preparing a publication for distribution

 

QuickBooks Training

Quickbooks Level 1

Upon successful completion of this course, students will be able to:

  • Set up a company

  • Work with lists

  • Set up inventory

  • Sell your product

  • Invoice for services

  • Process payments

  • Work with bank accounts

  • Enter and pay bills

  • Use the EasyStep Interview

QuickBooks Level 2

Upon successful completion of this course, students will be able to:

  • Memorize transactions

  • Customize forms

  • Use other QuickBooks accounts

  • Create reports

  • Create graphs

  • Track and pay sales tax

  • Prepare payroll with QuickBooks

  • Use online banking

  • Managing Company Files

  • Estimate, time track, and job cost

  • Write letters

 

Windows 10 Training

Windows 10 Class

Upon successful completion of this course, you will be able to perform basic tasks on a PC running the Windows 10 operating system.

  • Use Windows apps and desktop applications to complete day-to-day tasks, including installing new apps and multitasking with multiple programs

  • Work with files and folders by using File Explorer and OneDrive

  • Use Edge for web browsing

  • Customize the Windows 10 environment

  • Use Windows 10 security features to create more secure passwords and protect your device against common attacks

 

Word Training

Word Level 1

In this course, you will learn fundamental Word 2016 skills.

You will:

  • Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.

  • Format text and paragraphs.

  • Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.

  • Enhance lists by sorting, renumbering, and customizing list styles.

  • Create and format tables.

  • Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.

  • Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout.

  • Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility

Word Level 2

You will:

  • Organize content using tables and charts

  • Customize formats using styles and themes

  • Insert content using quick parts

  • Use templates to automate document formatting

  • Control the flow of a document

  • Simplify and manage long documents

  • Use mail merge to create letters, envelopes, and labels

Word Level 3

You will:

Use images in a document

  • Create custom graphic elements

  • Collaborate on documents

  • Add reference marks and notes

  • Secure a document

  • Create and manipulate forms

  • Create macros to automate tasks

Sign In       Contact       Knowledge Base       Careers        Privacy       Partners       Credit App

Untitled-1.jpg
twitter.jpg
linkedinicon.jpg
youtubeicon.jpg

© 2019 Mapletronics Computer Inc. | 2116 Wilden Ave. Goshen IN 46528