Microsoft Excel : Beginner, Intermediate and Advanced Training Course

Looking for an Excel course to improve your skills and save you time?

Become a versatile Microsoft Excel Expert with our Excel course.

SGL ‘s Basic, Intermediate and Advanced Excel training can quickly get you up to speed with Microsoft Excel, taking you from complete novice to Microsoft Excel Expert level.

 By the end of the course, you will be equipped with the real-world Microsoft Excel knowledge you need to accomplish your data analysis daily tasks with ease.

 Versions Covered: This course covers 2010, 2013 and 2016 versions

• Course Outline

• Microsoft Office Excel: Beginner (Proficiency Level)

• Course Objectives:

• This Microsoft Excel Level 1 training organized by SGL technologies will introduce you to the features and power of Microsoft Excel, giving you a solid footing in a professional course that you will find very useful in your career and in your daily activities.

• Course Content

• Lesson 1: Getting Started with Excel

• Topic 1A: Identify the Elements of the Excel Interface

• Topic 1B: Navigate and Select Cells in Worksheets

• Topic 1C: Customize the Excel Interface

• Topic 1D: Create a Basic Worksheet

• Lesson 2: Performing Calculations in an Excel Worksheet

• Topic 2A: Create Formulas in a Worksheet

• Topic 2B: Insert Functions in a Worksheet

• Topic 2C: Reuse Formulas

• Lesson 3: Modifying an Excel Worksheet

• Topic 3A: Edit Worksheet Data

• Topic 3B: Find and Replace Data

• Topic 3C: Manipulate Worksheet Elements

• Lesson 4: Modifying the Appearance of a Worksheet

• Topic 4A: Apply Font Properties

• Topic 4B: Add Borders and Colors to Cells

• Topic 4C: Align Content in a Cell

• Topic 4D: Apply Number Formatting

• Topic 4E: Apply Cell Styles

• Lesson 5: Managing an Excel Workbook

• Topic 5A: Manage Worksheets

• Topic 5B: View Worksheets and Workbooks

• Lesson 6: Printing Excel Workbooks

• Topic 6A: Define the Page Layout

• Topic 6B: Print a Workbook

• Microsoft Office Excel : Intermediate (Specialist Level)

• Course Objectives:

• The Intermediate level will expand your knowledge of Microsoft excel greatly. Microsoft Excel level 2 has many capabilities, and there are lots to learn, which many professionals who thought they knew much about Excel are not even aware of. 

Course Content

• Lesson 1: Calculating Data with Advanced Formulas

• Topic 1A: Apply Cell and Range Names

• Topic 1B: Calculate Data Across Worksheets

• Topic 1C: Use Specialized Functions

• Topic 1D: Analyze Data with Logical and Lookup Functions

• Lesson 2: Organizing Worksheet and Table Data

• Topic 2A: Create and Modify Tables

• Topic 2B: Format Tables

• Topic 2C: Sort or Filter Data

• Topic 2D: Use Functions to Calculate Data

• Lesson 3: Presenting Data Using Charts

• Topic 3A: Create a Chart

• Topic 3B: Modify Charts

• Topic 3C: Format Charts

• Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts

• Topic 4A: Create a PivotTable Report

• Topic 4B: Filter Data Using Slicers

• Topic 4C: Analyze Data Using PivotCharts

• Lesson 5: Inserting Graphic Objects

• Topic 5A: Insert and Modify Pictures and ClipArt

• Topic 5B: Draw and Modify Shapes

• Topic 5C: Illustrate Workflow Using SmartArt Graphics

• Topic 5D: Layer and Group Graphic Objects

• Lesson 6: Customizing and Enhancing the Excel Environment

• Topic 6A: Customize the Excel Environment

• Topic 6B: Customize Workbooks

• Topic 6C: Manage Themes

• Topic 6D: Create and Use Templates

• Microsoft Office Excel : Advanced (Expert Level )

• Course Objectives:

• The Microsoft Excel Advanced level course will extend your basic and intermediate knowledge of Excel, and develop more skills and knowledge that you need to produce worksheets as you require them. 

Course Content

Lesson 1: Streamlining Workflow

• Topic 1A: Update Workbook Properties

• Topic 1B: Create a Macro

• Topic 1C: Edit a Macro

• Topic 1D: Apply Conditional Formatting

• Topic 1E: Add Data Validation Criteria

Lesson 2: Collaborating with Other Users

• Topic 2A: Protect Files

• Topic 2B: Share a Workbook

• Topic 2C: Set Revision Tracking

• Topic 2D: Review Tracked Revisions

• Topic 2E: Merge Workbooks

• Topic 2F: Administer Digital Signatures

• Topic 2G: Restrict Document Access

Lesson 3: Auditing Worksheets

• Topic 3A: Trace Cells

• Topic 3B: Troubleshoot Invalid Data and Formula Errors

• Topic 3C: Watch and Evaluate Formulas

• Topic 3D: Create a Data List Outline

Lesson 4: Analyzing Data

• Topic 4A: Create a Trendline

• Topic 4B: Create Sparklines

• Topic 4C: Create Scenarios

• Topic 4D: Perform a What-If Analysis

• Topic 4E: Perform a Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks

• Topic 5A: Create a Workspace

• Topic 5B: Consolidate Data

• Topic 5C: Link Cells in Different Workbooks

• Topic 5D: Edit Links

Lesson 6: Importing and Exporting Data

• Topic 6A: Export Excel Data

• Topic 6B: Import a Delimited Text File

• Topic 6C: Import and Export XML Data

Lesson 7: Integrating Excel Data with the Web

• Topic 7A: Publish a Worksheet to the Web

• Topic 7B: Import Data from the Web

• Topic 7C: Create a Web Query

Why SGL?

Over Twenty Five ( 25) Qualified , Highly Experienced , Certified  and Accredited  Trainers