Basic Data Analytics with Excel for Beginners

Section 1: Data Preparation

Lesson 1: Data & Corporate Strategy: Introduction to Microsoft Excel

• Understanding Organization’s product and services
• Current and emerging data analytics tools and technology trends
• The need for Microsoft Excel

Lesson 2: Introduction to Excel for Business

• Getting Started with Excel
• Using the Ribbon as the Excel User Interface
• Navigating within the Worksheet
• Selecting a Cell or Range of Cells
• Entering Data
• Cutting, Copying, and Pasting Cell Values
• Copy and Paste Special
• Saving & Opening your Workbook

Lesson 3: Managing Rows & Columns in Excel

• Inserting, Moving & Deleting Cells
• Managing Columns and Rows
• Hide and Unhide Rows & Columns
• Changing Column Width & Row Height

Lesson 4: Organize and Prepare Data

• Format Worksheet Tabs
• Insert and Delete Worksheet
• Move and Copy Worksheet
• Hide & Unhide Worksheet

Lesson 5: Formatting Cells in Excel

• Formatting the Cell
• Number and Date Formatting
• Finding and Replacing Text
• Spell Check

Section 2: Data Operations & Data Analysis in Excel

Lesson 6: Formulas & Functions of Microsoft Excel

• Excel Arithmetic Operators & Order of Operations
• Using Auto Fill Options
• Using Basic Functions
• Writing simple & practical Formulas on your own
• Absolute Referencing

Lesson 7: Basic Data Analysis With Tables, Sorting, Filtering, Summary Information

• Create and Modify Tables
• Sorting and Filtering Data in a Table
• Getting Summary Information in a Table
• Formatting a Table For Reporting

Lesson 8: Large Workbooks & Reporting

• Managing Large Workbooks
• Printing Worksheets
• Setting Page Setup Options
• Setting Page Breaks

***Section 3: Data Visualization***

Lesson 9: Creating Charts For Data Visualization

• Summarizing Data Visually Using Charts
• Customizing Chart Data
• Format Chart Legend and Titles
• Change the Chart Body
• Creating a Pie Chart
• Using Chart Titles & Placing Charts

Lesson 10: Evaluate Data Analysis Findings

• Tables
• Visualizations
• Reports

Objectives WSQ Course for Beginners in Excel in Singapore:

Upon completion of the Basic Excel for Beginners course, you will be able to perform basic analytics with Excel. You will be able to understand better customer activities and behavior using Excel for business. Effective visualization techniques with charts enhance the data understanding and make it easier to report the data analytics findings.

Improve your productivity and efficiency with the new time saving features in Excel 2019.

A very Practical, Hands – on approach to learning Excel – by doing exercises, and learning simple tips and tricks in the class.

The class is taught by Certified, Experienced Microsoft Trainers with years of experience in using Microsoft Excel.

Learn Microsoft Excel tips & techniques that will make your work faster, efficient, and you will be able to do complex tasks in a matter of minutes.

Pre-Requisites For Basic-Intermediate Excel Training

Basic knowledge of computers, using the keyboard, mouse and Windows is required.

This is a beginner-level program, so we will teach you all about getting started with Excel, and then how to get the most out of it for day-to-day use at your office or home.

All you need is basic PC skills to make the most of this Basic Data Analytics course with Excel Training Course.

Please Note that: 

1. Participants must sit & pass the short assessment at the end of the training to be eligible for the WSQ grant.
2. At least 75% of attendance is required by SSG to be eligible for the WSQ funding.
3. Participants will receive a WSQ certificate of Attainment upon successful completion of training and assessment.

Target Audience For Basic Excel Training 2019 / Microsoft Office 365

This program is highly recommended for those who want to understand the basic concepts of spreadsheets and want to demonstrate the ability to expertly use Microsoft Excel for keying in, manipulating, analysing, visualizing and reporting data easily.

Be prepared to do a lot of Hands-On Exercises on Excel to learn the new concepts and shortcuts, tips & techniques of Microsoft Excel. This is what makes this Excel Training program unique and beneficial for you.