Microsoft Excel for Beginners [Basic – Intermediate]


About This Course

(Eligible for Skillsfuture Credit)


Welcome to Laures
Academy’s Microsoft Excel beginner course! Developed and taught by
leading experts this course is designed to help you leverage intermediate-level
skills that can be applied to virtually every industry. As part of your
enrollment in the course, you will receive a certificate to signify your
newfound skills in Excel, including data organization, chart creation, data
visualization and more. 

Why Learn from US 

          Actionable insight to improve your aptitude within Excel

          Applicable information throughout every industry

          Lessons to improve your organization, decision-making, visualization, and     problem-  solving skills.

          Course certificate to boost your marketability

Day 1

 Managing Rows & Columns

Inserting, Moving & Deleting Cells

Managing Columns and Rows

Hide and Unhide Rows & Columns

Changing Column Width & Row Height


Managing Worksheets

Format Worksheet Tabs

Insert and Delete Worksheet

Move and Copy Worksheet

Hide & Unhide Worksheet


Formatting Cells

Formatting the Cell

Number and Date Formatting

Finding and Replacing Text 

Working with Styles



Advanced Formatting

·       Considerations in Designing a Spreadsheet

·       Working with Cell Styles & Document Themes

·       Apply, Create & Manage Conditional Formatting


·       Creating a Custom Number Format 


Working with Tables

·       Create a Table & Use of Total Row

·       Sorting & Filtering a Table

·       Formatting the Table 

Advanced Functions and Formulas

·       Formulas with Multiple Operators

·       Using and Managing Defined Names

·       Using Mixed Cell Referencing

·       Date and Time Functions

·       Using Logical Functions (IF, AND and OR), Sum, Sumif.

·       Using Lookup Functions

·       Mathematical and Statistical Functions

·       Using Financial, Text & Database Functions

·       Using 3D Reference within SUM Function 

Day 2

Validating Data and Auditing Worksheets

·       Using Data Validation

·       Auditing Tools

·       Displaying and Tracing Formulas

·       Understanding Formula Errors

Managing Charts 

·        Data Visually Using Charts

·       Customizing Chart Data

·       Format Chart Legend and Titles

·       Change the Chart Body

·       Saving the Chart as a Template

·       Creating a Pie Chart

·       Using Chart Titles & Placing Chart

Working with Data Ranges


·       Sorting by One Column

·       Sorting by Multiple Columns

·       Filtering Data

·       Using Advanced Filter

Working with PivotTables

·       Creating a PivotTable

·       Specifying PivotTable Data

·       Changing a PivotTable’s Calculation

·       Filtering and Sorting a PivotTable

·       Working with PivotTable Layout

·       Grouping PivotTable Items

·       Updating & Formatting a PivotTable

·       Creating a PivotChart

Linking and Importing Data

·       Inserting a Hyperlink

·       Linking Data & Managing External Links

·       Importing Data

·       Working with Existing Data Connections

Managing Collaborative Editing

·       Working with Comments to Cells

·       Tracking Changes

·       Protecting Worksheets & Worksheet Elements

·       Protecting a Workbook


Target Audience

  • Anyone looking to expand their basic knowledge of Excel
Advanced Data Analytics with Microsoft Excel Course


Duration 16 hours
1 lecture
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
  • Attributes
  • Custom attributes
  • Custom fields
Click outside to hide the compare bar
Wishlist 0
Open wishlist page Continue shopping