sales@dynamicsedge.com
202-410-6400
SKU: 100004 Categories: ,

Excel 2019 Level 2 - Intermediate. Versions 2013, 2016, 2019, Office 365, & Online are available.

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

Excel 2019 Level 2

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

 

Do not hesitate to Contact Us or Live Chat if you have questions or concerns about Excel 2019 Level 2 - Intermediate. 

Need help picking the right course?

Give us a call!
408-684-5250 or 
800-453-596 (Toll Free) 

Train Your Team

Save money and get your team trained. With a group of 5 or more people, you have special options. Click the button below to request a special quote for your team now!

Register Now

Price:

    Print

    Print this product
    202 S.E. Church Street, Suite 203 Leesburg, VA 20175
    https://www.dynamicsedge.com/
    sales@dynamicsedge.com
    Solutions
    Company
    202 Church Street S.E. , Suite 203 Leesburg, VA 20175
    202-410-6400
    800-453-596 (Toll Free)
    sales@dynamicsedge.com