Excel can be used for organising, calculating and analysing data in Brisbane.

It can also be used for preparing simple invoices to creating 3-D charts and graphs. This course introduces the power and flexibility of Microsoft Excel 2010.

This dynamic training course on Excel 2010 is available now in Brisbane.

After an introduction to spreadsheet terminology and Excel’s window components, you will learn how to use the Help system and navigate worksheets and workbooks.

Then you will enter and edit text, values, formulas, and pictures, and you’ll also learn how to save workbooks in various formats.

You will then move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns.  This course also covers simple functions, basic formatting techniques, and printing.  Finally, you will create and modify charts, and learn how to manage large workbooks.

This course will help also help you prepare for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and the Microsoft Office Specialist Expert exam for Excel 2010 (exam 77-888).

For comprehensive certification training, you should complete the Introduction, Intermediate, and Advanced courses for Excel 2010.

PD Training delivers a one day training course on “Excel 2010 Training Course” in Sydney, Melbourne, Perth, Adelaide and Canberra.

Our next course on “Introduction to Excel 2010 Training Course” is on May 15th in Brisbane, so book your seat today!

The new PD Training rooms come equipped with free wi-fi, a recreational gaming area with Nintendo Wii and the Intermediate Excel 2010 Training Course in Brisbane also includes a free lunch with the cost of the course.

Free street parking is also available and we are close to public transport as well.

All students receive post Advanced Excel 2010 Training Course from the instructor for 12 months, a certificate of completion and small class sizes are guaranteed to result in a better training experience for you.

Best Excel 2010 Training Class including use of a cool games room, great lunch and bottomless espresso, free soft drink and unlimited health snacks all day – book in the next Advanced Excel 2010 Course now  – small interactive class, definitely the BEST course, BEST Trainers and BEST training environment!

Office 365 Excel is Microsoft’s new “cloud” based spreadsheet that’s available anywhere.

Use your browser to edit and create Excel workbooks and worksheets, simultaneously edit spreadsheets with your colleagues and securely store them online, making them available on tablets, phones, laptops and desktops.

In this Office 365 Excel Essentials training course running in Sydney, Brisbane, Adelaide, Canberra, Melbourne and Perth, participants will learn how to share and upload spreadsheets, open and close spreadsheets and print them.

Participants will also learn how to edit the spreadsheet in the browser, open the spreadsheet in Excel, edit the spreadsheet in the browser, format fonts and much more.

Learning Outcomes Include:

• Open and close spreadsheets
• Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
• Understand the Excel 365 browser interface
• Upload a spreadsheet to the Shared Documents library
• Differentiate between worksheets, workbooks, rows, columns, and cells
• Download and reload workbooks
• Use the Find Command
• Save a Copy
• Open in Editing View
• Open the spreadsheet in the Excel desktop application for more advanced features
• Understand saving and collaborating
• Create a new file
• Enter labels and values
• Edit data
• Use the Wrap Command
• Use cut, copy, and paste

PD Training delivers a one day training course on “Office 365 Excel Intro Training Course” in Sydney, Melbourne, Perth, Adelaide and Canberra.

Our next course on “Office 365 Excel Essentials Training Course” is on May 15th in Brisbane, so book your seat today!

The new PD Training rooms come equipped with free wi-fi, a recreational gaming area with Nintendo Wii and the Office 365 Excel Intro Training Course in Brisbane also includes a free lunch with the cost of the course.

Free street parking is also available and we are close to public transport as well.

All students receive post Office 365 Excel Intro Training Course from the instructor for 12 months, a certificate of completion and small class sizes are guaranteed to result in a better training experience for you.

Best Office 365 Excel Intro Training Class including use of a cool games room, great lunch and bottomless espresso, free soft drink and unlimited health snacks all day – book in the next Office 365 Excel Intro Course now  – small interactive class, definitely the BEST course, BEST Trainers and BEST training environment!

Learning how to use the advanced features of Microsoft Excel 2010 in Brisbane opens a completely new experience when using this spreadsheet program.

The novice user tends to use Excel 2010 as holding place for report data.  They may know how to insert data and move columns around, but rarely go into the deeper functions that Excel 2010 offers.

This workshop will teach you the most common advanced features of Microsoft Excel 2010.  The goal of this course is to get you familiar with these functions in a safe learning environment.  Once you complete the course, your familiarity and confidence in using the advanced features of Excel will increase, making the software a more useful tool for you at work or at home.

Excel Charts

Creating charts is an essential task when presenting data in Brisbane.  Charts help to communicate your information clearly and concisely.  It also adds a visual appeal to the document.

Charts help to illustrate data in a way that is easier to read and understand.

Charts help to make quick comparisons and track trends.  Excel 2010 makes creating a chart a simple task.  Before you can create a chart, you will need to have data incorporated onto the worksheet.  You should format your data so the chart tool can process it correctly

There are six major parts to a chart.

Knowing the different parts will help you understand what information you will need in your data set to make the chart relevant to your audience.  Here are the major parts:

• Horizontal Axis: This part of the chart is the bottom section or line of the chart.  This is usually the category of the data for example.  It could represent years, product, sales person, department, etc.  Typically, there are no values in this area of the chart.
• Vertical Axis: This is the part of the chart is the left side or vertical line of the chart.  This part of the chart usually contains the values as it relates to the horizontal categories.  It could represent units, money, percentages, etc.
• Legend: Explains what each plotted data set represents.  For example, it could distinguish that each bar represents in a column chart or what each piece of the pie represent on a pie chart.
• Chart Area: This is the area outside of the plot area.  This area can be changed to have different colours and looks.
• Plot Area: This area contains the data in an illustrative format like columns, pie pieces, etc.  The plot area could contain grid lines or not.
• Series: This is a set of similar data grouped by category.  For example, sales could represent one series and cost another.
• Chart Title: This is usually located above the graph and it usually is a summary of what the data represents like projections, or quality report.

