Excel Basic Training: Create Your Personal Monthly Budget

Learn how to work with Microsoft Excel while creating a real-life example workbook for yourself.

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

Requirements

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

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 CLASSExcel 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 FORThis 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 LEARNThis class has three Learning Goals, which are divided by several Learning Objectives.1 Get inspired by a real-life exampleClass Project: “Personal Monthly Budget”2 Learn the essential basics to ExcelInterface of ExcelCreate your WorkbookStructure with SheetsCreate, edit and modify Cells, Rows & ColumnsCreate your ContentFormat your ContentUse FormulasSort & FilterFind & ReplacePrint to PDF3 Have your own “Personal Monthly Budget” workbookCreate your own “Personal Monthly Budget”WHAT YOU’LL NEEDNeeded:Microsoft ExcelProvided:Workbook file to accompany the class and which includes a "Personal Monthly Budget” ready to use

Overview

Section 1: Welcome to the Course

Lecture 1 Welcome to the Course

Section 2: Class Project

Lecture 2 Real-life Example: The "Personal Monthly Budget" Workbook

Section 3: The Basics of Excel: Your way to your own "Personal Monthly Budget" Workbook

Lecture 3 Step 1: Understanding the Interface of Excel

Lecture 4 Step 2: Creating your own Workbook

Lecture 5 Step 3: Structure your Workbook with Sheets

Lecture 6 Step 4: Add Cells, Rows and Columns

Lecture 7 Step 5: Create your Content

Lecture 8 Step 6: Format your Content

Lecture 9 Step 7: Add Formulas

Lecture 10 Step 8: Sort & Filter your Data

Lecture 11 Step 9: Find & Replace your Data

Lecture 12 Step 10: Print your Workbook to a PDF File

Section 4: Summary of this Course

Lecture 13 Summary and How to Move on

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