|
|
EXCEL ENHANCEMENT 2 – EXCEL TRAINING BIBLE – UNLIMITED LICENSE.
When you purchase our Excel Financial Collection Super Gold Edition from this site you get the Complete Excel Training Bible (all modules 101–201–301–401–501–601 & 701 as a free bonus. You can download all Courses or Get it on CD.
- Step by step training in all aspects of Excel spreadsheet development.
- Actual Excel training courses presented to classes.
- Unlimited licenses! Excel training modules that can be shared among all work colleagues.
- Impress your colleagues with your grasp and knowledge of Excel.
- Step by step development of Excel Macros to help automate repetitive tasks in Excel.
- Step by step training introduction to Excel VBA applications.
- Excel VBA codes ready to copy in to your Excel.
Unlimited license allows installation of the Training Courses into an unlimited number of Computers, and/or Networks within your organization. Ideal and VERY cost effective for corporate environments!
|
OUR PRICE ADVANTAGE. Regular price $120.95. Our price $119.40.
|
|
|
BEST VALUE BONUS SPECIAL OFFER* – BUY NOW – SAVE $60.00 WITH OUR COMBINED ADD-INS & EXCEL TRAINING BIBLE COLLECTION. Our price $178.80.
|
|
* Plus Free Bonus Excel Currency Database. Change any Excel list containing fx values in any mix of 80 different foreign currencies into your local currency instantly – In today's environment of volatile exchange rates, instant recalculations of multiple fx cost values into the current value of your home currency is an essential tool. Free bonus workbook with this Combined Collection. (The Free Bonus Excel Currency Database is also provided with our Excel Financial Super Gold Collection).
THE COMPLETE EXCEL TRAINING BIBLE – INDEX
Give these Excel Training 101 Lessons to all new starters in your team. Bring them up to speed quickly; they learn Excel basics in half the time.
Excel Training Module 101 introduce newcomers to Excel and remind older hands of the power of Excel working with Formulas and Functions. Easy to read in Microsoft Word step by step guide in English covering: > In depth all Formula and Function rules, what is meant by Cell Reference, Absolute and Relative cell references, using the AutoSum function, AutoCalculate rules, Nesting arguments (applying brackets), Syntax rules, Insert rules, Naming cell ranges (e.g. First Quarter, Sales Tax), Averaging, Counting, CountIf, SumIf, working with Text, using Constants, using the Paste Name dialog, calculation operators and references, adding cell comments, using find and replace, more effective printing options, Print range, Print What, Headers & Footers, Data Sorting, sorting alphanumeric text, single or multiple column sorting, Sorting numbers, Hiding and Unhiding rows and columns, creating Auto Formats, Charting options, formatting charts, charting options, cell protection options, explaining the If function and connecting arguments, correct use of brackets, using Volatile arguments, highlighting common problems with Dates and Times in Excel, interpreting Errors in Excel, suppressing errors, working with Add-Ins, more specific short cuts, working with the ABS, Address, Choose, DateValue, Lookups, Index, Indirect functions.
81 PAGES.
Excel Training Module 201 – Extracting information for Decision making.
The do's and don'ts of data and text tables for making decision presentations clearer. Step by step introduction to data tables and database functions using a real data mining example. Explaining Vlookup and Hlookup functions and Dfunctions. Data validation, List validation, Text validation. Auditing options. Working with external data and external references, importing external data and external formula. Working with Auto Filters, Advanced Filters, Tables and Lists guidelines, compound filtering, dealing with blanks, Names Ranges. Revealing little known features in Excel: Placeholders, Sections, Suppressing values, Comparison Operators, Leading zeros, how to best display symbols and currencies, how to separate joined up imported text fields into separate columns (will reduce 10 hours work to 5 minutes), how to use AutoFill, how to manage Custom Lists. Protecting and hiding formula: Protecting and sharing workbooks, tracking changes by users, highlighting changes, list changes, resolving conflicts with shared users, merging shared workbooks, protecting shared workbooks, Custom views, Report Manager, managing Hyperlinks, Outlining, organizing data by detail level (for example by departments, sales, products, etc), use MyBusinessBudget.xls as the working example.
80 PAGES.
Excel Training Module 301 – Working with Pivot Tables in Excel.
Course Outline: Explaining pivot tables – one of Excel's most useful features. Why Pivot Tables? Pivot table advantages, how to manage Pivot charting, Pivot table guidelines, step by step guide to creating pivot tables, working with pivot tables, format pivot table options, data options, drill down, Queries, work with Pivot Table1.xls example, Field options, Grouping Fields, Rules using Pivot Table Names, calculating fields, understanding possible errors in Pivot tables.
25 PAGES
Excel Training Module 401 – Working with What-If Analysis in Excel.
Developing financial scenarios and using Goal Seek to analyze complex computations. How to create default scenarios, adding scenarios and merging scenarios. Using Names in scenarios for short cuts, displaying scenarios, preparing summary reports.
12 PAGES.
Excel Training Module 501 – Working with Macros to automate tasks in Excel.
How to develop Macros to automate repetitive tasks in your Excel. Explaining Absolute and Relative cell addressing, recording Macros. Example: Step by step instructions to develop a macro that will consolidate financial data contained in separate spreadsheets.
13 PAGES.
Excel Training Module 601 – WORKING WITH EXCEL VBA 1
Course Outline: Explaining The Fundamentals of Excel VBA, The Visual Basic Editor, Objects and Properties. Step by step introduction to VBA Excel Objects , Object Hierarchy, Applications, Workbook, Worksheet, Range, Command Bars, Variables and Constants, Data types, Variable Levels, Declaring Variables, Constants, Loops, Types of Loops, Loop Pitfalls, Effective Decision Making, If/And/Or, Select Case, Dates and Times, Workbook and Worksheet Events, Debugging and Error Handling, Prevention, Good Habits, dealing with Runtime Errors, Excel Worksheet Functions in VBA, Specific Examples, Excels Built-In Features, User Defined Functions, Good vs Bad, Arguments, Calculation, Controls, ActiveX, Control Toolbox, Control Properties, Control Parent. Common Objects, Command Bars, Variables, Declaring variables, Constants, VBA codes for Message Box function, Input Box, Do While, Do Until, Effective Decision making with VBA, Excel and Dates VBA rules, Workbook Events, Debugging errors, Easy error handling, Specific examples of VBA code, Built in features, FilterMode, Advanced filter mode, User defined functions, Inputting into cells. Provided VBA codes for Controls Toolbox Toolbar, Control Properties, List Box properties, Text Box & Combo Box and much more.
109 PAGES.
Excel Training Module 701 – DEVELOPMENTS WITH THE EXCEL VBA USER INPUT FORM
Course Outline: Explaining the Excel VBA UserForm control to manage user inputs to your Excel spreadsheets.
69 PAGES.
Spreadsheet examples: Budget forecasting, Data tables consolidation 1–8 budgets, Goal Seeking, Pivot tables 1 & 2, Text to column tutorial.
|
