Excel Level 1, 2 and 3 Training

Excel Level 1, 2 and 3 Training

Buying the lessons in this bundle saves you over 45% off the normal price!

These lessons have been written by OzGrid Business Applications who develop Excel spreadsheets on a professional basis. Each lesson is drawn from 'real world' experience and not made up class room scenarios. There are 30 lessons, each between 5 and 10 Word Document pages long, and 15 Workbook examples. There is also online Microsoft Pivot Table tutorial.

BASIC COURSE OUTLINE:

The Fundamentals of Excel, Cut, Copy, Insert, Delete, Paste Special, Custom Formatting, Undo, Redo, Excel Formulas - The least you should know, Useful functions and Paste Function, Calc, Comments, Drawing toolbar, Edit Replace, Delete Clear, Essential Printing, Data Sorting, Hiding, AutoFormats, Protection, Basic Charts, Basic Formatting, If Function

Excel Fundamentals, Worksheet Formulas, Specific Worksheet Formulas, Extract Data and Decision Making, Data Validation and External References, Advanced Filters, AutoFilters, Names Charts, Under Utilised Features, Protection, Shared Workbooks, Track Changes, Merging Shared Workbooks, Custom Views, Report Manager, Hyperlinks, Outlining

Advanced Formulas, Advanced Filters, Text To Columns, Importing Text Files Pivot Tables 1, Pivot Tables 2, Pivot Tables 3, Scenarios, Goal Seek, Data Tables and Consolidation, Excel on the WeB, Macros 1, Macros 2

WHY USE US FOR EXCEL TRAINING?

Like all our products and services, OzGrid training will cater to your specific needs. OzGrid specializes in Microsoft Excel, this is all we do! Over time we have focused our business directly towards Excel. Other training companies will offer training in many different Applications, and while they may supply information from good trainers it is very unlikely the trainers will know Excel to the extent we do! Remember we develop Excel spreadsheets in our day-to-day business so we know what you will encounter in your day-to-day use of Excel. We are not just Excel teachers, but al99.00

TorniaiSansUT Regular PC
TorniaiSansUT Regular PC

TorniaiSansUT LightItalic PC
TorniaiSansUT LightItalic PC

TorniaiSansUT Light PC
TorniaiSansUT Light PC

TorniaiSansUT Family PC
TorniaiSansUT Family PC

FinancePro
A Business budget and financial forecasting modeling to build a reliable forecasting reports more easily.

ForecastingTools Graph
ForecastingTools Graph provides the most Known and commonly used Forecasting methods for Marketing, Economics, Accounting, Operations Management.

ExcelSmartTools Auditor
ExcelSmartTools Auditor, was developed to help Microsoft Excel users audit and check spreadsheets models.

ExcelSmartTools Premium Edition
This Add-In adds and enhances Microsoft Excel commands and functions. Many improvements are great time-savings features for tedious and repetitive tasks.

Investment & Business Valuation
The Investment Valuation model by Excel Business Tools

Regression Business Plan Forecasting
The Multiple Regression Forecasting model by Excel Business Tools

Portfolio Optimization
The Portfolio Optimization model by Excel Business Tools

COMxL RS232C
Link a measuring instrument to YOUR Excel worksheet via RS232 port

Spreadsheet Assistant for Microsoft Excel
Save time in Microsoft Excel with the Spreadsheet Assistant.

Directory Lister for Microsoft Excel
The Directory Lister is like having the Windows Explorer inside Excel! Create lists of all the files in your directories, and open any file by clicking on it. Or just print the lists!

Sheet Navigataor for Microsoft Excel
The Sheet Navigator for Microsoft Excel makes moving from one worksheet to another extremely easy. With a single click, a list of all your worksheets is displayed for your selection.

Chart Assistant for Microsoft Excel
The Chart Assistant is a menu driven add-in for Microsoft Excel that makes creating hundreds of charts as simple as filling in several dialogs.

Analysis Collection for Microsoft Excel
Get two downloadable books on Excel macos, another on time saving solutions, and 19 time saving add-ins, including the Spreadsheet Assistant.

Data Assistant for Microsoft Excel
The Data Assistant for Microsoft Excel helps you get your data into Excel Pivot Tables the right way.

Filter Assistant for Microsoft Excel
The Filter Assistant for Microsoft Excel makes filtering data easy! And, it eliminates many of the annoying features of Excel's data filter feature.

Histogram Creator for Microsoft Excel
The Histogram Creator for Microsoft Excel makes creating presentation quality histograms easy. And, it gives you full control the bin size and step size for great looking output. The Histogram Creator is totally menu drive and very fast.