Mô tả

Did you know…

Over 750 million people have Excel on their computers, but most don't know how to use it!

This might be because Excel can come across as being a little awkward with first-time users.

Well, within this course, 'Microsoft Excel - Excel from Beginner to Advanced 2024', I'd like to dispel any awkwardness you may encounter, while using Excel, and quickly get you to the point where using Excel is as natural as rolling out of bed in the morning.


How do I do this?


- I explain concepts within Excel simply and clearly.

- I break down Excel's various tools, features, and functionality into the finest of detail, so you can gain a much deeper understanding of the program.

- I re-visit areas already taught every now and again, to reinforce what you would have already learned.

- I created this course to suit any level of learner.


I understand that learning Excel can feel like a huge undertaking, as it was for me when I first started using the program over 10 years ago. And so, you might ask yourself, “Do I have to learn everything in Excel before I can use it effectively?”.

Well, the answer is, NO!

You don’t have to learn every aspect of Excel before you can consider yourself qualified. The truth is, there is a certain level of proficiency that once reached, will make you considerably more qualified than the average Excel user.

To help you achieve this level of proficiency, I've created a very useful Excel workbook called, "main-workbook-section2" to accompany you throughout the first part of the course (After the basic introduction videos/material). In this workbook, I cover most (if not all) of the most important features and functionality you must know to get up to speed with the program as fast as possible. Then as you progress further into the course there are various other pre-prepared spreadsheets and workbooks you can download and use to follow along with my instructions.


What can you expect after enrolment?

We’ll start with a few introductory tutorials to get you set up for the course along with a basic introduction to Excel itself. Then, it’s onto section two, which I hope you’ll complete, and of course, ENJOY! Then, once this part of the course is completed, we'll start diving into other areas of Excel to really start sharpening the skills you would have already learned, along with learning some new things as well.


What do you get when you enroll:


- A 30-day money-back guarantee, so you can enroll risk-free.

- A lifetime access guarantee so you can re-visit the course whenever you want.

- Access to the Q and A section so you can get help at any point during the course.

- A certificate of completion to add to your resume/CV.


So, whatever your reason for wanting to learn Excel, enroll in 'Microsoft Excel - Excel from Beginner to Advanced 2024' today! And see where my course will take you :)


I’ll see you in the first lesson.


Warrick Klimaytys.


Bạn sẽ học được gì

Go from complete beginner to proficient Excel user within 8 hours of content.

Learn to create workbooks and spreadsheets everyone will be jealous of.

Acquire critical Excel knowledge within the first 2 hours of tutorials.

Learn all about: tables, charts, formatting, formulas and functions, macros, pivot tables/charts, and much more!

Yêu cầu

  • No experience needed. You'll learn everything you need to know right from the beginning.
  • This course is compatible with any version of Excel. Including Excel in Microsoft Office 365.
  • No need to start from scratch. Almost all tutorials have a premade spreadsheet/workbook for you to download and use.
  • Take your time! Fast forward, rewind, and pause whenever you like.

Nội dung khoá học

13 sections

Start Here

16 lectures
A brief introduction to Excel
05:33
A little message before continuing :)
01:29
The components that make up a spreadsheet, and more (INTRO)
01:46
The components of a spreadsheet and more
09:47
Open this website for the next tutorial
00:40
Basic text/data management
08:30
Autofill/Flashfill
06:12
Autofill/Flashfill. Part 2
05:10
Autofill/Flashfill. Part 3
05:39
Exercise Instructions
01:44
Solution video
06:33
Course notebook preview
00:52
Downloading your notebook templates and more
00:38
Must know keyboard shortcuts when doing an online course
06:03
List of keyboard shortcuts
00:28
A general overview and brief introduction (MUST WATCH)
02:48

Starting on the MainWorkbook

52 lectures
The main workbook download and instructions
01:44
The three different types of references. Part 1
06:45
The three different types of references. Part 2
03:41
References exercise. A quick note
00:19
References exercise
04:12
Your 3-page instruction manual on references
00:15
Test your knowledge on references
2 questions
Formulas and functions. What's the difference?
02:30
Introduction to formulas
01:27
Formula writing basics
05:05
Test your knowledge on formula writing
1 question
How to solve formulas using BODMAS
05:19
Test you knowledge on the BODMAS rule
1 question
How to write formulas
09:28
Methods for creating using functions
01:14
Basic function variations you must know. Part 1
12:27
Basic function variations you must know. Part 2
11:05
Functions exercise. SumIfs, AverageIfs, & CountIfs
01:39
Welcome to the Concatenate function
06:41
Concatenate exercise
00:11
Test your knowledge on the concatenate function.
1 question
Update to the IF Function tutorial
00:12
The IF Function
11:44
Test your knowledge on the IF function
1 question
Introduction to charts
01:46
Inserting a chart
06:04
Test your knowledge of charts
1 question
Chart exercise instructions
01:11
Charts solution video and more!
05:09
Formatting data into a table
07:03
Formatting data into a table. Part 2
05:20
The I|f/And/Or functions. Part 1
07:07
Test you knowledge on the "If/And" function
1 question
The If/And/Or functions. Part 2
06:04
Test your knowledge on the "If/Or" function
1 question
Introduction to printing
00:52
Printing your first spreadsheet
10:27
Test your knowledge on printing in Excel
1 question
Printer settings
01:35
Printing the second spreadsheet. Solution/exercise
04:23
Building a navigation pane. A few things to note
00:57
HEX to RGB converter link.
00:20
Building a Navigation Pane. Part 1
08:19
Building a Navigation Pane. Part 2
07:32
Test your knowledge on navigation panes and hidden links.
2 questions
Vlookup
09:38
Note about next tutorial
00:23
Student request (Conditional formatting)
03:55
Subtotaling data. Part 1
09:41
Subtotaling data. Part 2
06:52
"Goals" Exercise instructions
02:56
Goals solution video!
11:33

