Complete Excel Course

Course Details

Data Analytics

Created by

Admin

Last Update

September 12, 2023

Created On

July 03, 2023

Description

MS Excel is a powerful spreadsheet software by Microsoft used for organizing, analyzing, and manipulating data with functions, formulas, and tools.

Overview

Are you ready to unlock the full potential of Microsoft Excel and become a proficient spreadsheet user? **Our "Complete Excell" course** is your gateway to mastering one of the most indispensable tools in the business world. Whether you're a beginner looking to build a solid foundation or an experienced user seeking to enhance your skills, this course offers a **comprehensive journey through Excel's diverse capabilities**. Join us on this transformative journey to unlock the full potential of Microsoft Excel. **Elevate your skills, boost your productivity, and open doors to countless opportunities in academia and the professional world**. Whether you're aiming to enhance your resume or streamline your daily tasks, mastering Excel is a skill that will serve you well in any endeavor. Enroll today and embark on your path to becoming an Excel expert!

Features

Course Materials

Self-Paced Learning

Lifetime Dashboard Access

Completion Certificate

Comprehensive Curriculum

Modular Learning

Hands-on Exercises

Quizzes and Assessments

Lifetime Access

What you'll learn

String functions on Excel

Mathematical functions on Excel

Logical & error functions on Excel

Excel formatting

Custom formatting

Conditional formatting

Charts in Excel

Data analysis using Excel

Pivot tables

Dash boarding in Excel

Prerequisites

Curriculum

31 modules

Module 1: Microsoft Office in Brief

Introduction to Microsoft Office Suite

Why Excel is Essential

How to Access Excel

Overview of Excel User Interface

Microsoft account creation

MS Office installation

Office Web version and Microsoft 365 free trial

Module 2: MS Excel Introduction and UI

Duration • 1 hour

Excel Workbook and Worksheets

Cells, Rows, and Columns

Ribbon and Quick Access Toolbar

Navigating and Customizing the UI

Module 3: Working on Rows and Columns

Inserting and Deleting Rows/Columns

Resizing Rows and Columns

Hide/Unhide Rows and Columns

Cell Formatting

Module 4: Editing and Customizing Data

Duration • 1 hour

Data Entry and Editing

Cut, Copy, Paste

Fill Handle and Auto Fill

Format Painter

Module 5: Paste Special

Paste Special Options

Values, Formulas, Formats

Transpose and Operations

Module 6: Working on Worksheets

Duration • 1 hour

Adding, Renaming, and Deleting Worksheets

Moving and Copying Worksheets

Grouping Worksheets

Worksheet Tab Options

Module 7: Basic Formulas and Functions

Duration • 1 hour

Understanding Formulas and Functions

Arithmetic Operators

Creating Simple Formulas

AutoSum and Functions Library

Module 8: Find, Select, Replace, Go To

Duration • 1 hour

Find and Replace Data

Selecting Cells, Rows, and Columns

Using Go To

Module 9: Filling, Copying, and Cell Referencing

Fill Series

Copying Data

Absolute and Relative Cell Referencing

Mixed Cell Referencing

Module 10: Subtotal

Duration • 1 hour

Subtotal Function

Grouping Data

Outline and Subtotal Options

Module 11: Text Functions

CONCATENATE and TEXTJOIN

LEFT, RIGHT, MID Functions

TEXT Function for Date Formatting

UPPER, LOWER, PROPER Functions

Module 12: Logical or Comparative Operators

Duration • 1 hour

Understanding Logical Operators IF, AND, OR Functions Nested IF Statements

Module 13: Text Operations

Duration • 1 hour

LEN, TRIM, CLEAN Functions

SUBSTITUTE, REPLACE Functions

FIND and SEARCH Functions

Module 14: Database Functions

Introduction to Database Functions

SUMIF, COUNTIF, AVERAGEIF

SUMIFS, COUNTIFS, AVERAGEIFS

Module 15: Logical Functions

Duration • 1 hour

IF Function Revisited

IFERROR, IFNA, IS Functions

Logical Functions in Decision Making

Module 16: Speak Cells, Show Formulas

Duration • 1 hour

Excel's Text-to-Speech

Displaying Formulas

Formula Auditing Tools

Module 17: Basic Unconditional Formatting in Excel

Duration • 1 hour

Conditional Formatting Basics

Highlight Cells Rules

Data Bars, Color Scales, Icon Sets

Module 18: Protection in Excel

Workbook and Worksheet Protection

Password Protection

Protecting Cells, Rows, and Columns

Module 19: Formula Auditing

Duration • 1 hour

Trace Precedents and Dependents

Evaluate Formula

Watch Window

Module 20: Naming, Sorting, and Filtering

Named Ranges

Sorting Data

AutoFilter and Advanced Filter

Custom Sorting

Module 21: Tables in Excel

Duration • 1 hour

Creating Excel Tables

Table Features and Options

Structured References

Module 22: Printing

Page Setup

Print Preview

Printing Options

Headers and Footers

Module 23: Data Validation and Dropdown

Duration • 1 hour

Data Validation Rules

Creating Dropdown Lists

Input and Error Messages

Module 24: Index, Match

Duration • 1 hour

INDEX Function MATCH Function Combining INDEX and MATCH

Module 25: LOOKUP in Excel

Duration • 1 hour

VLOOKUP Function

HLOOKUP Function

Using Approximate Match

Module 26: Conditional Formatting

Duration • 1 hour

Advanced Conditional Formatting

Custom Rules and Formulas

Managing Conditional Formatting Rules

Module 27: Date and Time Functions

Duration • 1 hour

Date Functions

Time Functions

Combining Date and Time

Module 28: Pivot Tables in Excel

Duration • 1 hour

Creating Pivot Tables

Modifying Pivot Tables

Pivot Charts

Slicers and Timelines

Module 29: Charts in Excel

Duration • 1 hour

Creating Charts

Chart Types

Chart Elements and Formatting

Chart Templates

Module 30: Excel Power Query

Duration • 1 hour

Introduction to Power Query

Importing Data

Transforming Data

Query Editor

Module 31: Excel Dashboarding

Duration • 1 hour

Building Excel Dashboards Interactive Controls (Form Controls) Data Visualization Techniques Dashboard Best Practices

Instructors

Admin

Skoliko Faculty

Sign in

Sign up

Course Details