You're browsing Microsoft Training in Chicago, IL

Learn the principles of table relationships; advanced query techniques; an introduction to functions, macro actions, advanced form techniques including using macros in forms; database security, and advanced report techniques. Class Outline Unit 1: Implementing Advanced Form Design Topic A: Add Controls to Forms Topic B: Enhance navigation...

Learn to use Power BI Desktop Software to connect to, model and shape data. Learn to customize visuals, tooltips, create calculated messages and conditional columns.  Create interactive visualizations with Power BI with data hierarchies, filters, slicers, and dashboards. 1. Connecting to Data  Create Data Connections  Model Data...

PowerPoint is used to develop presentation materials. We’ll create text, charts and graphs to be used in electronic presentations or handouts. We’ll also work with slide masters and templates, create objects and use clip art. You will also learn how to apply transitions for electronic presentations.

In our Foundation Part II one-day class you will manage site collections and site components as a site collection administrator and as a site administrator. You must take our Foundation I class (or have used SharePoint Foundation for at least three months) before taking this class.

Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more! Class Outline: Lesson 1: Working with Functions Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date & Time Functions Topic E: Work...

Students will learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. They will also learn how to navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks. This course also covers simple functions used in formulas...

We will create templates and adjust background settings, create Word-Art, work with graphics, apply animation, hide slides, create handouts and notes. You will also learn how to apply enhanced formatting for your text. Class Outline: Lesson 1: Modifying the PowerPoint Environment Topic A: Customize the User Interface Topic B: Set PowerPoint...

This one-day class offers tips, tricks and timesavers that will help you get the most from Excel. It is an easy quick-paced class that will touch on most of the popular Excel features and how to access them efficiently. Target Student: You already know Excel and have been working with it regularly. Some of your skills are self-taught and you might...

In our Intermediate Word class students will work with styles, sections, and columns and will use the Navigation pane to work with outlines. They will format tables, print labels and envelopes, and work with SmartArt graphics and drawing tools. They will also use document templates, manage document revisions, and work with Web features. Course Outline...

Learn to perform mail merges. Create forms and master documents that include a table of contents; table of figures; footnotes; endnotes; and more. Create macros, customize the ribbon and Quick Access toolbar. Course Content Lesson 1: Manipulating Images Topic A: Integrate Pictures and Text Topic B: Adjust Image Appearance Topic C: Insert Other...

Your training and experience using Microsoft® Access® has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize...

Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics. Most job roles today involve some form of data management. In the case of data workers,...

After you master the basics of using Microsoft ® Word such as creating, editing, and saving documents, navigating through a document, and printing, you're ready to move on to tackling the more advanced features. These features enable you to create complex and professional documents with a consistent look and feel. They also enable you to automate...

MS Excel can never be displaced by any technology and every organization uses it in one way or the other. Enrolling in Sprintzeal's Advanced Excel training will ensure you have the basic skills to promptly and efficiently carry out day to day activities at work. Although technology has immensely evolved with various high-level programming languages,...

From the earliest eras of human existence, visual images have been used to represent knowledge, data, and information. Beginning with the Paleolithic cave paintings and continuing to today’s most complex computer networks, these images leverage the ability of the human brain to rapidly perceive patterns and trends from visual representations. In...