PD Training delivers a one day training course on “Advanced Excel 2010 Training Course” in Brisbane.

Our next course on “Advanced Excel 2010 Training Course” is on May 15th in Brisbane, so book your seat today!

The new PD Training rooms come equipped with free wi-fi, a recreational gaming area with Nintendo Wii and the Advanced Excel 2010 Training Course in Brisbane also includes a free lunch with the cost of the course.

Free street parking is also available and we are close to public transport as well.

All students receive post Advanced Excel 2010 Training Course from the instructor for 12 months, a certificate of completion and small class sizes are guaranteed to result in a better training experience for you.

Best Advanced Excel 2010 Training Class in Brisbane including use of a cool games room, great lunch and bottomless espresso, free soft drink and unlimited health snacks all day – book in the next Advanced Excel 2010 Course now  – small interactive class, definitely the BEST course, BEST Trainers and BEST training environment!

This Excel 2010 Advanced training course running in Sydney, Brisbane, Adelaide, Canberra, Melbourne and Perth, is rated 5.0/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Excel 2010: Intermediate.

Participants will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX.

In addition, you will learn about data validation and database functions such as DSUM. You will also learn how to import and export data, and how to query external databases.

This course will help participants prepare for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and the Microsoft Office Specialist Expert exam for Excel 2010 (exam 77-888).

For comprehensive certification training, participants should complete the Introduction, Intermediate, and Advanced courses for Excel 2010.

Advanced Excel Course Modules Include:

Introduction

• Introduction
• Personal learning goals of each participant
• Plan and structure for the day

Logical and statistical functions

• Logical functions
• Math and statistical functions

Financial and date functions

• Financial functions
• Date and time functions
• Array formulas
• Displaying and printing formulas

Lookups and data tables

• Using lookup functions
• Using MATCH and INDEX
• Creating data tables

Advanced data management

• Validating cell entries
• Exploring database functions

Exporting and importing

• Exporting and importing text files
• Exporting and importing XML data
• Getting external data

Analytical tools

• Goal Seek and Solver
• The Analysis ToolPak
• Scenarios

Macros and customer functions

• Running and recording a macro
• Working with VBA code
• Creating functions

PD Training delivers a one day training course on “Advanced Excel 2010 Training Course” in Sydney, Melbourne, Perth, Adelaide and Canberra.

Our next course on “Advanced Excel 2010 Training Course” is on May 15th in Brisbane, so book your seat today!

The new PD Training rooms come equipped with free wi-fi, a recreational gaming area with Nintendo Wii and the Advanced Excel 2010 Training Course in Brisbane also includes a free lunch with the cost of the course.

Free street parking is also available and we are close to public transport as well.

All students receive post Advanced Excel 2010 Training Course from the instructor for 12 months, a certificate of completion and small class sizes are guaranteed to result in a better training experience for you.

Best Advanced Excel 2010 Training Class including use of a cool games room, great lunch and bottomless espresso, free soft drink and unlimited health snacks all day – book in the next Advanced Excel 2010 Course now  – small interactive class, definitely the BEST course, BEST Trainers and BEST training environment!

Do you need to improve your advanced excel skills while working in Brisbane?

This third and final course in the Excel 2010 series, really helps tie the previous two courses up and elevate Excel skills to an expert level.

Topics like logical functions, math & statistical functions, VLOOKUP, MATCH, INDEX and editing VBA functions, are covered in depth.

This dynamic advanced Exceltraining course is available now throughout Australia, including Brisbane, Sydney, Melbourne, Adelaide, Canberra and Perth.

Topics covered in this advanced excel 2010 course include:

• Use logical functions (IF, OR, AND & NOT)
• Use math & statistical functions
• Use the PMT function
• Use data functions (YEAR, DAYS360 & NETWORKDAYS)
• Calculate time
• Create array formulas
• Use VLOOKUP, MATCH & INDEX functions
• Validate data
• Use database functions
• Import & export text files
• Import & export XML data
• Use Goal Seek & Solver
• Use the Analysis ToolPak
• Create scenarios
• Run and record macros
• Edit VBA modules
• Create custom functions

Finally, participants will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics.

PD Training delivers a one day training course on “Advanced Excel 2010 Training Course” in Sydney, Melbourne, Perth, Adelaide and Canberra.

Our next course on“Advanced Excel 2010 Training Course” is on May 15th in Brisbane, so book your seat today!

The new PD Training rooms come equipped with free wi-fi, a recreational gaming area with Nintendo Wii and the Advanced Excel 2010 Training Course in Brisbane also includes a free lunch with the cost of the course.

Free street parking is also available and we are close to public transport as well.

All students receive post Advanced Excel 2010 Training Course from the instructor for 12 months, a certificate of completion and small class sizes are guaranteed to result in a better training experience for you.

Best Advanced Excel 2010 Training Class including use of a cool games room, great lunch and bottomless espresso, free soft drink and unlimited health snacks all day – book in the next Advanced Excel 2010 Course now  – small interactive class, definitely the BEST course, BEST Trainers and and BEST training environment!