Microsoft Excel : Beginner, Intermediate and Advanced Training

Become a versatile Microsoft Excel Expert with our Excel course.

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

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

This intensive hands-on training course has been designed to provide delegates with a solid understanding from basic to advanced Excel 2007, 2010, 2013 or 2016 tools and concepts in order to increase their knowledge and productivity.

The Instructor led Microsoft Excel is made up of Beginner (Proficiency Level), Intermediate (Specialist Level) and Advanced Levels (Master Level).

It is designed to provide participants with a core understanding of how to effectively operate and use the Excel spreadsheet software.

Whether you need to learn the skills for work, want to fill the gaps in your CV or understand how to carry out data analysis, this Excel training course is perfect to do so.

 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.

SGL Technologies will take you through all you need to know as a beginner. If you have been working with other spreadsheet programs, but you are yet to lay your hands upon Microsoft Excel, if you have been assigned a new role in your place of work, or if you suddenly discovered that you will need Excel knowledge in your career, you are the one this training has been packaged for.

Microsoft Excel: Beginner, Intermediate and Advanced Levels in Lagos

Program Type: C, G

(I=Individual, C=Corporate, G= Government) -

Training Method: Instructor Led Classroom/Demonstration

Duration: 5 Days

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. This is one among the professional courses that has direct relevance to almost all careers, and a training that you can actually receive in a day.

You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.

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 5: 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 )

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. This training will expose you fully to the advanced level of Microsoft Excel, giving you the features and concepts that you will find to be relevant and beneficial to your career.

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.

This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data

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) Highly Experienced And Certified Consultants / Trainers
• Best Rated Training Company On Dealdey
• Interactive Learning Experience
• Optimized Training Budget
• Content Customization Training Solutions.
• Both Classroom And On-Site Training Options
• Capacity To Deliver Training At Various Locations Across The Country
• On-site training is also available to meet the need of our clients. On-site training outside Lagos attracts additional logistics charges.