# Excel – Microsoft Excel Course Beginner to Expert 2024

Last Verified on September 12th, 2024

Course Name : Excel – Microsoft Excel Course Beginner to Expert 2024
Short description : 48,885
Duration : 3.5 hrs
Avg Rating : 4.3
Original Price : \$119.99
Discouont Price : 100%OFF
Instructor / Provider : Udemy
Course Type : Self Paced Online Course. Lifetime Access

## What you’ll learn

• Excel only for beginners
• How to properly use Excel
• Make your work faster, better and more efficient
• Creating Charts from your data
• Most Frequently Used Excel Functions With Examples
• How to land your first job as an Excel Expert
• Improve your Microsoft Excel Skills
Discount Price : 89%OFF       Rating : 4.6
Duration: : 22.5 hrs
Instructor / Provider :

This Course includes:

Started Fast

• How to get Started with Excel
• Create and open Workbook
• Create New Worksheets
• Tabs and Ribbon

Save Data

• Save Workbook in your PC

Errors Functions

• #VALUE!, #DIV/0!, #NAME?, #N/A
• #REF!, ###, #NULL!, #NUM!
Discount Price : \$9.99       Rating : 4.6
Duration: : 15 hrs
Instructor / Provider :

Logical Function

• AND() Functions
• OR() Functions
• NOT() Functions
• XOR() Functions
• SWITCH() Functions
• CELL() Functions
• ROW() Functions

Conditional Functions

• IF() Functions
• IFS() Functions
• Nesting IF() Functions
• Use IF function to calculate letter grades in Excel
• Use IFS function to calculate letter grades in Excel

Filter Function

• How to use Filter Function in Excel

DATE Function

• DATE() Function
• DATEIF() Function
• EDATE Function
• EOMONTH Function
• TODAY and NOW Function

Mathematical Function

• Count Function
• Round Function
• Sum Function
• Average Function
• Subtotal Function
• How to generate Subtotal With Grandtotal
• Power Function
• Mod Function
• INT & TRUNC Function
• MIN() and MAX() Function

Text Function

• Find, Search and Replace
• LEN Function
• MID Function
• REPT Function
• SPLIT Function
• TRIM Function
• Show gridlines

LOOKUP Functions

• INDEX Function
• MATCH Function
• EXACT Function
• VLOOKUP APPROXIMATE MATCH Function
• VLOOKUP Function
• HLOOKUP Function
• XLOOKUP Function

Convert Function

• How to convert number  to word

Drop Down List

• Dynamic dropdown List
• Dependent dropdown List

Charts & Graphs

• How to Create Charts & Graphs

Pivot Tables

• How to Use Pivot Tables

Sorting and Filtering

• Sort Function
• Filter Function

Flash Fill

• Merge and Separate data using flash fill

Panes

• Freeze panes
• Split panes

Multiple worksheets and workbooks

• Rename and Color Worksheets
• Hide and Unhide Worksheets
• Move and Copy Worksheets
• Worksheet Groups

Share and Collaborate

• Protect Worksheet
• Protect Workbook
• Sharing Excel Workbook with Multiple Users

Page Size

• Page settings
• Page break view

Print

• Print selection
Discount Price : \$12.99       Rating : 4.7
Duration: : 8.5 hrs
Instructor / Provider :

## Who this course is for:

• Anyone can do to develop their career in Microsoft Excel.
• Create any application in Microsoft Excel for personal and organization purpose.

#### Are there any limitations to access Excel – Microsoft Excel Course Beginner to Expert 2024 coupon Code?

Yes, coupon codes usually have an expiration date. Most of the Udemy discount coupon valid for the first 1000 enrollments or valid for 30 days, whichever comes first. After that Coupon will expires.

#### How to apply Udemy coupon codes?

Applying the Udemy coupon code is super simple. At end of this post, you will find the “ENROLL NOW” Button, Click on it You will be instantly redirected to a specific course to which the discount is applied and will be able to enjoy significant savings.

Excel – Microsoft Excel Course Beginner to Expert 2024 course includes a variety of resources, such as:
• Video lectures
• Coding exercises and quizzes