Excel Basic Training: Learn Excel with Budgeting Basics

Focused View

Jan-Philipp Rötz

48:52

63 View

1. Welcome to the Course

1. Welcome to the Course.mp4

01:39

2. Class Project

1.1 Personal Monthly Budget.xlsx

1. Real-life Example The Personal Monthly Budget Workbook.mp4

04:09

3. The Basics of Excel Your way to your own Personal Monthly Budget Workbook

1. Step 1 Understanding the Interface of Excel.mp4

03:19

2. Step 2 Creating your own Workbook.mp4

02:24

3. Step 3 Structure your Workbook with Sheets.mp4

02:59

4. Step 4 Add Cells, Rows and Columns.mp4

04:41

5. Step 5 Create your Content.mp4

05:03

6. Step 6 Format your Content.mp4

07:44

7. Step 7 Add Formulas.mp4

05:05

8. Step 8 Sort & Filter your Data.mp4

02:47

9. Step 9 Find & Replace your Data.mp4

04:23

10. Step 10 Print your Workbook to a PDF File.mp4

02:55

4. Summary of this Course

1. Summary and How to Move on.mp4

01:44

Description

Unleash the Power of Excel: From Cells to Formulas. Master real-world skills with hands-on projects!

What You'll Learn?

Create your Personal Monthly Budget workbook
Learn the Basics of Microsoft Excel
Get Inspiration by a real-life example
Learn the Interface of Excel and how to create and structure your workbook
Create, edit and modify Cells, Rows & Columns
Create and format the content
How to use Formulas
How to Sort & Filter and Find & Replace
Print your workbook to a PDF file

Who is this for?

Everybody how wants to get more familiar using the software and for those how wants to have a nice tool for their financial budget planning

Beginner Excel users

What You Need to Know?

No experience is needed. This class is for beginners who just started using Excel.

More details

Description
You will learn how to work with Excel while creating a Personal Monthly Budget workbook for yourself. After taking this class you will be able to start using Excel, you will learn Excel basics and you will have a tool for your monthly financial budget planning. Itâ€™s a win-win situation for you. :-)

WHY YOU SHOULD TAKE THIS CLASS
Excel Skills are needed everywhere. At work many companies use Excel. So, if you want to be successful in your job, good Excel skills might help you.
This class is accompanied by a workbook file which you can download and use to practice the skills which are thought in each chapter. And which includes an example Personal Monthly Budget ready to use.
As an Engineer, I am using Excel every day at work, and I have already created hundreds of workbooks. I will help you to focus on the relevant parts you need to know to work with this tool.

WHO THIS CLASS IS FOR
This class is for beginners who just started using Excel, for everybody how wants to get more familiar using the software and for those how wants to have a nice tool for their financial budget planning.

SKILLSÂ YOUÂ WILLÂ LEARN
This class has three Learning Goals, which are divided by several Learning Objectives.
1 Get inspired by a real-life example
Class Project: â€œPersonal Monthly Budgetâ€
2 Learn the essential basics to Excel
Interface of Excel
Create your Workbook
Structure with Sheets
Create, edit and modify Cells, Rows & Columns
Create your Content
Format your Content
Use Formulas
Sort & Filter
Find & Replace
Print to PDF
3 Have your own â€œPersonal Monthly Budgetâ€ workbook
Create your own â€œPersonal Monthly Budgetâ€
WHAT YOUâ€™LL NEED
Needed:
Microsoft Excel
Provided:
Workbook file to accompany the class and which includes a "Personal Monthly Budgetâ€ ready to use
Who this course is for:
Everybody how wants to get more familiar using the software and for those how wants to have a nice tool for their financial budget planning
Beginner Excel users

User Reviews

Rating

average 0

Total votes0

Focused display

Hi there, I'm Jan-Philipp. I am an Engineer from Germany.ABOUT MEI am very curious and a fan of lifelong learning, so I self-teach me things which benefits me in my life. My favorite question is: Why and how did you do that? That's sometimes annoying for my surroundings but I cannot fight my nature. Maybe, that is why I became an Engineer. :-)Because of my profession, I have learned how to cut big tasks into little actionable steps. I have worked in the aerospace industry and taught people how to build parts of an aircraft engine. Furthermore, I am experienced in designing and optimizing business processes.In short, I am good at explaining the steps you need to know to achieve the learning goals of my classes.MY TOPIC: SOFTWARE TEACHINGThis is the topic I love to cover in my classes: How to use software and what to do with it.As you may have guessed, I am interested in many topics. But I realized, that I am good in Software Teaching. I am the go-to-guy, if my friends and colleagues have any software related question. I scroll through all of the settings in a software when an update is released. It is a little bit nerdy but someone has to do it. Don't you think so? :-)LET'S START LEARNINGIf you you are interested, you can check out the courses I am already teaching.Have fun learning, it is a lifelong journey!Jan-Philipp

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.