Microsoft Excel Advanced

$320

After completing this Microsoft Excel Advanced training course you will understand complex functions of Microsoft Excel and how to employ advanced tools and automation techniques.

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

During this Microsoft Excel Advanced training course you will build on your existing Microsoft Excel skills and gain the necessary knowledge to perform advanced calculations in spreadsheets. You will become familiar with:

Applying advanced functions into formulas

•   Understand how to use data lookup, including VLOOKUP, HLOOKUP, INDEX, MATCH, etc.

•   Understand how to use reference functions, including ROWS, COLUMNS, ADDRESS, INDIRECT, etc.

•   Understand advanced text functions, including, UPPER, LOWER, CONCATENATE, MID, LEN, SUBSTITUTE, TEXT, VALUE, etc.

•   Understand advanced maths functions, including, TRUC, ROUND, PRODUCT, SUMIF, SUMPRODUCT, etc.

Protecting data

•   Understand data protection, and working with a protected worksheet

•   Understand how to set up access to cells, enable worksheet protection, and create a password for a workbook.

Importing and Exporting

•   Understand how to import data from other data sources, applying Tab Delimited Text, Comma Delimited Text and Space Delimited Text.

•   Understand how to import from an earlier version

•   Understand working with connected data and unlinking connections

•   Understand how to export excel into other types of files, including text, CSV, and  Microsoft Word

Date validation

•   Understand how to apply data validation, including a Drop Down List, using formulas as validation criteria

•   Understand how create an input message

Record a simple Macros

•   Understand Excel Macros, and basic concept of Excel VBA

•   Understand how to record, edit and run a simple Macro

Other advanced Excel features

•  Understand data linking, Grouping and Automatic Outline, Subtotals, Data Consolidation, Scenarios

•  Understand advanced Pivot Tables techniques

 

This course is designed for people who have intermediate Excel skills and would like to be able to solve complex equations using Excel.

Prerequisites

Students should have an intermediate level of competency using Excel. You are advised to complete the Excel Beginner training course and Excel Intermediate training course prior to enrolling or be familiar with the content covered on these courses.

Outcomes

After you completed the Microsoft Excel Advanced training course, you will be well equipped to work with a range of functions and formulas in Microsoft Excel. You will gain the skills to successfully:

 

  • Be confident in using data lookup functions, reference functions, advanced math functions, and advance text functions into formulas to employ the more advanced tools;

  • Understand how to use data validation, create an input message, and create a Drop Down List;

  • Understand how to record your own Excel Macros increasing automation;

  • Be able to use data importing from other source files and exporting into other file formats;

  • Understand how to use data protection, provide restricted access to cells, and setup password protecting your workbook.

Exam information

Exam code

NA

Exam price

NA

Number of questions

NA

Question type

NA

Duration

NA

Enrol now to save your place

After completing this Microsoft Excel Advanced training course you will understand complex functions of Microsoft Excel and how to employ advanced tools and automation techniques.

Challenge Yourself Today

After completing Microsoft Excel Beginner and Intermediate, we recommend our Advanced course with IT Futures, based in Melbourne. You will receive top-notch instruction from our expert educators who will lead you through a helpful and hands-on learning experience.

 

What will I learn?

With Microsoft Excel Advanced, obtain the necessary skills to operate pivot tables, audit and analyse spreadsheet data, utilise data tools, participate with other users, and configure and operate macros. Improve your Excel abilities by automating spreadsheets with macros and learning to solve complex issues.

Who is Advanced Suited to?

This course is essential if you want to further your professional development and build your skills to an expert level. Our Microsoft Excel Advanced training course at IT Futures is designed for students who want to enhance their skills and expand their professional opportunities.

Career Opportunities

Further your Profession with our Microsoft Excel Advanced Course Based in Melbourne.

Hone your career skills in business and master Excel wholly and completely as you learn all the techniques required to be a Microsoft Excel professional.

What happens after this course?

After you complete the Microsoft Excel Advanced course, try our Microsoft Excel Formulas and Functions course to build your knowledge and learn how to manage these specific areas. Enhance your skills and knowledge to new heights with our Melbourne-based course.

Challenge Yourself Today

After completing Microsoft Excel Beginner and Intermediate, we recommend our Advanced course with IT Futures, based in Melbourne. You will receive top-notch instruction from our expert educators who will lead you through a helpful and hands-on learning experience.

What will I learn?

With Microsoft Excel Advanced, obtain the necessary skills to operate pivot tables, audit and analyse spreadsheet data, utilise data tools, participate with other users, and configure and operate macros. Improve your Excel abilities by automating spreadsheets with macros and learning to solve complex issues.

Who is Advanced Suited to?

This course is essential if you want to further your professional development and build your skills to an expert level. Our Microsoft Excel Advanced training course at IT Futures is designed for students who want to enhance their skills and expand their professional opportunities.

Career Opportunities

Further your Profession with our Microsoft Excel Advanced Course Based in Melbourne.

Hone your career skills in business and master Excel wholly and completely as you learn all the techniques required to be a Microsoft Excel professional.

What happens after this course?

After you complete the Microsoft Excel Advanced course, try our Microsoft Excel Formulas and Functions course to build your knowledge and learn how to manage these specific areas. Enhance your skills and knowledge to new heights with our Melbourne-based course.

Challenge Yourself

IT Futures’ courses are hands-on and easy to follow, guided by our knowledgeable and experienced instructors. Discover how to build PivotTables and PowerPivots. In our renowned Microsoft Excel Advanced training course, you will go beyond the beginner and intermediate levels to learn new skills.