Current Status

Not Enrolled

Price

$30

Get Started

Course Description

This comprehensive Excel course is designed for beginners and intermediate users who want to build a solid foundation in spreadsheet management and data analysis. Covering everything from basic navigation to advanced functions like lookup formulas, pivot tables, and conditional formatting, this course will equip you with the skills needed to work efficiently with Excel in any professional setting.

What You will learn?

✅ Navigate the Excel interface and manage worksheets effectively.
✅ Enter, format, and manipulate data efficiently.
✅ Utilize tables, filters, and sorting tools for data organization.
✅ Apply conditional formatting to enhance data visualization.
✅ Perform logical and conditional calculations using built-in Excel functions.
✅ Master essential functions, including lookup, date, and text functions.
✅ Create visually appealing charts and graphs for data presentation.
✅ Build and customize pivot tables and pivot charts for in-depth data analysis

Who is this course for?

✔ Professionals seeking to improve Excel proficiency for workplace tasks
✔ Students and researchers working with data analysis
✔ Entrepreneurs managing financial and business data
✔ Anyone looking to enhance their Excel skills for career advancement

Course Content

Module 1: Getting Started in Excel
1.1 Introduction to Excel
1.2 Excel interface
1.3 Navigating the worksheet
Module 2: Worksheet Basics
2.1 Entering data into Excel
2.2 Adjusting column widths and row heights
2.3 inserting and deleting rows, columns and cells
2.4 copying, cutting and moving cells
2.5 Find and Replace
Module 3: Getting data into Excel
3.1 Cell referencing, Absolute and Relative
3.2 Named cells
3.3 Named ranges
Module 4: Working with tables
4.1 Create tables
4.2 Modifying tables
4.3 Sorting data in tables
4.4 Filtering data in tables
Module 5: Conditional Formatting
5.1 Introduction Conditional formatting Using
5.2 Using data bars,color scale and icon
5.3 Custom conditional formatting
5.4 Conditional formatting using formulas
Module 6: Conditional Calculations
6.1 SUMIF
1 of 3