EXCEL EXPERT (ADVANCED) PERTH

Outline | PDF | Calendar | Enrol | Enquire | Pricing

Mobile MOUSe is the preferred INSTRUCTOR LED Excel advanced course provider for Australia's largest companies.

EXCEL EXPERT COURSE OVERVIEW
Skill Level: Advanced

THIS COURSE IS TAILORED TOWARDS STUDENTS OBTAINING THE MICROSOFT OFFICE EXPERT OR MASTER CERTIFICATION (MOS).

This Advanced Excel Course is designed to help attendees develop (or enhance) advanced skills in Microsoft Excel. Attendees will learn how to easily manipulate spreadsheets to easily perform advanced activities in Excel. In addition to learning how to automate every day Excel tasks and processes, attendees will learn how to develop powerful summaries and reports in Excel. Attendees will also learn how to setup, manage, maintain and secure workbooks that are to be used by other users.

WHO SHOULD ATTEND THIS COURSE

This course is designed for people who need to come to grips with more advanced features of Excel. Anyone who reports, edits and maintains larger spreadsheets is an ideal candidate for this training.

COURSE DURATION AND TRAINING VENUE

DURATION: 1 full day (9am to 4pm)
VENUE: Onsite (your premises) or Inhouse (our premises)

MINIMUM ATTENDANCE REQUIREMENTS

• This course is not intended for new users to computing or spreadsheets.
• Attendees have Intermediate or Advanced Excel skills.
• Attendees must have keyboard and mouse skills.

COURSE OUTLINE

PART ONE - FOREIGN DATA & MANAGING WORKBOOKS

• Importing and Exporting Data
• Importing data from other applications
• Using the text import wizard
• Importing a Web Page
• Exporting Data
• Managing Workbooks
• Applying a template
• Editing a template
• Creating a template
• Consolidating Data

PART TWO - MAKING EXCEL EVEN EASIER

• Auditing Formulas
• Locating and Resolving Errors
• Precedents & Dependants
• Watch Window
• Goto > Special
• Naming Ranges
• Creating names in bulk
• Using names in formulas
• VLOOKUP
• HLOOKUP
• SUMIF, AVERAGEIF, COUNTIF
• Advanced Filters
• Grouping & Outlining

PART THREE - AUTOMATING & CUSTOMISING EXCEL

• Advanced Formatting
• Creating custom number & date formats
• Advanced Conditional Formatting (with Formulas)
• Macros
• Global and Local Macros
• Absolute and Relative cell references
• Editing macro code
• Customizing the Ribbon and Quick Access Toolbar

PART FOUR - ANALYSING AND SHARING DATA

• PivotTables & PivotCharts
• Using Business Analysis Tools
• Creating data tables
• Using goal seek
• Using solver
• Scenarios
• Passwords, Protections and Properties
• Protecting a workbook
• Protecting worksheets and ranges
• Allowing users to edit ranges
• Collaborating with Others
• Creating a shared workbook
• Highlight, accept & reject changes
• Merging workbooks

ADDITIONAL SELF STUDY (MOS EXPERT CERTIFICATION)

• Manipulate formula options*
• Perform data summary tasks*
• Apply functions in formulas*
• Apply advanced chart features*
• Insert and manipulate form controls*

* Covered in our Excel Essentials Training or on our Formula Workshop Course - but self study content is provided in our student MOS prep-book.

IS THIS THE RIGHT EXCEL COURSE FOR YOU?

Not sure which excel course is the right one for you? Take our free, zero obligation excel self assessment here. More info...

» Excel New Users Course (Basic)
» Excel Essentials Course (Intermediate)
» Excel Formula Workshop Course (Advanced)
» Excel Dashboards (Day 1) Course (Advanced)
» Excel Dashboards (Day 2) Course (Advanced)
» Excel VBA (Visual Basic for Applications) Course (Advanced)

[back to the top]

LEARN ABOUT OUR ONSITE TRAINING



ABOUT OUR EXCEL EXPERT (ADVANCED) COURSES

Our Excel advanced training in Perth is conducted at your premises (office / factory) or... alternatively, our advanced Excel Courses can be delivered at Unit 1 / 41 Action Rd, Malaga, Perth, WA.

With our onsite excel training options, we come to you with our laptop computers and projection equipment to deliver the Excel course of your choice.

We can deliver custom Excel training courses (i.e. you choose specific aspect(s) of our Excel courses that you would like delivered).

Our Microsoft Excel training is structured to Microsoft Office Certification, in addition, every Excel course comes with free online support.

COURSE PRICING

Our pricing structure is unique. The more people you enrol in an excel course, the cheaper the excel course becomes (which is great for companies and friends). More info...

For all of the reasons above (and more), Australias' biggest companies acknowledge the features and benefits of training with Mobile MOUSe. Our professional approach and intricate knowledge of the features and abilities of Excel have saved our clients millions of dollars after they implemented the features we have made them proficient in. More info...

OUR TRAINERS

Our trainers are known for their knowledge and helpful, friendly approach. All of our excel courses are taught by experienced, certified and qualified instructors, who individually have a minimum of 15 years training experience.

EACH STUDENT RECEIVES

• The best Excel training in Perth and Western Australia
• A detailed high quality manual -> download a sample
• Free downloadable practice files
• Online support
• A certificate of attendance (on request)
• Zero Hassle, FREE PARKING when attending at our premises

[back to the top]