Basic Data Analytics With Excel For Beginners

Section 1: Data Preparation

Lesson 1: Data & Corporate Strategy
– Current and emerging data analytics tools and technology trends
– The business need of Excel

Lesson 2: Introduction to Excel for Business
– Use the Excel Ribbon
– Select a Cell or Range of Cells, Data Entry Shortcuts
– Cut, Copy, and Paste Cell Values
– Save & Open Excel Workbooks

Lesson 3: Managing Rows & Columns in Excel
– Inserting, Moving & Deleting Cells, Rows, Columns
– Hide and Unhide Rows & Columns
– Column Width & Row Height

Lesson 4: Organize and Prepare Data
– Work with Worksheets
– Organize Worksheets using Insert, Delete & Rename
– Move & Copy, Hide & Unhide

Lesson 5: Formatting Cells in Excel
– Number and Date Formatting
– Finding and Replacing Text
– Use Spell Check

Section 2: Data Operations & Data Analysis

Lesson 6: Formulas & Functions
– Arithmetic Operators & Precedence
– Auto Fill
– Using Basic Excel Functions
– Relative & Absolute Referencing

Lesson 7: Introduction to Basic Data Analysis
– Create & Modify Tables
– Sort & Filter Data
– Summary Information for Reporting

Lesson 8: Large Workbooks & Reporting
– Manage Large Workbooks
– Printing Worksheets & Range
– Page Setup Options

Section 3: Data Visualization

Lesson 9: Visualize Data in Excel Charts
– Summarizing Data Visually
– Customizing Chart Data for Presentation
– Suitable Visualization Methods

Lesson 10: Evaluate Data Analysis Findings
– Use of Tables
– Reporting with Visualizations

Our main objective of this course is to teach our participants how to perform basic analytics with Microsoft Excel. They will be able to better understand customer activities and behaviour using Microsoft Excel for business.

Major Take Aways:

• Learn how to prepare data aligning to organization analytics strategy,
• Be able to perform basic data analytics operations independently and update data using Microsoft Excel,
• Create data visualizations and Present findings after evaluation using Excel.

Basic Computer Skills are required for this training.

You must know how to work on a laptop, how to use a mouse, and basic computer operations like opening & saving files.

This Foundational Course in Microsoft Excel for Data Analysis is targeted at Beginners to Excel, or people using Excel as merely a data entry tool.

The business focus of this Excel course brings alive the foundation of data analytics and data visualizations using Excel Tables, Charts, Functions, and Features that add value to any organization.

The course is best suited for people who have had little or no experience with Microsoft Excel. These are people who have used Excel a long time back or are using it only to do basic formulas or formatting or to tabulate simple reports.

The Basic Data Analytics With Excel for Beginners course is an excellent foundation for people, who, upon completing this course, would want to move on to more Advanced functions & features of Excel like Pivot Tables, VLOOKUP, SUMIF and Macros etc. (Covered in Advanced Data Analytics, & Data Visualization training courses).