Microsoft Excel: Beginner to Advanced, Full Tutorial
4.8 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,030 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel: Beginner to Advanced, Full Tutorial to your Wishlist.

Add to Wishlist

Microsoft Excel: Beginner to Advanced, Full Tutorial

Excel 2010, Excel 2013, Excel 2016. The Full "How to" Excel Crash Course
4.8 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,030 students enrolled
Last updated 3/2017
English
Curiosity Sale
Current price: $10 Original price: $95 Discount: 89% off
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 1 Article
  • 16 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Solve most problems faced by the average Excel user and more. You will be able to build an acceptable spreadsheet successfully in what ever subject is required.
View Curriculum
Requirements
  • All that is required by enrolling students is to have access to any version of Microsoft Excel. Computing skills only need to be basic.
Description

Hi, 

Did you know that 750 million people have Excel installed on their computer but most do not know how to use it!

Excel can be the most awkward of all Microsoft programmes if not the most awkward programme OF ALL TIME! I remember teaching my boss a few simple tricks on Excel that could have easily saved him thousands of hours and untold amounts of effort!

Whatever version of Excel you have, with 'Microsoft Excel: Beginner to Advanced, Full Tutorial' I want to show you how to build and prepare a Workbook good enough for a fortune 500 CEO to a household budget and everything in between. 

My course is designed to help you get up to speed as fast as possible, you can expect to be at a capable level within the first hour of lectures, then you will have the opportunity to explore more great features, functions and tools as you progress further through the course. 

What can you expect after enrolling? You can expect new tutorials to be added every few days that will help you to keep expanding your Excel skills. How will you know that new material has been added? I make educational announcements to all of my enrolled students when I have added new material.

Included within the course are downloadable Excel workbooks which you can download and use to follow along, which means you won't have to go through the "Pleasantries" of inputting figures throughout the course but rather you can get straight into the training. Once you have started the course, you will find the lessons are structured in such a way that you will get the most out of this course and leave with enough knowledge and confidence to get around the most common problems faced by even the most experienced of Excel users.

Whatever your path, 'Microsoft Excel: Beginner to Advanced, Full Tutorial' can help you along the way. Enrol today!

Who is the target audience?
  • Students who are interested in learning Excel as fast as possible to enhance there performance at work or at home. Students who would possibly like to integrate the power of Excel into their own business.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
67 Lectures
05:42:33
+
Start Here
12 Lectures 37:52


Downloading the work material
01:37

Main Workbook
00:01

Excel Features
05:56

Excel Features. Discovering the Auto-fill Feature
04:14

Excel Features. Summary
00:41

Formulas (Part 1 and Intro)
00:46

Formulas (Part 2)
05:52

Formulas (Part 3)
02:44

Formulas (Part 4)
06:33

'Goals' Spreadsheet Exercise
02:30
+
Starting on the Main Workbook
9 Lectures 48:36
Filling in the totals
07:48

Formatting data into a table (1)
02:33

Formatting data into a table (2)
06:30

Inserting and Formatting a Chart
04:59

Inserting and Formatting a Chart
05:09

Formatting a Title
05:13

Printing the first spreadsheet
07:49

Printing the Second Spreasheet
03:59

Printing the Third Spreadsheet
04:36
+
Absolute, Mixed and Relative Reference
3 Lectures 16:57
The Relative, Absolute and Mixed Reference
06:52

Transposing a table and more References
05:51

Dealing with the Mixed Reference
04:14
+
Keeping score with the 'IF' and 'Vlookup' Function
3 Lectures 20:31

Applying conditional formatting
03:16

Assigning grades with the 'Vlookup' Function
08:46
+
Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function
2 Lectures 11:51

Splitting names
05:21
+
Using the PMT Function to explore monthly and yearly compounding
1 Lecture 08:18
Pension
08:18
+
Using Google Drive to collect Data
5 Lectures 23:15

Creating a form
06:24

Completing the form
05:26

Filling in a Google Drive survey
04:12

Analysis data
04:12
+
Using PMT and IPMT functions for a Mortgage
5 Lectures 23:35
PMT Function for a Mortgage
04:39

Mortgages Part 2
05:15

Mortgages Part 3
02:01

Mortgages Part 4
06:34

Mortgages Part 5
05:06
+
CHARTS within Excel
9 Lectures 01:06:07
Introduction Pie Charts
05:36

Formatting Pie Charts
09:07

Introduction to Column Charts
06:10

Formatting Column Charts
13:44

Introduction to Line Charts
04:16


Formatting a line Chart
07:59

Scatter and Combo Charts
10:29

How to insert a Combination Chart
03:29
+
Using the 'What if Analysis' function to calculate changes in data
2 Lectures 09:34
What if Analysis
05:32

What if Analysis with a Data Table
04:02
4 More Sections
About the Instructor
Mr Warrick Klimaytys
4.7 Average rating
43 Reviews
2,460 Students
5 Courses
Computer Technician at Udemy

Hi! My name is Warrick. After qualifying and spending many years with all kinds of computers in many different situations all around the world, I thought it would be a fantastic opportunity to share my knowledge and skills with the Udemy community.

Around  a decade ago I started my professional life in the military where I had experience with all kinds of computers and machines. Today I could be referred to as just a Microsoft "Windows Warrior". As a result of my past experience, I find it is best to deliver my lessons in bite sized chunks and though I try and stay one step ahead of Technology, I find it is always best to walk side by side with my students.