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

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


To customize this class, call 800-453-5961 or click here to contact us

Excel 2019, Level 2 - Intermediate

Versions 2013, 2016, 2019, Office 365, & Online are also available.

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
  • Creating 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
  • Adding D Models
  • Formatting Drawing Objects
  • Inserting WordArt
  • Inserting SmartArt
  • Inserting 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 If Function
  • Using Nested Functions
  • Using the Ifs Function
  • Using the PMT Function
  • Using the FV Function
  • Using 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

We look forward to your success!!!

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!

Request Group Quote

Register


Price: $350   Duration: 1 day

- EST