Adelaide - Brisbane - Cairns - Canberra - Darwin - Melbourne - Perth - Sydney

Excel training courses and schools
Microsoft Excel

School: ELECTUS
[All Courses]

Excel Pivot Tables & Filtering Workshop
Course Format: Classroom
This ½ day workshop provides an understanding about the value of the Pivot Tables and AutoFilter features within Excel. PivotTables are a great data analysis tool for management. They allow you to create multi dimensional data views by dragging and dropping column headings to move data around. Microsoft Excel also provides a very simple mechanism (AutoFilter) for filtering/s...
 

Excel Formulas and Functions Workshop
Course Format: Classroom
This workshop provides the necessary skills to utilise formulas and functions within an Excel worksheet. It also looks at some of the more advanced logical, date and many other in-built functions available within Excel. The in-built functions are special pre-written formulas that perform an operation or calculation on values in your worksheet, placing the result of the calculation in...
 

Programming in VBA using Excel
Course Format: Classroom
This 3 day program aims to provide a good understanding of programming in Visual Basic for Applications (VBA), especially as it relates to Microsoft Excel. Course Content Recorded Macros · Macro Recorder Overview · Recording a Simple Macro · Running a Recorded Macro · Relative Recording · Running a Relative Recording · Viewin...
 

Excel 2003
Course Format: Classroom
In this 2 day program, you will gain the knowledge and skills to allow you, by means of realistic business scenarios, to create workbooks incorporating formulas, functions and graphs.. They will also learn how format your workbooks for professional presentation and easy-to-follow printouts. You will learn to Ø Fully utilise the interface Ø Navigate efficiently ...
 

Excel 2003 Intermediate
Course Format: Classroom
In this 2 day program, you will learn advanced editing and formatting and expand your working knowledge of formulas and graphs. You will also explore the powerful database tools within Excel You will learn to Ø How to automate data entry Ø Use a wider range of functions and formulas including conditional statements Ø Set up complex formatting Ø Cust...
 

Excel 2003 Advanced
Course Format: Classroom
In this 2 day program, participants will gain the knowledge and skills to allow them to use Microsoft Excel 2003 to an advanced level, particularly for those interested in data analysis, data management and more complex calculations. You will learn to Ø Customise the interface Ø Create new default worksheets and workbooks Ø Use workbook collaboration Ø ...
 

School: Drake Training
[All Courses]

Microsoft Excel Level 3
Course Format: Classroom
Advanced Functions What is a Function? Text Functions Mathematical Functions Logical Functions Nested If Functions Working with External Data About Microsoft Query Starting a Query within Excel Creating a Query Editing the Data Results Editing a Saved Query Refreshing a Single Query Refreshing All Queries At Once Refreshing Queries Automatically Using Hyperlinks in Spreadshee...
 

Microsoft Excel Level 2
Course Format: Classroom
Customising the Toolbar Customising Toolbars Displaying Toolbars Creating Toolbars Changing a Button’s Appearance Removing Buttons from the Toolbar Deleting a Toolbar Personalised Menus and Toolbar Options Working with Range Names Creating and Defining a Range Name Defining a Range Name Editing a Range Name Deleting a Range Name Moving Quickly to a Named Range Using Ranges in a ...
 

Microsoft Excel Level 1
Course Format: Classroom
Getting Started in Excel The Microsoft Excel Screen Layout Accessing Menus Personalised Menus Toolbars Working with Dialog Boxes About the Task Panes Accessing Different Task Panes in Excel 2002 and 2003 Moving Around the Worksheet Creating a Workbook Saving a Workbook with a Different Name Opening Workbooks Exiting Microsoft Excel Editing Worksheets Selecting Cells Entering Da...
 

Excel - Programming in VBA 2000/2002
Course Format: Classroom
Recorded Macros Recording a Simple Macro Running a Recorded Macro Relative Recording Running a Relative Recording Viewing the Module Modifying a Recorded Macro Recorder WorkShop Creating a Recorded Application Examining the Data Recording a Summation Macro Recording an Averaging Macro Recording the Maximum Macro Recording the Minimum Macro Recording Divisional Macros Testing Ma...
 

Page(s):- 1 2 3 4 5 6 7 8 9 10 11 12 [ Popular Topics ] [ Schools Only ]