Microsoft Office Excel 2013 (Level 1-3)

COURSE OVERVIEW

Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Office Trainers in the industry to help us develop the ultimate training & certification program.

This is a comprehensive course covering all of the functions and features of Excel 2013 for students of any skill level. The course begins with basic concepts and gradually progresses to more advanced topics. Students will first learn about calculations, how to modify and format a worksheet, customizing the Excel environment and how to manage and print workbooks. They will also learn about creating formulas, inserting graphics and enhancing workbooks, how to organize worksheet data with tables and charts and how to analyze data using PivotTables, slicers and PivotCharts. Finally, students will learn about working with multiple worksheets, automating and auditing worksheets and how to export, analyze and present Excel data.

YOUR INSTRUCTOR

Debbie Fierst - Senior Technology Trainer

Debbie has been actively teaching all Microsoft Office versions and programs including Access, Excel, PowerPoint, Word, Outlook, Lync and Project for more than 5 years. As the owner and president of a technology consulting and development firm for 20+ years, she has mastered all of Microsoft Office’s products to conduct business efficiently and now with its web-based features finds it easier than ever to service clients worldwide. Debbie has created over 100 web sites utilizing many different web technologies, including but not limited to ColdFusion, ASP.Net, HTML, XML, and JavaScript. In terms of project management she has effectively provided strategies to the US Air Force, National Security Agency, as well as other corporate clients.

FEATURES

Main Menu
The organized and effective structure enables users to browse through hours of comprehensive content rapidly and with ease.

Resume
Every course resumes where you finished during the previous session in case you forget where you stopped.

Live Demonstrations
Instructors provide live and "hands on" demonstrations to explain and show users how to complete tasks. This enables users to witness professionals perform everyday tasks in real world settings as often as they like.

Topic A: Create a PivotTable
A Standard Table
A PivotTable
The PivotTable Field List Pane
The Summarize Values By Options
Summarizing Values by Using the MIN Function
The Show Values As Options
Showing Values As a Percent of the Grand Total
Combining Summarize and Show (Example 1)
Combining Summarize and Show (Example 2)
Demo 5-1: Creating PivotTables
Topic B: Filter Data by Using Slicers
Slicers and a PivotTable
Demo 5-2: Adding Slicers
Topic C: Analyze Data by Using PivotCharts
Slicers and a PivotChart
Demo 5-3: Creating a PivotChart
Lesson 05 Review

Lesson 06 - Inserting Graphics

Topic A: Insert and Modify Graphic Objects
The INSERT Tab’s Illustration Group
Types of Shapes
Demo 6-1: Inserting Pictures and Clip Art
Topic B: Layer and Group Graphic Objects
Layers
A Hidden Layer
The Same Layers in a New Stacking Order
Three Graphic Objects, No Grouping
Three Graphic Objects in One Group of Three
Demo 6-2: Inserting and Grouping Shapes
Topic C: Incorporate SmartArt
The Choose a SmartArt Graphic Dialog Box
Demo 6-3: Incorporating SmartArt
Lesson 06 Review