Excel Beginners Training From Scratch

Excel Beginners Training From Scratch, available at Free, has an average rating of 4.48, with 46 lectures, 1 quizzes, based on 701 reviews, and has 16435 subscribers.

You will learn about Learn to navigate around Excel using the ribbon interface Format worksheets and cells Perform simple mathematical calculations Use some of Excel’s built in functions Create and edit different types of charts Build a budgeting spreadsheet from start to finish This course is ideal for individuals who are This is course intended for beginners introducing them to the various features of Excel. The target audience is anyone interested in learning how to use Excel or Students, entrepreneurs, housewives, business owners or professionals It is particularly useful for This is course intended for beginners introducing them to the various features of Excel. The target audience is anyone interested in learning how to use Excel or Students, entrepreneurs, housewives, business owners or professionals.

Enroll now: Excel Beginners Training From Scratch

Summary

Title: Excel Beginners Training From Scratch

Price: Free

Average Rating: 4.48

Number of Lectures: 46

Number of Quizzes: 1

Number of Published Lectures: 46

Number of Curriculum Items: 47

Number of Published Curriculum Objects: 46

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

Learn to navigate around Excel using the ribbon interface
Format worksheets and cells
Perform simple mathematical calculations
Use some of Excel’s built in functions
Create and edit different types of charts
Build a budgeting spreadsheet from start to finish

Who Should Attend

This is course intended for beginners introducing them to the various features of Excel. The target audience is anyone interested in learning how to use Excel
Students, entrepreneurs, housewives, business owners or professionals

Target Audiences

This is course intended for beginners introducing them to the various features of Excel. The target audience is anyone interested in learning how to use Excel
Students, entrepreneurs, housewives, business owners or professionals

The Excel beginners training from scratch course will introduce you to the industry standard and popular spreadsheet software. This Excel training course is perfect for those wanting to learn Excel from the very beginning and you will become comfortable using some of the core features that Excel has to offer.

The course will introduce you to a number of features, tool and techniques of Excel and is perfect for students, entrepreneurs, housewives, business owners, professionals or anyone else looking to learn Excel. By the end of the course you will have mastered the basics of Excel and will be able to manage workbooks, use formatting, perform calculations, use formulas and create charts.

This is a hands-on beginners Excel course and you will learn by watching the instructor as he describes each action as he performs it. The course takes a project based approach, which means that you will be able to practice as you are learn and by the end of the course you will even complete a project from beginning to end – creating a fully functional budgeting spreadsheet with charts, formulas and a host of other features.

Note:The instructor uses Excel 2010 to teach the course, but the course should be suitable for those with Excel 2007 onwards. There are some differences in the menu structure if you are using Excel 2013.

Instructor:Abhijat Saraswat (Ab)

The course is taught by Ab, who is an Excel whizz and has been using Excel for over 10 years, since Excel 95. He uses Excel almost on a daily basis and has taught Excel to a large number of students including executives of large organisations, small business owners and entrepreneurs.

Course Curriculum

Chapter 1: Introduction & files

Lecture 1: Course introduction

Lecture 2: Pre-course survey

Lecture 3: Course and Exercise files

Chapter 2: Navigating Excel

Lecture 1: Excel Terminology

Lecture 2: Navigating the ribbon interface

Lecture 3: Excel toolbars

Lecture 4: The Excel file menu

Lecture 5: Tips & Tricks

Chapter 3: Working with Worksheets

Lecture 1: Working with worksheets

Lecture 2: Creating, moving and deleting sheets

Lecture 3: Renaming sheets

Lecture 4: Copying and moving sheets

Lecture 5: Worksheet organisation

Lecture 6: Formatting cells and worksheets

Chapter 4: Number Formats

Lecture 1: Introduction to number formats

Lecture 2: Different number formats

Lecture 3: Assigning number formats

Lecture 4: Number format options

Lecture 5: Custom number formats

Lecture 6: Dates in Excel

Lecture 7: Midway review and Exercise

Chapter 5: Functions and calculations

Lecture 1: Formulas introduction

Lecture 2: Math calculations

Lecture 3: Introduction to functions

Lecture 4: Absolute vs relative references

Lecture 5: Most commonly used functions

Lecture 6: Section wrap-up and exercise

Chapter 6: Charting

Lecture 1: Charting introduction

Lecture 2: Do you need to use a chart

Lecture 3: Anatomy of a chart

Lecture 4: Chart types

Lecture 5: Creating a column chart

Lecture 6: Creating a line chart

Lecture 7: Creating a bar chart

Lecture 8: Creating a pie chart and wrap-up

Chapter 7: Course project

Lecture 1: Project introduction

Lecture 2: A look at what we will be making

Lecture 3: Creating the data section

Lecture 4: Creating the overview section

Lecture 5: Creating the chart and conditional formatting

Chapter 8: Course wrap-up

Lecture 1: Course wrap-up and thanks!

Lecture 2: Post course survey

Chapter 9: Bonus content

Lecture 1: Lookups (V & H lookups)

Lecture 2: Named ranges – adding meaning to your formulas

Lecture 3: Adding comments to your spreadsheets

Lecture 4: Printing and exporting spreadsheets

Instructors

Abhijat Saraswat
Instructor

Rating Distribution

1 stars: 5 votes
2 stars: 17 votes
3 stars: 85 votes
4 stars: 239 votes
5 stars: 355 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