Microsoft Excel: Master Spreadsheets & Data Analysis

Home
/ Courses
/ Microsoft Excel: Master Spreadsheets & Data Analysis

Microsoft Excel: Master Spreadsheets & Data Analysis

Categories: Data Skills

Wishlist

Course Content

1. Introduction

1.1. Getting Started with Microsoft Excel Free Basics Guide

00:00
1.2. Who Should Learn Excel and Why

00:00
1.3. What is Microsoft Excel, where to find it, and how to open and use it

00:00
1.4. Introduction to Microsoft Excel Interface

00:00

2. Understanding Basic Excel

3. Formulas in Excel

4. Charting in Excel

5. Advance Excel Formulas and Functions

6. Text Functions in Excel

Student Ratings & Reviews

No Review Yet

Your Instructor

marcusstreet79@gmail.com

EduFlexi empowers learners with flexible, practical IT courses — designed to build real skills for real-world success.

Quick Links

Contact Info

Want to receive push notifications for all major on-site activities?

✕

Microsoft Excel: Master Spreadsheets & Data Analysis

Course Content

1. Introduction

1.1. Getting Started with Microsoft Excel Free Basics Guide

1.2. Who Should Learn Excel and Why

1.3. What is Microsoft Excel, where to find it, and how to open and use it

1.4. Introduction to Microsoft Excel Interface

2. Understanding Basic Excel

2.1. How to customize ribbon in excel

2.2. How to Save and Open Microsoft excel file

2.3. Data entry in Microsoft excel

2.4. How to Use Quick Access Toolbar in excel

2.5. CELL formatting options in Excel

3. Formulas in Excel

3.1. Basic formulas and mathematical calculation in excel

3.2. Excel Cell References Absolute, Relative and Mixed Explained

3.3. How to use basic excel functions LIKE SUM,AVERAGE,MIN and MAX

3.4. Data Sorting in Excel

3.5. How to Filter Your data in excel

3.6. Data Validation in Excel

3.7. Advance Data Validation in Excel

3.8. How to create Dynamic Data Validation in Excel

4. Charting in Excel

4.1. How to insert chart in excel

4.2. Modifying the Data and Type of a Chart

4.3. How to change chart style in excel

4.4. Formatting Charts in Excel

5. Advance Excel Formulas and Functions

5.1. COUNTIF & COUNTIFS Function in Excel

5.2. SUMIF and SUMIFS function in Excel

5.3. AVERAGE function in Excel

5.4. SUBTOTAL function in excel

5.5. How to use IF and IFS in Excel

6. Text Functions in Excel

6.1. UPPER,LOWER and PROPER function in Excel

6.2. LEFT and RIGHT function in Excel

Student Ratings & Reviews

Your Instructor

marcusstreet79@gmail.com

Related Courses

Adobe Illustrator: Creative Design Tips & Workflow

Email Marketing Basics: Build & Launch Campaigns

Game Design in Unreal Engine 5: A Starter Guide

Quick Links

Categories

Contact Info