Excel in Microsoft Excel 1: beginner to Excel intermediate

Back To All Courses

164 Lessons

All

Skill Level

12:14h

course Duration

English

Audio

Eng

Subtitles

Share This Class:

Overview

This course series has been recorded on Excel 2016 and Excel 2010, but the content also covers Excel 2013, 2007 and 2019.

By the end of this course, you will have the skills needed for the official Microsoft Excel Specialist exam. How would that look on your resume?

Most people who use Excel are up to Level 3 in some aspects, and Level 2 in others. Why not go all the way to Level 5?

This course teaches all the skills that Microsoft want you to know. Specifically, they are the skills required to undertake the Microsoft Certificate 77-602 (for Excel 2007), 77-882 (for Excel 2010), 77-420 (for Excel 2013) and 77-727 (for Excel 2016 Core) and will be useful if you wish to take the exam, or which to learn more about Microsoft Excel

The core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft Excel, and this course teaches you all of them.

Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.

Completing this course will help you:

Create, configure and save Excel worksheets and workbooks.
Navigate through and format worksheets and workbooks.
Customise options and views for worksheets and workbooks.
Configure Excel worksheets and workbooks to print (e.g. page setup).
Insert data into and format cells and ranges, and create and modify tables.
Highlight, filter, sort and group cells, ranges and tables.
Create and format Excel charts.
Insert and format objects, including modifying images.
Create formulas in Excel, including using conditional logic and modifying text.

Who is the course for?

This course is for you if you want to develop your Microsoft Excel skills.

This course will use the latest version of Excel, but is ideal for you if you use any modern version – Excel 2007, 2010, 2013, 2016 or 2019.

This course is also for you if you use an older version of Microsoft Excel, but want to learn the newer versions.

This course is for you if you want to become certified in Microsoft Excel, as by the end you should the knowledge to because certified as a Microsoft specialist, if you wish to do so.

You will cover the content tested in Microsoft Office Specialist Exams 77-602 (for Excel 2007), 77-882 (for Excel 2010), 77-420 (for Excel 2013) and 77-727 (for Excel 2016 Core)

Learning Path

Level 1 – Let’s start using Excel

An introduction to Excel
Create worksheets and workbooks
Configure worksheets and workbooks to save
Basic formulas

Level 2 – About worksheets and workbooks, including cell ranges and references

Navigate through Excel worksheets and workbooks
Format worksheets and workbooks
Customise options and views for worksheets and workbooks
Configure Excel worksheets and workbooks to print
Utilise cell ranges and references in formulas and functions

Level 3 – About cells and ranges, including summarising data

Insert data in cells and ranges
Format cells and ranges
Highlight and filter cells and ranges in Excel
Summarise data with Excel functions

Level 4 – Tables, and using conditional logic

Create a table
Modify a table
Filtering, Sorting and Grouping
Utilise conditional logic in functions

Level 5 – Charts and objects, and text functions

Create a chart in Excel
Format a chart in Excel
Insert and format an object
Create and modify images by using the Image Editor
Format and modify text with functions
Bonus section – some Expert functionality

What people are saying

“The course was great! I watched all the videos, even the concepts I was already familiar with going in, just to see if there was a more efficient/better way to do things. Turns out some of the Excel features I was using every day could be utilized even better! The course was taught in a manner that made sense, both in the organization of the material and in how the information was presented. I am happy to say I passed my Excel certification with a 920 and have bought the Expert level course.”
Samantha
“I really believe this course took my Excel skills to another level! The course is well-made. The descrpitions of the teacher are clear and the exercises check if you remember the material. Philip Burton is an excellent teacher so I decided to buy another his course. I highly reccomend “Excel in Microsoft Excel 1: beginner to Excel intermediate” course. Cheers!”
Iwona
“This is a very informative course. I am more of a hands-on learner and it would help if you went a little slower for those that have to think before crossing. Thanks for your help.”
Sheila
“I had to take an Excel proficiency test as a job interview requirement , and scored top 10% percentile (they called me immediately to schedule a face-to-face) , thanks to your great course for which I studied for two days straight to re-enforce my knowledge in Excel, and more importantly fill those gaps of knowledge on all its functionality capabilities . You really get the MOST out of Phillip’s courses. I have purchased the SQL Series, The Excel Series, the SSRS,SSIS & SSRS Series & the Intro. VBA course. I encourage everyone entering the data world to get these courses.”
Rick
Previous
Next

Excel in Microsoft Excel 1: beginner to Excel intermediate

164

Lessons

All