Microsoft Excel: Scenario based training. Basic to Advance.

Microsoft Excel: Scenario based training. Basic to Advance., available at $19.99, with 202 lectures, and has 3 subscribers.

You will learn about Build a solid understanding on the Basics of Microsoft Excel Microsoft Excel from Beginner to Advanced using real scenarios and downloadable working files Practice the use of dynamic functions like IF, VLOOKUP, HLOOKUP, PMT, INDEX, MATCH, SUBTOTALS and many more Create great looking reports using Pivot tables, Slicers and Sparklines Automate daily routine work using Macros Practice Excel Tips and Tricks to work more effective This course is ideal for individuals who are This Microsoft Excel course is for anyone who wants to work smart and more effective and productive using Excel or Take this course to make sure you do not miss out on advanced features you are not aware of It is particularly useful for This Microsoft Excel course is for anyone who wants to work smart and more effective and productive using Excel or Take this course to make sure you do not miss out on advanced features you are not aware of.

Enroll now: Microsoft Excel: Scenario based training. Basic to Advance.

Summary

Title: Microsoft Excel: Scenario based training. Basic to Advance.

Price: $19.99

Number of Lectures: 202

Number of Published Lectures: 202

Number of Curriculum Items: 202

Number of Published Curriculum Objects: 202

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Build a solid understanding on the Basics of Microsoft Excel
Microsoft Excel from Beginner to Advanced using real scenarios and downloadable working files
Practice the use of dynamic functions like IF, VLOOKUP, HLOOKUP, PMT, INDEX, MATCH, SUBTOTALS and many more
Create great looking reports using Pivot tables, Slicers and Sparklines
Automate daily routine work using Macros
Practice Excel Tips and Tricks to work more effective

Who Should Attend

This Microsoft Excel course is for anyone who wants to work smart and more effective and productive using Excel
Take this course to make sure you do not miss out on advanced features you are not aware of

Target Audiences

This Microsoft Excel course is for anyone who wants to work smart and more effective and productive using Excel
Take this course to make sure you do not miss out on advanced features you are not aware of

How does learning from someone who started Excel training in his company in 1995 sound?

Today you have this opportunity!

For over 26 years Wilkie has laid the foundation for thousands of people teaching Microsoft Excel.

In this course, he will share his knowledge with you.

He will lay the foundation starting with the Basic principles and then build towards the Advanced features. Whether you have never opened an Excel file ever before, you want to brush up on your skills and the newest features, or you are well versed in Excel and want to learn more advanced functions, this course has it all!

The course also includes valuable tips and tricks to work more effectively in Excel, and is designed from a basic to advanced level. We’ll discuss topics such as:

Entering and editing data
Autofill
formatting of cells
working with functions
sorting of data
past special
The What-if-analysis
One- and two data table
validations
conditional format
charts
subtotals
links
protection
Lookups
Pivot tables, and macros

The training is built on scenarios and you can practice what you have learned using downloadable Excel working files, and is for anyone who wants to work more effectively in Microsoft excel. Whether in a corporate or personal capacity, if you use excel regularly this course is for you!

Remember: You don’t know what you don’t know, so it is worth your time investing in this course.

See you online!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Quick access toolbar

Lecture 2: Menu Tabs

Lecture 3: Groups

Lecture 4: Ribbon Display Options

Lecture 5: Formula Bar

Lecture 6: Name Box

Lecture 7: Select All

Lecture 8: Scroll Bars

Lecture 9: Sheet Tabs and Control Buttons

Lecture 10: Status Bar

Lecture 11: Page Views

Lecture 12: Zoom

Chapter 2: Excel Options

Lecture 1: Number Of Sheets

Lecture 2: R1C1 Reference Style

Lecture 3: After Pressing Enter, Move Selection

Lecture 4: Formula Bar, Sheet Tabs, Row And Column Headers

Lecture 5: Dealing With Zero Values

Chapter 3: Mouse Pointer Shapes

Lecture 1: Mouse Pointer Shapes

Chapter 4: Mouse Selection Techniques

Lecture 1: Mouse Selection Technique 1

Lecture 2: Mouse Selection Technique 2

Chapter 5: Entering and Editing of Data

Lecture 1: Entering Data In a Cell

Lecture 2: Edit Using The Formula Bar

Lecture 3: Edit Cell Content Directly In a Cell

Lecture 4: Inserting a Note in a Cell

Lecture 5: Inserting a Comment in a Cell

Lecture 6: Delete Note and Comment

Chapter 6: Working With Sheets

Lecture 1: Rename a Sheet

Lecture 2: Hide and Unhide Sheets

Lecture 3: Deleting a Worksheet

Lecture 4: Selecting Different Sheets

Lecture 5: Copy a Sheet – Example 1

Lecture 6: Copy a Sheet – Example 2

Lecture 7: Copy a Sheet – Example 3

Chapter 7: Working with Rows and Columns

Lecture 1: Hide and Un-hide Rows

Lecture 2: Hiding and Un-Hiding of Columns

Lecture 3: Insert and Delete Columns

Lecture 4: Inserting and Delete Rows

Lecture 5: Resizing Columns

Lecture 6: Row Height

Chapter 8: Copy and Paste & Moving and Insertion of Text

Lecture 1: Copy and Paste

Lecture 2: Moving and Insertion of Text

Chapter 9: Autofill

Lecture 1: Autofill

Lecture 2: Custom list

Chapter 10: Formatting of Cells

Lecture 1: Wrap Text

Lecture 2: Format Cells Currency

Lecture 3: Merge and Centre

Lecture 4: Format Cells Font

Lecture 5: Format Cells Time

Lecture 6: Format Cells Text

Lecture 7: Format Borders and Fill

Lecture 8: Format Cells Accounting

Lecture 9: Custom Format

Lecture 10: Format Overview

Lecture 11: Autosum, Custom Format Values

Lecture 12: Format Painter

Chapter 11: Basic Calculations

Lecture 1: Adding Non Consecutive Cells

Lecture 2: Addition Method 1

Lecture 3: Addition Method 2

Lecture 4: Addition Method 3

Lecture 5: Division

Lecture 6: Multiplication

Lecture 7: Subtraction

Chapter 12: Working With Functions

Lecture 1: Average

Lecture 2: Max

Lecture 3: Min

Chapter 13: Sorting

Lecture 1: Sorting 1

Lecture 2: Sorting 2

Lecture 3: Sorting 3

Lecture 4: Sorting 4

Lecture 5: Sorting 5

Chapter 14: Paste Special

Lecture 1: Value

Lecture 2: Comment

Lecture 3: Paste Link

Lecture 4: Multiply

Lecture 5: Transpose

Chapter 15: Cell References

Lecture 1: Absolute Reference

Lecture 2: Relative Reference

Chapter 16: Count

Lecture 1: Scenario

Lecture 2: Count

Lecture 3: CountA

Lecture 4: CountBlank

Lecture 5: CountIF

Chapter 17: Logical Functions

Lecture 1: IF Example 1

Instructors

Wilkie Wilkinson
Excel Coach and E-learning instructional Designer

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 0 votes
5 stars: 0 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