Excel 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