Microsoft Excel Intermediate

$320

This Microsoft Excel Intermediate training course course will give you the opportunity to build on your basic spreadsheet skills by learning learn how to work smarter in Excel, improve your efficiency and impress with your results.

Price

$320

Delivery method

Classroom, Instructor-led

Duration

1 day

Timetable

9:30 am - 5:00 pm

What's included?

Courseware and lunch

Course overview

You will learn how to be more organised and efficient users of Microsoft Excel by understanding how to create complex formulas, use a range of functions and develop dynamic charts and reports. The course focuses on developing your existing skills through a hands-on-learning environment. Content covered includes:

Using conditional formatting

•  Understand how to apply, use and clear conditional formatting

•  Understand more cell formatting options, including top ten items, top and bottom formatting options, data bars, colour scales, icon sets, and sparklines.

Performing Pivot Tables  

•  Understand how to create your own Pivot Tables

•  Understand more applications of  Pivot Tables including filtering a Pivot Table, switching Pivot Table fields, and formatting a Pivot Table.
Clearing a Report Filter

Complex Excel Functions and Formulas

•  Understand how to use IF, CHOOSE, LOOKUP, Counting, Rounding Up, Rounding Down function, etc.

•  Understand how to use MOD, TODAY, NOW, DATE function, etc.

•  Understand how to create a nested functions or complex functions.

Applying Defined Names

•  Understand how to create Defined Names, use Defined Names for Formulas, Constant Values, etc.

•  Understand how to manage and document Defined Names

 

This Microsoft Excel Intermediate training course is designed for people who have basic Excel knowledge and would like to enhance their skills and improve their productivity.

 

Prerequisites

Students should have completed the Microsoft Excel Beginner course, or have a basic understanding of Excel. The course is aimed at those familiar with Excel but looking to learn how to get the most out of the in-built features.

Outcomes

  • Be confident in setting-up and formatting pages;

  • Understand how to create and use words defined in a workbook;

  • Be able to use calculations in an auto-filler;

  • Feel comfortable creating databases;

  • Be competent in using a range of features to enhance charts;

  • Understand how to use Absolute and Relative Referencing in formulas;

  • Be comfortable using Excel’s Quick Analysis Tools;

  • Understand how to create more complex formulas and functions and use a variety of financial functions;

  • Understand how to apply conditional formatting to ranges in a worksheet;

  • Feel comfortable using simple Pivot Tables.

Exam information

Exam code

NA

Exam price

NA

Number of questions

NA

Question type

NA

Duration

NA

Enrol now to save your place

his Microsoft Excel Intermediate training course course will give you the opportunity to build on your basic spreadsheet skills by learning learn how to work smarter in Excel, improve your efficiency and impress with your results.

What will I learn?

In the Microsoft Excel Intermediate course, learn how to create complex formulas and develop dynamic charts and reports. Configure conditional cell formatting and options, including the top ten items, bottom formatting options, data bars, colour scales and icon sets.

Who is Intermediate Suited to?

Microsoft Excel Intermediate focuses on developing your skill set from our Microsoft Excel Beginner training course in our hands-on learning environment. Fill the gaps of your knowledge base and discover how to create and operate charts and productivity tools.

 

Career Opportunities

In Melbourne, IT Futures offers globally recognised courses that guarantee you will receive quality guidance and education with our expert instructors.

After completion of the Microsoft Excel Beginner course, we highly recommend that you follow up and upskill with Excel Intermediate.

What else will I learn?

With Microsoft Excel Intermediate, you will expand your understanding of Excel and learn how to effectively and efficiently construct, operate and manage a Microsoft Excel spreadsheet. Improve and build your efficiency and work smarter with our instructor-led Excel Intermediate course.

What happens after this course?

By the time you finish this course, you will be able to efficiently and effectively work with multiple sheets in Excel workbooks.

Microsoft Excel Intermediate Expands Your Professional Knowledge Base.

What will I learn?

In the Microsoft Excel Intermediate course, learn how to create complex formulas and develop dynamic charts and reports. Configure conditional cell formatting and options, including the top ten items, bottom formatting options, data bars, colour scales and icon sets.

Who is Intermediate Suited to?

Microsoft Excel Intermediate focuses on developing your skill set from our Microsoft Excel Beginner training course in our hands-on learning environment. Fill the gaps of your knowledge base and discover how to create and operate charts and productivity tools.

Career Opportunities

In Melbourne, IT Futures offers globally recognised courses that guarantee you will receive quality guidance and education with our expert instructors.

After completion of the Microsoft Excel Beginner course, we highly recommend that you follow up and upskill with Excel Intermediate.

What else will I learn?

With Microsoft Excel Intermediate, you will expand your understanding of Excel and learn how to effectively and efficiently construct, operate and manage a Microsoft Excel spreadsheet. Improve and build your efficiency and work smarter with our instructor-led Excel Intermediate course.

What happens after this course?

By the time you finish this course, you will be able to efficiently and effectively work with multiple sheets in Excel workbooks.

Microsoft Excel Intermediate Expands Your Professional Knowledge Base.

Challenge Yourself

Obtain numerous benefits for your professional development. Master advanced formulas, lists and illustrations and hone your understanding of Microsoft Excel at an Intermediate level in our Melbourne-based course. Enhance your skills further and develop dynamic charts and reports.