Microsoft Excel Intermediate

Microsoft Excel Intermediate, available at $49.99, has an average rating of 4.55, with 59 lectures, based on 159 reviews, and has 2695 subscribers.

You will learn about Using Microsoft Excel above beginner's level This course is ideal for individuals who are Anyone who wants to learn Microsoft Excel Intermediate level It is particularly useful for Anyone who wants to learn Microsoft Excel Intermediate level.

Enroll now: Microsoft Excel Intermediate

Summary

Title: Microsoft Excel Intermediate

Price: $49.99

Average Rating: 4.55

Number of Lectures: 59

Number of Published Lectures: 59

Number of Curriculum Items: 59

Number of Published Curriculum Objects: 59

Original Price: $49.99

Quality Status: approved

Status: Live

What You Will Learn

Using Microsoft Excel above beginner's level

Who Should Attend

Anyone who wants to learn Microsoft Excel Intermediate level

Target Audiences

Anyone who wants to learn Microsoft Excel Intermediate level

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

Basic knowledge of Microsoft Excel is essential with the following pre-requisites:

Have attended Microsoft Excel – Foundation Level; OR
Able to switch between task applications
Able to create a spreadsheet with simple formatting
Able to create a basic chart
Able to print a spreadsheet with headers and footers added
Able to apply Freeze Pane command
Able to create basic formulas – Addition, Subtraction, Multiplication and Division
Able to use basic functions – AutoSum, Count, Max, Min and Average functions.

Upon completion of this program, participants should be able to:

Create simple to complex formulas and functions, like:
COUNTIF Function
AVERAGEIF Function
SUMIF Function
IF Function
VLOOKUP Function
Filter data using Auto Filters
Create Chart
Apply Conditional Formatting

Course Curriculum

Chapter 1: Cell Reference In Formula

Lecture 1: Relative Reference

Lecture 2: Absolute Reference

Lecture 3: Mixed Reference

Chapter 2: Formula Auditing

Lecture 1: Show Formulas

Lecture 2: Trace Precedents & Dependents

Chapter 3: Statistical Function

Lecture 1: Count A

Lecture 2: Count IF

Lecture 3: Count IFS

Lecture 4: Average A

Lecture 5: Average IF

Lecture 6: Average IFS

Chapter 4: Mathematical Function

Lecture 1: Sum IF

Lecture 2: Sum IFS

Chapter 5: Logical Function

Lecture 1: IF

Lecture 2: Nested IF

Lecture 3: IF Error

Chapter 6: Database Function

Lecture 1: DSum

Lecture 2: DCountA

Lecture 3: DAverage

Lecture 4: DMax

Lecture 5: DMin

Chapter 7: Working With Table

Lecture 1: Create Table

Lecture 2: Adding, Deleting Records

Lecture 3: Total Row

Lecture 4: Cleaning Duplicate Records

Chapter 8: Sorting Records

Lecture 1: Sort

Chapter 9: Filter

Lecture 1: Autofilter

Lecture 2: Text Filter

Lecture 3: Number Filter

Lecture 4: Date Filter

Lecture 5: Wildcard

Lecture 6: Advance Filter

Lecture 7: Top 10 Filter

Chapter 10: Data Validation

Lecture 1: List

Lecture 2: Numbers

Lecture 3: Date

Lecture 4: Text Length

Lecture 5: Custom

Chapter 11: Conditional Formatting

Lecture 1: Highlight Cell

Lecture 2: Data Bars

Lecture 3: Icon Set

Lecture 4: New Rule

Lecture 5: Edit

Lecture 6: Delete

Lecture 7: Clear

Chapter 12: Charts

Lecture 1: Create Combo Chart

Lecture 2: Chart Element

Lecture 3: Chart Style & Colour

Lecture 4: Chart Filter

Chapter 13: Sparkline

Lecture 1: Adding Sparkline

Lecture 2: Edit Sparkline

Chapter 14: Protect Data

Lecture 1: Protect Sheet

Lecture 2: Protect Workbook

Lecture 3: Edit Ranges

Lecture 4: Protect File

Chapter 15: Views

Lecture 1: Page Layout View

Lecture 2: Page Break Preview

Lecture 3: Custom View

Chapter 16: Managing Window

Lecture 1: Side By Side View

Instructors

Info Trek
Office Specialist Trainer

Rating Distribution

1 stars: 1 votes
2 stars: 1 votes
3 stars: 29 votes
4 stars: 70 votes
5 stars: 58 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu