COURSES | PRICING | CALENDAR | ENROL | CONTACT | SELF ASSESSMENT | DOWNLOADS | FEEDBACK  
 
  EXCEL | WORD | ACCESS | OUTLOOK | PROJECT | POWERPOINT | VISIO | INFOPATH | PUBLISHER | SHAREPOINT | ACROBAT | PC BASICS |ONLINE COURSES
  TIME MANAGEMENT | PROJECT MANAGEMENT | CONSULTING SERVICES | ONSITE TRAINING | OUR VENUE
 
» QUICK LINKS
 

EXCEL ESSENTIALS (INTERMEDIATE) PERTH

Outline | PDF | Calendar | Enrol | Enquire | Pricing

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

EXCEL ESSENTIALS COURSE OVERVIEW
Skill Level: Intermediate

THIS COURSE IS TAILORED TOWARDS STUDENTS OBTAINING THE MICROSOFT OFFICE SPECIALIST CERTIFICATION (MOS).

This Excel course will teach attendees how to correctly structure spreadsheets, build functions and formulas as well as easily format spreadsheets using handy tips and tricks (including shortcuts). Attendees will also learn how to link data (and perform calculations) across worksheets and workbooks. Attendees will also learn how to correctly (and easily) structure and manage various types of charts to effectively present your excel spreadsheet data in a graphical format.

WHO SHOULD ATTEND THIS COURSE

Users who want to improve or sharpen their exisiting basic or intermediate skills in Excel. Much emphasis is placed on the quickest and easiest ways to accomplish activities in Microsoft Excel.

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 must have keyboard and mouse skills.

COURSE OUTLINE

PART ONE - FORMULA DESIGN

• Advanced Paste Options
• Entering formulas
• Order of Operations (Enforcing Precedence)
• SUM / AVERAGE / MAX / MIN / COUNT(A) functions
• Percentage formulae
• Absolute and Relative Referencing
• Using the IF function
• Good spreadsheet design

PART TWO - ENHANCING AND REVISING WORKBOOKS

• Naming Ranges
• Cell Styles
• Modifying the Quick Access Toolbar
• Modifying Workbooks
• Moving & copying worksheets
• Grouping worksheets
• More Complex Formulas
• Calculations across sheets and workbooks
• Linking sheets and workbooks
• Using 3D Reference functions (for summary sheets)
• TODAY(), NOW(), EDATE()
• Nesting within an IF function
• Conditional Formatting
• Data Validation
• Subtotals
• Format as Table

PART THREE - CHARTS AND sparklines

• Charts
• Pie / Column / Bar / Line charts
• Scaling & printing chart objects
• Modifying charts
• Editing & formatting charts
• Sparklines (Excel 2010 / 2013 only)

ADDITIONAL SELF STUDY (MOS CERTIFICATION)

• Worksheet Navigation*
• Print a worksheet or workbook*
• Apply and modify cell formats*
• Merge or split cells*
• Create row and column titles*
• Hide and unhide rows and columns*
• Manipulate Page Setup options for worksheets*
• Manipulate print options for worksheets*
• Create and format worksheets*
• Manipulate workbook views*
• Split and Freeze Panes*
• Create and manage Comments*
• Apply and manipulate illustrations*
• Create and modify images by using the Image Editor*
• Share spreadsheets by using Backstage*

* Covered in our Excel basics course - but self study content is provided in our student workbook / prep-guide.

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 Expert Course (Advanced)
» 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 ESSENTIALS (INTERMEDIATE) COURSE

 

Our Excel Intermediate training in Perth is conducted at your premises (office / factory) or... alternatively, our Intermediate 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]

» CALENDAR

Click the image below to view our current perth training schedule and potentially book your classroom seat(s).

 

Mobile MOUSe course calendar

» TRAINING FACTS

There are many myths about training - reasons suggested for postponing skill development. Whether it’s a process that is not being followed, technology under utilised – every organisation benefits from training...

 

More info...

» CERTIFICATION

Mobile MOUSe is an authorised testing center for the range of internationally recognised Microsoft Office Certifications.

 

Microsoft Office Certification

 

More info...

» VENUE & ROOM HIRE

Need a meeting or training room? Options range from a day to a years lease.

 

More info...

 
Email Mobile MOUSe
Read our terms and conditions...