Microsoft Excel Complete Course | All in one MS Excel Course

4.8 /5

(10 Ratings)

Offered byUDEMY

Microsoft Excel Complete Course | All in one MS Excel Course
at
UDEMY
Overview

Excel the Microsoft Excel Skills By joining the Complete MS Excel Training Course

Duration	6 hours
Total fee	₹1,920
Mode of learning	Online
Credential	Certificate

Microsoft Excel Complete Course | All in one MS Excel Course

Table of contents

Overview
Highlights
Course Details
Curriculum
Faculty
+ 1 more item

Microsoft Excel Complete Course | All in one MS Excel Course
at
UDEMY
Highlights

Earn a Certificate of completion from Udemy
Get a 30 days money back guarantee on the course
Get full lifetime access of the course material
Learn from 14 downloadable resources

Microsoft Excel Complete Course | All in one MS Excel Course
at
UDEMY
Course details

Skills you will learn

Excel Conditional Formatting Data analysis Advanced Excel Data Entry

Who should do this course?

For engineers, auditors, data scientists, data analysts, data entry operators, students or teachers, etc.

What are the course deliverables?

Learn Microsoft Excel from Basics to Expert Level
Learn How to Analyze the Data
Learn the Formatting & Conditional Formatting
Learn the Mathematical Functions
Learn the Logical Functions

More about this course

Microsoft Excel is the basic & must-learn skill in today's world for almost everyone
It is being used in almost every business, every corporation, and institution for data entry, data analysis, data presentation, data consolidation, or data calculation Microsoft Excel is a very user-friendly, easy-to-use & interactive software that will give the desired results accurately & within no time
This course is designed by keeping in mind the beginner or entry-level approach but if student already has some knowledge about MS excel or worked before in Excel then they can skip those basic level lectures

Microsoft Excel Complete Course | All in one MS Excel Course
at
UDEMY
Curriculum

Introduction

Math & Auto Sum Functions

AutoSum Functions

Sum IF Function & Remove Duplicates Option

Sum IF & Sum IFs, Count IF & Count IFs Functions

Sub Total Function

Arrays & Sum Product Functions

Other Mathematical Functions

Cell Name & Cell References

Cell or Range Name

Absolute & Relative References

Home Tab

Formatting in Excel

Excel Data Types

Roaming in Excel

Go to & Replace Options

Auto Fill Options

Copy, Paste & Paste Special Options

Conditional Formatting

Sort & Filter Options

Operator, Equations & Excel Errors

Operators in Excel

Equation Writing in Excel

Errors in Excel Sheet

Logical Functions

Logical Function IF

Logical Function IF Error

Logical Function (IF, Nested IF, OR)

Logical Function AND

Microsoft Excel Complete Course | All in one MS Excel Course
at
UDEMY
Faculty details

Usama Hassan

Usama Hassan did hisgraduation from Mehran UET Jamshoro Pakistan. He has 1.5 years of working experience as 'Site Engineer Mechanical' in the steel mill sector. I has a very keen interest in software learning & giving his services for software. He has planned to make & share the multiple courses for the udemy audience.