Desktop Applications

Quick Links

 

Access 2013 Level 1

Review the basic functions and features of Access 2013 with Wanda Plawer. After an introduction to database concepts, the Access environment, and Help systems, you will learn how to design and create databases; work with tables, fields, and records; sort and filter data; set field properties and data entry rules; and create queries, forms, and reports.
Prerequisite: Windows XP/Vista/7 or equivalent knowledge.

Access 2013 Level 2

Discover how to normalize data, manage table relationships, and enforce referential integrity with Wanda Plawer. Work with Lookup fields and sub datasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.
Prerequisite: Microsoft Access 2013 Level 1 or equivalent knowledge.

 

 

Access 2013 Level 3

Wanda Plawer will help you perform queries with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties.
Prerequisite: Microsoft Access 2013 Level 2 or equivalent knowledge.

 

 

 


 

Excel 2013 Level 1

Excel Level 1 will familiarize you with spreadsheet terminology and the fundamental concepts of Microsoft Excel 2013, including identifying Excel window components, navigating worksheets, and downloading templates. In addition, you will learn the basics of entering and editing text, values, and formulas and saving workbooks in the native Excel format as well as in other formats. You will learn how to move and copy data and formulas; determine absolute and relative references; and work with ranges, rows, and columns. Learn how to use simple functions and easily apply formatting techniques to worksheet data. You will create and modify charts and work with graphics. Finally, you will review workbooks for spelling errors, modify page setup, and print worksheets. 

Prerequisite: Windows XP, Vista, 7, or equivalent knowledge.

 

 

Excel 2013 Level 2

Excel Level 2 will teach you how to work with large worksheets in Microsoft Excel 2013 and use multiple worksheets and workbooks efficiently. It will introduce you to more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. In addition, you will learn how to create outlines and subtotals and create and apply cell names. You will sort and filter data and create and format tables. Learn how to save workbooks as web pages, insert and edit hyperlinks, and share workbooks via email. Audit worksheets for errors, protect worksheets, share and merge workbooks, and track changes in a workbook. Finally, you will customize the Excel environment and create and modify custom templates. 

Prerequisite: Microsoft Excel 2013 Level 1 or equivalent knowledge.

 

 

Excel 2013 Level 3

In Excel Level 3, build on the skills you acquired in the Microsoft Excel 2013 Basic and Intermediate courses. You will work with advanced functions and formulas as well as search functions such as VLOOKUP, MATCH, and INDEX. In addition, learn about data validation and use advanced data filtering. You will apply advanced chart formatting options and create more complex charts. Work with PivotTables and PivotCharts, export and import data, and query external databases. You’ll learn about the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, you will run and record macros.

Prerequisite: Microsoft Excel 2013 Level 2 or equivalent knowledge.

 

 

Excel 2013: Dashboards

Presenting the right information to the right people visually in a way that enables actionable decision making is a major goal when working with data. In this fast-paced, hands-on two-hour workshop discover a variety of techniques that will help you create clear and concise information dashboards. Philip Nyman will help you explore data validation, forms and form controls, lookup functions, and conditional logic. You will be able to create and modify charts, use visual slicers, and create key performance indicators and sparklines. These techniques will help you display the current or historical status of your organization or service.
Prerequisites: Intermediate-level experience working with Excel 2013 tables and functions.

 

 

Excel 2013: PivotTables

Excel PivotTables and PivotCharts are powerful, interactive methods for organizing, summarizing, and analyzing data. In this fast-paced, hands-on two-hour workshop you will learn what a pivot table is and what it does with Philip Nyman. You will learn how to create and modify PivotTables; connect to external data sources; add cal- culated fields; and sort, group, and filter data using slicers. By the end of the ses- sion you will be able to create, format, and style PivotCharts (based on a PivotTable) that provide maximum understandability of your data.
Prerequisites: Intermediate experience with Excel 2013, including charting. No previous experience with PivotTables or PivotCharts is required.

 

 

 

 

 

Word 2013: Mail Merge

Already know a lot about Word but need to become more efficient at using mail merge or just need a refresher? Look no further! Learn from Ginna Moore how to set up form letters and labels with data sources such as Excel and Access. In addition, discover how to use Outlook to perform an email merge and explore the use of rules.
Prerequisite: Microsoft Word Level 1 or equivalent knowledge.

To register click here

 

 

© Parkland College
2400 West Bradley Ave | Champaign, IL 61821 | 217.351.2200 | 800.346.8089