Learn Modern Excel for Data Analysis

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.

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 Modules

Module 1: Getting Started in Excel

• Introduction to Excel
• 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 Absolute referencing

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 to conditional formatting

5.2 Using built in conditional formatting

5.3 Custom conditional formatting

5.4 Conditional formatting using formulas

Module 6: Conditional Calculations

6.1 SUMIF

6.2 AVERAGEIF

6.3 Numeric criteria

6.4 Date criteria

6.5 COUNTIF

6.6 SUMIFS

6.7 AVERAGEIFS

6.8 COUNTIFS

6.9 MAXIFS AND MINIFS

Module 7: Logical Functions

7.1 IF

7.2 IF, AND

7.3 IF, OR

7.4 Nested IF

7.5 IFS

Module 8: Date Functions

8.1: Basics of dealing with dates in excel

8.2: NOW and TODAY

8.3: EDATE AND EOMONTH

8.4: DAYS

8.5: DATEDIF

8.6: NETWORKDAYS

Module 9: Text Functions

9.1: CONCATENATE

9.2: TRIM

9.3: LEFT

9.4: MID

9.5: RIGHT

Module 10: Lookup Functions

10.1: VLOOKUP

10.2: HLOOKUP

10.3: INDEX AND MATCH

10.4: XLOOKUP

Module 11: Charts

11.1: Creating for choosing a type of chart

11.2: Creating and customizing bar charts and column charts

11.3: Creating and customizing line charts

11.4: Creating and customizing pie charts

11.5: Creating and customizing combo charts

11.6: Creating and customizing sparkline

Module 12: Pivot tables and Pivot Charts

12.1: Introduction to pivot tables

12.2: Using automatic pivot tables

12.3: Creating pivot tables from scratch

12.4: Creating calculated fields in the pivot tables

12.5: Sorting and filtering pivot tables

12.6: Customizing pivot tables