Microsoft Excel for Beginners [Basic – Intermediate]

LM
lms_admin

About This Course

(Eligible for Skillsfuture Credit)

INTRODUCTION 

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
shutterstock_1746069590

$495.00

Level
Intermediate
Duration 16 hours
Lectures
1 lecture
Subject
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
Compare
Wishlist 0
Open wishlist page Continue shopping