Excel Level 2

Course: 9005

This Microsoft Excel 2019 / 2016 Level 2 course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate.

Download PDF
  • Duration: 1 days
  • Price: $350.00
Get This Course $350.00
12-Dec

9:00 AM – 4:00 PM CST

Scroll to view additional course dates

Reserve Your Seat

  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • You can use your Purchase Card and checkout
  • The GSA Contract Number: 47QTCA20D000D
  • Call 800-453-5961 for details
  • Customize your class
  • Delivery Onsite or Online for your organization
  • Choice of Dates when and where you want
  • Guidance in choosing and customizing your class

Question About this Course?

Excel 2019 Level 2 – Intermediate

Excel 2019 Level 2 – Intermediate. Versions 2013, 2016, 2019, Office 365, & Online are also available. This Microsoft Excel 2019 Level 2 course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel 2019 Level 2.

Course Outline

Lesson 1 – Working with Tables

  • Creating a Table
  • Enter Data into a Table
  • Deleting Rows and Columns
  • Formatting a Table
  • Totaling Data in a Table
  • Sorting Data in a Table
  • Sorting Multiple Columns
  • Filtering Data Using AutoFilter
  • Creating Custom Filters
  • Converting a Table to a Range

Lesson 2 – Working with Charts

  • Creating a Chart
  • Moving a Chart
  • Resizing a Chart
  • Changing the Layout and Style
  • Labeling Chart Elements
  • Formatting Chart Text
  • Formatting Chart Elements
  • Changing the Chart Type
  • Showing or Hiding Gridlines
  • Customizing Axes
  • Creating a Pie Chart
  • How to create a Map Chart
  • Creating a Funnel Chart
  • Changing a Chart’s Source Data
  • Moving a Chart to a Different Worksheet
  • Saving a Chart Template
  • Filtering Chart Data
  • Using Sparklines
  • Customizing Sparklines

Lesson 3 – Working with Graphics

  • Adding Pictures
  • Inserting Online Images
  • Adding Shapes
  • Adding Icons
  • How to Add D Models
  • Formatting Drawing Objects
  • Inserting WordArt
  • Inserting SmartArt
  • How to Insert an Organization Chart
  • Modifying an Organizational Chart
  • Taking a Screenshot
  • Using Drawing Tools
  • Drawing Simple Math Equations
  • Generating Complex Equations

Lesson 4 – Workgroup Collaboration

  • E-Mailing a Workbook
  • Web Page Preview
  • Converting Worksheets into Web Pages
  • Inserting Hyperlinks
  • Viewing and Editing Comments

Lesson 5 – Financial & Logical Functions Using the following

  • If Function
  • Nested Functions
  • Ifs Function
  • PMT Function
  • FV Function
  • AutoCalculate

Lesson 6 – Date and Time Functions

  • Understanding Date/Time Functions
  • Adding a Date and a Date Interval
  • Subtracting Dates
  • Calculating Time Intervals

Lesson 7 – Managing Workbooks

  • Creating a Workbook Using a Template
  • Creating a New Template
  • Editing a Template
  • Showing or Hiding Workbook Elements
  • Creating a Workspace
  • Comparing Two Workbooks Side by Side
  • Saving a Workbook in a Different File Format
  • Using Data Consolidation

Question About this Course?

Need help picking the right course?

Contact Us

Call Now

Call Now800-453-5961