Excel: Beginner to Intermediate

164

LESSONS

ALL

SKILL LEVEL

12:14 hr

DURATION

ENGLISH

AUDIO

ENG

SUBTITLES

OVERVIEW

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

By the end of the course, you will have the core skills needed for the official Microsoft Excel Specialist exams:

  • Certificate 77-602 for Excel 2007
  • Certificate 77-882 for Excel 2010
  • Certificate 77-420 for Excel 2013
  • Certificate 77-727 for Excel 2016 Core

WHO IS THE COURSE FOR?

This course if for anybody who wants to develop their Excel skills beyond the basics and become more efficient in its use. No prior knowledge is needed.

LEARNING PATH

START USING EXCEL

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

WORKSHEETS AND WORKBOOKS

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

CELLS AND RANGES

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

TABLES AND USING CONDITIONAL LOGIC

  • Create a table.
  • Modify a table.
  • Filter, sort and group.
  • Utilise conditional logic in functions.

CHARTS, OBJECTS, AND TEXT FUNCTIONS

  • Create a chart.
  • Format a chart.
  • Insert and format an object.
  • Create and modify images using the Image Editor.
  • Format and modify text with functions.
  • Bonus – a little ‘expert’ functionality.

REVIEWS

“Excellent course. I thought I was an advanced user but starting from scratch I’m learning things I didn’t know that I didn’t know. Thank you so much.” Penny

“I really believe this course took my Excel skills to another level! The course is well-made. The descriptions of the teacher are clear and the exercises check if you remember the material. Phillip Burton is an excellent teacher so I decided to buy another his course.” Iwona

“The teacher explains very well and at a good pace. Has real in-depth knowledge. The exercises are precise and well put together for the course. And the language sheets are invaluable to those that use other language than English version. I highly recommend this course. It goes thru most of the basic knowledge needed for Excel. Once again The teacher is excellent.” Daniel

READY TO START?