Office Productivity using Microsoft Office Products
Microsoft Office 2019 Excel: Level 1 (IDAY 251)
Topics include: getting started, entering and editing data, creating formulas and basic functions, modifying a worksheet, formatting, printing and managing workbooks.
Microsoft Office 2019 Excel: Level 2 (IDAY 253)
Topics include: working with functions, working with lists, creating and modifying tables, conditional formatting, visualizing data with charts and using PivotTables and Pivot Charts
Microsoft Office 2019 Excel: Level 3 (IDAY 255)
Topics include: working with multiple worksheets and workbooks, using lookup functions and formula auditing, sharing and protecting workbooks, applying data validation, introducing bookmarks, creating sparklines and mapping data, creating data tables, using scenarios and goal seek and forecasting data trends.
Microsoft Excel with PivotTables (IDAY 250)
Take your reports from ordinary to extraordinary in this hands-on class to learn how to create PivotTables. Excel PivotTables are a great way to summarize, analyze, explore and present your data. PivotTables let you easily view
data from different angles. You will learn to reorganize and summarize selected rows and columns from a spreadsheet or database table to generate the report you want—without changing the spreadsheet or database itself. You must complete Microsoft Office Excel: Level 2 (IDAY 253) before attending.
Microsoft Excel Data Analysis with Power Pivot (IDAY 249)
Gain an edge when it comes to reporting data. With Power Pivot, you can mash up large volumes of data from various sources, analyze information rapidly and share insights easily. You’ll learn how to create relationships between diverse data sources, create calculated columns and formulas, build Pivot Tables and Pivot Charts and more. You must complete Microsoft Office Excel: Level 2 (IDAY 253) and Microsoft Excel with PivotTables
(IDAY 250) before attending.
Microsoft Office Access 2019: Level 1 (IDAY 1242)
In this class, you’ll gain an understanding of relational databases and the skills to create a new database, construct data tables, design forms and reports and run queries in Microsoft Access. You’ll learn how to navigate within the Access application environment, create a simple database and customize Access configuration options. Other topics will include organizing and managing data stored within Access tables; using queries to join, sort and filter data from different tables; using forms to view, access and input data; and creating and formatting custom reports.
Microsoft Office Access 2019: Level 2 (IDAY 1243)
In this class, you’ll expand your knowledge of relational database design and gain the skills to improve database efficiency, promote data integrity, and implement advanced features in tables, queries, forms and reports. You’ll also learn how to: provide input validation features to promote the entry of quality data into a database; organize a database for efficiency and performance while maintaining data integrity; improve the usability of Access tables creating advanced queries to join and summarize data; use advanced formatting and controls to improve form presentation; and use advanced formatting and calculated fields to improve reports.
Microsoft Office 2019 PowerPoint: Level 1 (IDAY 261)
Topics include: getting started with PowerPoint, developing a PowerPoint presentation, performing advanced text editing, adding graphic elements to your presentation, modifying objects in your presentation, adding tables and charts to your presentation and preparing to deliver your presentation.
Microsoft Office 2019 PowerPoint: Level 2 (IDAY 263)
Topics include: modifying the PowerPoint environment, customizing design templates, adding SmartArt and math equations to a presentation, working with media and animations, collaborating on a presentation, customizing a slide show and securing and distributing a presentation.
Microsoft Office 2019 Word: Level 1 (IDAY 271)
Topics include: getting started with Word, editing a document, formatting text and paragraphs, adding tables, managing lists, inserting graphic objects, controlling page appearance, proofing a document and preparing to publish a document.
Microsoft Office 2019 Word: Level 2 (IDAY 273)
Topics include: organizing tables and charts; customizing formats using styles and themes; inserting content using Quick Parts, controlling text flow, using templates and mail merge for letters, envelopes and labels.
Microsoft Office 2019 Word: Level 3 (IDAY 275)
Topics include: collaborating on documents, adding reference marks and notes, manipulating images, using custom graphic elements, simplifying and managing long documents, securing a document, forms and automating repetitive tasks with macros.
For more information or to register, call (815) 280-1555.
Return to Computers & Technology menu