Advanced printing

6 lectures
Advanced printing
08:36
Missing printing feature
00:14
Collation and more
06:20
Advanced printing. Part 2
09:22
Advanced printing. Part 3
09:20
Your 6-page printing instruction manual
00:15

Welcome to the world of macros

12 lectures
Introduction to macros
02:00
Saving as an Excel Macro-Enabled Document
02:32
How to create a macro
07:36
Test your knowledge on Macros
3 questions
How to create macros (Use Relative Referencing)
06:46
Test your knowledge on Macros
1 question
Macros exercise instructions
04:58
Macros exercise solution
07:14
Work with macros conveniently
05:19
Test your knowledge on Macros
2 questions
Final thoughts on macros
01:38
Your 8-page instruction manual on Macros
00:15

Using PMT and IPMT functions for a Mortgage

8 lectures
A quick introduction to this section
01:20
How to workout monthly payments with the PMT function
05:19
How to work out monthly payments with the IPMT function
02:29
How to work out yearly payments with the PMT & IPMT
10:05
Exercise instructions and solution (PMT, IPMT, and more)
05:55
Working out variable rate payments with the PMT
06:26
The interest only and weekly payment example spreadsheets
04:12
Your 4-page instruction manual on the PMT and IPMT
00:14

What if analysis

3 lectures
What if analysis. Data table
10:14
What if analysis. Goal seek
06:49
What if analysis. Goal seek formulas
04:35

3D maps

4 lectures
Introduction to 3D maps
04:18
How to use 3D maps. Part 1
11:54
How to use 3D maps. Part 2
11:57
Link to Microsoft web page
00:13

MUST know functions

10 lectures
Must know functions. Part 1
08:28
Test your knowledge on functions
4 questions
Must know functions. Part 2
08:41
Test your knowledge on functions
2 questions
Must know functions. Part 3
05:53
Your 4-page manual on must know functions
00:19
Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 1
07:18
Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 2
06:01
Missing Draw tab
00:29
Excels drawing tools and more
06:14

Charts in Excel

13 lectures
Introduction to Charts in Excel
01:18
Introduction to Chart formatting
08:29
Test your knowledge on charts
3 questions
Charts in Excel. The Chart Design Tab
07:58
Test your knowledge on charts
3 questions
Charts in Excel. Advanced Formatting Tools
09:33
Inserting and managing Sparklines
06:43
Test your knowledge on Sparklines
2 questions
Pictures in Charts and exercise instructions
05:13
Test your knowledge on pictures in Excel
1 question
Chart and Table Exercise Solution
09:14
Common Charts. Part 1
07:18
Common Charts. Part 2
08:47

Data analysis & management. Part 1

14 lectures
New content added (13/10/2023)
00:11
Introduction to this section
01:01
Where to Get Free HIGH-QUALITY Datasets for Excel
00:58
Collaborating/Sharing in Excel
02:33
Test your knowledge on data analysis and management
1 question
Data validation. Part 1
02:27
Data validation. Part 2
08:25
Test your knowledge on data validation
3 questions
Data validation solution video
01:32
Locating and deleting duplicate data
06:57
Test your knowledge on removing duplicate data
2 questions
Advanced filtering
10:42
Test your knowledge on advanced filtering
2 questions
Advanced filtering solution video
04:04

Data analysis & management. Part 2

5 lectures
How to install the Data Analysis Toolpak
02:33
Test your knowledge on the Data Analysis Toolpak
1 question
Data analysis tools. Part 1
07:07
The Data analysis tools. Part 2
08:25
Test your knowledge on the Data Analysis Toolpak
1 question

Working out true cost. PMT & IPMT for Finance

5 lectures
Calculating the payment with the PMT Function
05:45
Exploring true cost
04:26
Calculating total cost
06:12
Using the 'IPMT' function to work out interest
07:59
Inserting a chart for reference (Car Finance)
05:19

Welcome to Pivot tables and Pivot Charts

15 lectures
The source data 4-point checklist
06:29
Test your knowledge on Pivot tables and Pivot charts
3 questions
Creating a Pivot Table. Part 1
07:34
Test your knowledge on pivot tables and charts
3 questions
Creating a Pivot Table. Part 2
04:28
Test your knowledge of slicers
1 question
Pivot tables. A little extra information
02:46
Pivot table and chart. Scenario 1
08:19
Test your knowledge on Pivot Charts
2 questions
Pivot table and chart. Scenario 2
05:51
Pivot table and chart. Scenario 3
05:23
Building a Pivot Dashboard
04:55
Farewell message
00:39
Farewell message
02:48
Link to Udemy Student Support
00:02

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.