|
|
|---|---|
.JPG)
Training Catalogue
I’m not a big fan of the “Under Construction” convention, but in this case I’ll make an exception.
Starting Wednesday, June 02, 2011 and continuing as at Monday, September 19, 2011 I am retro-fitting all my current training documents to this web page. I seem to be able to process about half a dozen per day, in my Copious Free Time™.
If you would like to be informed when the task is complete, please Contact Me .
The majority of these units are TWO HOURS in length.
My experience attending courses as well as delivering courses is that
1 Two hours is the limit for any one topic, beyond which limit, attendees have absorbed as much as they can.
2 Most organizations have more than one item on their agenda; two-hour modules allow them to fit three modules into a full day’s training.
3 Many organizations now see the advantage of having a trainer in for one day, to take a series of groups of staff members through one topic, so that “Everyone in the organization is on the same page”.
4 Some organizations book an in-house training module with specific remedies in mind. A two-hour treatment of material can leave an hour (out of a half-day) to study the practical applications to real problems that face the attendees. Attendees bring their problems to the class, and we conduct a one-hour lab to solve those problems.
5 There’s more, but you get the idea ...
The table below totals over 470 hours of training.
Take advantage of this unique opportunity to upgrade your skills and those of your staff to make more profitable use of your resources.
Web Page |
Platform |
Hrs |
Description |
PDF version |
|---|---|---|---|---|
Access |
1 |
This module will provide participants with the skills they need to make use of existing Queries in Microsoft Access to build more informative queries.. We rarely make direct use of tabular data in Microsoft Access; our manipulative power comes from creating Queries that answer our needs. |
||
Access |
1 |
This module will provide participants with the skills they need to make use of existing Tables in Microsoft Access to build more informative queries.. We begin Queries by basing them on tabular data in Microsoft Access; our manipulative power comes from creating Queries that answer our needs. |
||
Access |
1 |
This module will provide participants with the skills they need to create basic reports and the knowledge required to create more complicated reports in the future. |
||
Access |
2 |
At the heart of any database are one or more tables. This module will provide participants with the skills they need to create a simple name and address table. It will serve as a model for all future tables. |
||
Access |
3 |
This module will provide participants with the skills they need to examine data bases and data base files, using the theme of data processing as our guide. First we examine the data, then the processing. By Processing Data we Generate Information - our goal in using a computer. |
||
Access |
2 |
This module will provide participants with the skills they need to Create, Use and Edit forms and the knowledge required to enhance their end-users data manipulation in the future. |
||
Access |
2 |
This module will provide participants with the skills they need to Load data to a table and to navigate, select and edit that data. |
||
Access |
2 |
This module will provide participants with the skills they need to Modify a simple table structure and the knowledge required to implement further modifications in the future. The beginner in Microsoft Access rarely has the experience to complete the definition of the stored data in one step. Being able to modify the original definition without disturbing the original data and queries based on that data takes some learned skill. |
||
Access |
2 |
This module will provide participants with the skills they need to Extract specific fields and data items from their mass of data, preparatory to creating reports. We begin Queries by basing them on tabular data in Microsoft Access; our manipulative power comes from creating Queries that answer our needs. |
||
Access |
3 |
This module will provide participants with the skills they need to understand and create Relational Databases. An organization’s data is, well, Organized (or should be!) into distinct groups of data. Our job is to determine and assemble the relationships between the different masses of data. |
||
Access |
2 |
This module will provide participants with the skills they need to make reports on their data and the knowledge required to enhance those reports in the future. The whole point about Processing Data is to obtain Information, and in Access that information most commonly appears in the form of a Report. |
||
Access |
3 |
This module will provide participants with a review of the skills they need to create and maintain databases. |
||
Access |
2 |
This module will provide participants with the skills they need to learn about and master Selection Criteria in terms of isolating useful packets of data from an Access database. |
||
Access |
3 |
This module will provide participants with the skills they need to develop a set of techniques to adapt or coerce incoming data to a manageable form and the knowledge required to in the future. Data arriving from an external source is often quite foreign to Access. Our goal is to generate clean data in an Access table. We don't aim to duplicate a complete system with all its structure and reports, but we'd like to be successful at obtaining data that is hidden within some other application. |
||
Excel |
1 |
This module will provide participants with the skills they need to apply conditional formatting to cells. Conditional formatting is a means of automating the laborious task of formatting dynamic results, and saves many hours of tedious work. |
||
Excel |
2 |
This module will provide participants with the skills they need to master the use of date, time, colour and conditional formatting. |
||
Excel |
3 |
This module will provide participants with the skills they need to make use of the various formula in the “array” category. We look at arrays of data and two specific examples of their use - the FREQUENCY function and the LARGE function |
||
Excel |
2 |
This module will provide participants with the skills they need to make use of the built-in basic functions in Microsoft Excel and the knowledge required to make better use of them in the future. |
||
Excel |
2 |
This module will provide participants with the skills they need to Understand and use the simplest analysis tools in Excel and the knowledge required to take in Advanced Data Analysis in the future. |
||
EXCEL |
1 |
This module will provide participants with the skills they need to take a problem through the paper-and-pencil stage of program design to the finished solution in Microsoft Excel. We differentiate between a skill called “Programming” and a language called “Visual Basic for Applications”. |
||
Excel |
2 |
This module will provide participants with the skills they need to Enhance simple charts to provide information about trends in their data and the knowledge required to produce more detailed analysis in the future. That last statement is double-edged; in a limited sense, trend analysis allows us to peer into the future. |
||
Excel |
3 |
This module will provide participants with the skills they need to create and manipulate charts and the knowledge required to enhance charts in the future. A chart, or graph, is a pictorial representation of a set of data. A chart is an object, and thus can be selected, moved, sized, deleted, copied, and so on. |
||
Excel |
2 |
This module will provide participants with skills to encode boring and repetitive Excel tasks to simple macros. In addition a brief introduction to the Visual basic Editor is presented to allow users to make simple changes to recorded macros. |
||
Excel |
2 |
This module will provide participants with skills to produce a variety of compound macros based on smaller building blocks. It is designed for users of Microsoft Excel or similar desktop programs who wish to upgrade their skills and knowledge to reduce the time spent solving computer problems and increase the time they spend solving client and customer problems. |
||
Excel |
3 |
This module will provide participants with the skills they need to build a chart, or graph, as a pictorial representation of a set of data, and the knowledge required to select, move, size, delete and copy chart objects. |
||
Excel |
3 |
This module will provide participants with the skills they need to Install and use the Data Analysis Toolpak and the knowledge required to use the Analysis ToolPak for complex statistical or engineering analysis in the future. |
||
Excel |
2 |
This module will provide participants with the skills they need to Capitalize on existing values and formulae and the knowledge required to improve the worksheet in the future. |
||
Excel |
1 |
This module will provide participants with the skills they need to understand and manage the Hierarchical Structure of Workbooks right down to the cell level. |
||
Excel |
2 |
This module will provide participants with the skills they need to Understand and manage the Data Content of workbooks at the cell level. |
||
Excel |
3 |
This module will provide participants with advanced skills in data entry and preparation for Microsoft Excel workbooks. In particular we examine why most basic courses teach the wrong method of data entry, and we look at special methods of pasting and worksheet cell protection. |
||
Excel |
2 |
This module will provide participants with data entry skills above and beyond those of simple keying-in-data. |
||
Excel |
3 |
This module will provide participants with the skills to drive Excel’s built-in data validation facilities. Data validation reduces the time taken to input data correctly in a manner that satisfies the host application or macro. |
||
Excel |
3 |
This module will provide participants with the skills they need to implement a wide variety of data validation functions to their workbooks, and the knowledge required to extend these skills in the future. |
||
Excel |
3 |
This module will provide participants with the skills they need to validate user-input data like a professional and the knowledge required to reduce data-stream errors in the future. |
||
Excel |
1 |
This module will provide participants with the skills they need to Understand the Difference between Stored and Display Formats. |
||
Excel |
3 |
This module will provide participants with the skills they need to become proficient in the use of graphical objects in the spreadsheet. In particular we take a first look at transferring and editing images between various parts of a Microsoft Excel application, such as toolbar buttons and charts. |
||
Excel |
3 |
This module will provide participants with the skills they need to choose the best chart type is critical to illustrating their worksheet data and the knowledge required to provide better graphic information in the future. Those reading your chart need to be able to rapidly decipher what your chart represents. The column chart, by far, is the easiest chart for people to read (which is why it is the default chart type). However, depending on what you are plotting, another chart type might be more appropriate. |
||
Excel |
3 |
This module will provide participants with the skills they need to produce consistently-formatted worksheets at less cost than the traditional method of formatting and the knowledge required to migrate these savings to other applications in the future. |
||
Excel |
1 |
This module will provide participants with the skills they need to Transfer existing file skills to the Excel environment. |
||
Excel |
3 |
This module will provide participants with the professional skills they need to implement complex formulas in their worksheets. In particular we show how professionals generate formulas that work the first time, along with some tips’n’tricks that are not promoted by the large downtown corporations. |
||
Excel |
2 |
This module will provide participants with the skills they need to Use the underlying functions to produce new data. |
||
Excel |
3 |
This module will provide participants with the real world skills they need to build and maintain existing systems that use large worksheets and large workbooks. Classroom exercises typically involve half a dozen rows and columns of data. Real life rarely has small areas; real life usually involves budget spreadsheets with 24 columns of months, and hundreds of rows of item data. |
||
Excel |
2 |
This module will provide participants with the ability to hook their recorded macros up to the Keyboard as shortcut key combinations, and as buttons on the Toolbars. |
||
Excel |
1 |
Given a sheet of data we need to clean it up and then form subtotals. This module will provide participants with the skills they need to prepare a spreadsheet for sub-totaling and generate sub-total tables on existing data. |
||
Excel |
1 |
This module will provide participants with the skills they need to Create multi-workbook formulae, and formulae that link multiple worksheets within a workbook. While multi-worksheet and multi-workbook formulae represent powerful information gathering techniques, their implementation is really quite easy. |
||
Excel |
2 |
This module will provide participants with the skills they need to remove the dependency on literal cell references and make use of meaningful names to navigate around spreadsheets, workbooks, and to generate human-readable formulas. |
||
Excel |
1 |
This module will provide participants with the skills they need to Use primitive difference tables to analyze raw data, and the knowledge required to expand their use of Numerical Analysis in the future. |
||
Excel |
3 |
This module will provide participants with the basic techniques of setting up a print run. In particular, attendees will learn to use built-in features of Microsoft Excel to better serve those who read the worksheet reports. |
||
Excel |
1 |
This module will provide participants with the skills they need to Paste Special - Formats & Values. The use of the mouse to paste the contents of the clipboard in Excel is deplored; the use of the menu command "paste Special" is far superior to the menu command "Paste". |
||
Excel |
1 |
This module will provide participants with the skills they need to perform intermediate print runs and the knowledge required to advance to expert print runs in the future. |
||
Excel |
3 |
This module will provide participants with the skills they need to manipulate the printer and to economize on paper. In particular we show a better method of previewing a spreadsheet report to make sure it satisfies our requirements before we commit it to paper or email. |
||
Excel |
3 |
This module will provide participants with the skills they need to implement Microsoft Excel workbook protection using built-in features of Microsoft Excel. We pay attention to protecting the users from allowing simple mistakes to accumulate into disasters. |
||
Excel |
2 |
This module will introduce participants to the built-in and extremely useful shortcut key combinations unique to Excel and will lay the groundwork for assignation of shortcut keys to the end-user’s recorded macros. |
||
Excel |
3 |
This module will provide participants with the skills they need to Reduce Errors and save time by mastering the most essential short keys for Excel commands. Shortcut keys are part of the philosophy that “9 Times Out of 10, the Keyboard is Faster”. An established repertoire of shortcut keys gets the job done and frees up the intelligent mind to focus on real problems. |
||
Excel |
1 |
This module provides participants with the skills they need to apply simple sorting strategies to existing data. |
||
Excel |
1 |
This module will provide participants with the skills they need to examine the structure of a workbook file. Only after we understand the structure should we turn our attention to the content. |
||
Excel |
1 |
This module will provide participants with the skills they need to modify their Spreadsheet File Structure. |
||
Excel |
2 |
This module will provide participants with the skills they need to Create and use Workbook templates. |
||
Excel |
3 |
This module will provide participants with original and elementary skills to Record Macros in Excel. We pay especial emphasis on relative and absolute addressing in recorded macros, and the reasons for each mode. |
||
Excel |
2 |
This module will provide participants with the professional skills they need to navigate and select around the workbook. If you have ever been frustrated by disabled or “grayed-out” menus and options, this module is for you. |
||
Excel |
1 |
This module will provide participants with the skills they need to Make use of and changes to the standard toolbars and the knowledge required to manipulate toolbars in the future. |
||
Excel |
2 |
This module will provide participants with the skills they need to Make use of each major section of the Analysis ToolPak and the knowledge required to explore the Analysis ToolPak in the future. |
||
Excel |
3 |
This module will provide participants with the skills they need to design and write user functions that complement Microsoft Excel’s built-in repertoire. The module will be of particular appeal to those who spend time creating complex formulas in Microsoft Excel. |
||
Excel |
3 |
This module will provide participants with the skills they need to make better use of Microsoft Excel by mastering the built-in tools that serve spreadsheet developers. |
||
Excel |
1 |
This module will provide participants with the skills they need to improve their File Management skills in Excel, and make better use of their Workbooks in the future. File Management in Excel is similar to all other Windows applications. |
||
Excel VBA |
2 |
This module will provide participants with the skills they need to implement a times auto-save facility in Excel. In particular we introduce the concept of making periodic saved copies of one’s developing work, or of continuing data-entry. |
||
Excel VBA |
3 |
This module will provide participants with the skills they need to record and play-back macros in Microsoft Excel and the knowledge required to expand their VBA skills in the future. A macro is a recorded set of keystrokes. If we can do it with the keyboard, we can record the steps for future use. |
||
ExcelVBA |
1 |
This module is a parallel with the corresponding module from Excel. Here we translate our Excel cell-formula skills into a user-defined VBA function. We introduce the use of regular Excel worksheets functions as tools within Excel VBA. |
||
ExcelVBA |
3 |
This module will provide participants with the skills they need to understand basic de-bugging techniques in Excel VBA. We learn how to step-through procedures and how to check on interim calculated values as we go. |
||
ExcelVBA |
3 |
Highlight all cells containing hyperlink in a sheet Importing To Excel From Text Files Rich controls Built-in Dialogues |
||
ExcelVBA |
3 |
This module will provide participants with the skills they need to begin building libraries of utility code in Excel VBA. Libraries of pre-tested code mean faster development of error-free applications. But the main value lies in standardization of the user interface and experience. |
||
ExcelVBA |
3 |
This module will provide participants with the skills they need to change the formatting in a single cells and across a range of cells. In particular we introduce the three most important concepts for Excel VBA control: With/End; For/next and If/then/Else. |
||
ExcelVBA |
2 |
This module will introduce participants to the business of writing user-defined functions for use in Excel Worksheets. User-defined functions greatly expand Excel’s versatility by supplying end-users with functions designed to solve their specific corporate problems. In particular we introduce two functions – aimed at counting characters in strings – and the concepts of looping control with While/Wend and For/Next. |
||
ExcelVBA |
2 |
This module will augment the skills attendees need in programming for ranges in Excel/VBA. We cover end-user objects like the Active cell and Used Range, and we pay especial attention to the use of the .Offset method of the Range object. |
||
ExcelVBA |
2 |
This module will provide participants with the skills they need to use a variety of user-defined and application-defined ranges in Excel VBA. In particular we introduce the important concepts for Excel VBA programmers – that of program code that works regardless of the data area in use by the end-user. |
||
ExcelVBA |
0.5 |
This module will provide participants with the skills they need to experiment with cloning recorded macros. In particular we take something as simple as selecting a block of cells and move forwards, through the recorded code, through the VBA help files, to clone a macro which will select Blank cells. |
||
ExcelVBA |
2 |
This module provides participants with an overview and a solid foundation of how Visual basic works. We introduce the important concepts for VBA programmers who wish to control the actions of Microsoft Office Applications in readiness for the end-user’s experience. |
||
ExcelVBA |
2 |
First The Shortcut Key: Next The Toolbar. Create A User Toolbar Interface Assign Our User Macro To The Button Creating A Menu Tree |
||
PowerPoint |
2 |
This module will provide participants with the skills they need to the sheets received by the audience, before, during or after the presentation and the knowledge required to enhance their handouts in the future. |
||
PowerPoint |
2 |
This module will provide participants with the skills they need to make careful use of graphic elements which can focus the audience's attention on the message. We use the mouse and the drawing toolbar to create graphic objects. |
||
PowerPoint |
2 |
PowerPoint text functions much as it does in every other Windows applications. The skills of navigation and selection apply here, as do the techniques of typeface, size, colour, and so on. This module will provide participants with the skills they need to master those aspects of text manipulation that are unique to PowerPoint. |
||
PowerPoint |
2 |
This module will provide participants with the skills they need to Put the final touches to a Presentation. We will build a complete presentation from an existing Microsoft Word outline document. |
||
PowerPoint |
3 |
This module will provide participants with the skills they need to understand how PowerPoint helps to control the look of slides — with design templates, masters, color schemes, and slide layouts. |
||
PowerPoint |
1 |
This module will provide participants with the skills they need to apply Options In Preparation Of A Slide Show. |
||
PowerPoint |
3 |
This module will provide participants with the skills they need to create slides, notes and handouts for a presentation and the knowledge required to in the future. PowerPoint is a program that assist in creating slides, notes and handouts for a presentation. PowerPoint lets us create one file that has all the material tied together. The text that appears in the slides is the same text (no duplication!) that appears in the handouts. |
||
PowerPoint |
2 |
This module will provide participants with the skills they need to Establish basic skills in handling objects in the PowerPoint presentation. |
||
PowerPoint |
2 |
This module will provide participants with the skills they need to make use of powerful shortcut keys and methods to create Presentations and the knowledge required to improve presentations in the future. |
||
PowerPoint |
2 |
This module will provide participants with the skills they need to build a complete presentation from an existing Word outline document. This supposes that you know how to use Word in Outline mode. |
||
PowerPoint |
1 |
This module will provide participants with the skills they need to Set options suited to general tasks in PowerPoint. |
||
PowerPoint |
2 |
This module will provide participants with the skills they need to and the knowledge required to in the future. |
||
PowerPoint |
2 |
This module will provide participants with the skills they need to create a template with a customized slide, and paste as many copies of that slide as required. The layouts of slides greatly affect the initial one-second acceptance or rejection of a presentation. |
||
PowerPoint |
2 |
This module will provide participants with the skills they need, once their slides are prepared, to step back and organize the delivery of the slides. |
||
PowerPoint |
2 |
This module will provide participants with the understanding of where Templates and Masters fit into the scheme of Presentations. We cover all the basics of Templates, Masters and Styles (of course!) |
||
PowerPoint |
2 |
This module will provide participants with the skills they need to navigate and select items like professionals. A great many one-day public training courses provide the bare minimum of skills that relieve you of staring numbly at a monitor screen. |
||
PowerPointVBA |
1 |
This module will provide participants with the skills they need to begin using speech synthesis to make mechanical voices issue from slides! In particular we show how to select an appropriate tone of voice for the speech, and even how to “speak” the text backwards! |
||
PowerPointVBA |
2 |
This module will provide participants with the skills they need to implement a Paste Special command in PowerPoint. The Paste Special command is not available within the Microsoft PowerPoint object model. To emulate a Paste Special command, we use an object model, such as the Microsoft Word object model, that supports the Paste Special command. |
||
VBA |
2 |
By the end of this segment you will have developed a GUI form. This form, developed completely within Excel VBA, can be exported, then imported for immediate use in Word VBA – a powerful example of the mobility of your new skills. |
||
VBA |
1 |
This module will provide participants with the skills they need to understand some basic file mechanisms in Word, Excel and PowerPoint. We examine typical failings in recorded macros and show a common method for overcoming these failings. |
||
VBA |
1 |
This module will provide participants with a foundation for understanding why a range method is preferable to a selection method. We base our work on acknowledged experts in the field stretching as far back as Edsger Dijkstra’s classic paper “GoTo Considered Harmful” . |
||
VBA |
1 |
This module will provide participants with the skills they need to begin manipulating string arrays. In particular we introduce the Lower- and Upper-bound functions and the concept of Rank of an array. |
||
VBA |
2 |
This module will provide participants with a starting kit for dealing with arrays in Microsoft VBA. In particular we introduce the important LBound and UBound functions and explore arrays of higher dimensions. |
||
VBA |
3 |
This module will provide participants with the skills they need to plan a structured approach to data entry. We introduce the most important concepts of data validation in groups which leads to faster assimilation. |
||
VBA |
2 |
This module will provide participants with a foundation for sound programming skills as practiced by professionals. In particular we stress the need for readable code that adheres to a standard. |
||
VBA |
2 |
This module will provide participants with the skills they need start off on the right foot and begin building robust and acceptable code modules. In particular we introduce the five most important concepts for VBA programmers – all centered on thinking of the end-user’s needs. |
||
VBA |
2 |
This module will provide participants with the skills they need to build a general-purpose Alert box, which can be implemented in several applications. In particular we introduce the concept of user-friendly approaches to computing, making our interface pleasing to the client. |
||
VBA |
6 |
This module will provide participants with the skills they need to make extensive use of Class Modules in VBA In particular we introduce Properties and Methods for our own (developer-defined) objects and gain a greater understanding of these facets of VBA in the supplied objects. |
||
VBA |
2 |
This module will provide participants with an introduction to Collections of objects in VBA. In particular we introduce the means of examining each member of a collection, then ask participants to discover new collections and explore them. |
||
VBA |
0.5 |
This short module provides participants with an example of how to make GUI forms look more attractive and professional. The module is designed for users who wish to expand their macro skills to a professional standard; the material is applicable to all versions of Visual Basic and all Microsoft Office VBA implementations. |
||
VBA |
1 |
This module will show participants how to configure the Visual Basic Editor in a way that provides the developer with the maximum assistance for the least work. In particular we explain WHY we set the environment the way we do, and how the settings reduces errors and saves time. |
||
VBA |
1 |
This module will provide participants with the skills they need to make proper use of variable declarations. Microsoft VBA allows the programmer great latitude in declaring variables (or even NOT declaring them!), but we stress good programming practices as a means of reducing undetected errors. |
||
VBA |
2 |
This module will provide participants with the skills they need to define custom Class Structures with Properties and Methods. We show that a class structure contains all the versatility of a Type structure, and then adds the ability to write program code within the class structure. |
||
VBA |
1 |
This module will provide participants with the skills they need to begin using the TYPE statement and define data structures within their applications. In particular we use the basic data types to build complex structures, such as an email message object. |
||
VBA |
2 |
Custom devices Payne consulting API tool kit Woody’s Lounge MS knowledge base VBA help files Exchange of library code Mentor |
||
VBA |
1 |
This module will provide participants with an explanation of the two terms for binding, and a foundation for decision-making as to which to use. In particular we show the most immediate effect on the programmer of early binding during the development phase. |
||
VBA |
2 |
This module provides participants with a solid foundation for decision-making during the programming task. In particular we dispel some myths surrounding efficiency after clarifying the meaning of the term. |
||
VBA |
1 |
This module will provide participants with the skills to suspend operation of an application for a pre-specified time. While the need for such a handler is rare, it does provide a vehicle for embracing wider aspects of Application development in VBA. In particular we some new and important methods of adapting code to make a general-purpose utility. |
||
VBA |
2 |
This module will provide participants with auxiliary skills to enhance the experience for the end-user with additional controls on a GUI form. We start by introducing the Calendar, Sounds and Speech controls, then extend this knowledge to explore other controls. Every VBA programmer should be aware of the powerful high-level tools available to promote rapid assembly of applications. |
||
VBA |
2 |
This module will provide participants with the skills they need to develop a GUI form. This GUI form, developed completely within Excel, can be exported, then imported for immediate use in Word VBA – a powerful example of the mobility of new skills. In particular we introduce controls such as List Boxes which increase the accuracy of the input data generated for us by the end-user. |
||
VBA |
3 |
This module will provide participants with the skills they need to begin breaking down large and cumbersome procedures into manageable chunks, and begin along the path towards creation of libraries of VBA code. In particular we introduce the most important concept for VBA programmers – that small procedures always work the first time, and that large procedures never do. |
||
VBA |
3 |
An Introduction to Hungarian Variable tags Collection Tags Constants Naming Parameters Naming Labels Prefixes Suffixes |
||
VBA |
2 |
We explore the use of error trapping in Word VBA; specifically we examine the On Error statement and its clan. In particular we suggest that On Error is grossly over-used and hence mis-used, and show ways to avoid its use in the future. |
||
VBA |
6 |
This full-day module will provide participants with skills they need to rehabilitate old projects (often bequeathed to them!) In particular we introduce almost two dozen concepts that help to make sense and order out of chaos and errors. |
||
VBA |
2 |
This module will provide participants with extra skills to boost their application of Regular Expressions. In this adjunct to the training module for regular Expressions we explore the power of Patterns in greater detail. |
||
VBA |
2 |
This module will provide participants with the skills to preserve data between successive sessions of use of their application. In particular we introduce the two most common ways of preserving run-time data across a re-boot event. Time permitting we will also demonstrate the use of a utility library for Word/VBA which greatly facilitates the development of customized parameters for an application. |
||
VBA |
2 |
This module will provide participants with a solid introduction to the argument list for a procedural function in VBA. Most users begin with simple string or long parameters. Now we show how to extend the power and accuracy of modules built, as they should be, from procedural building blocks by a suitable definition of the parameter variables. |
||
VBA |
1 |
This module will provide participants with the skills they need to master the mechanism of looping through a range of cells in an Excel worksheet. We introduce the distinction between the value of a cell and the address of a cell. We inspect some properties of cells. |
||
VBA |
0.5 |
This module will provide participants with the skills they need to begin making use of Microsoft’s text-to-speech synthesizer. In particular we introduce the five most important concepts for VBA programmers – all centered on thinking of the end-user’s needs. |
||
VBA |
2 |
This module will provide participants with answers to the most common questions that plague the beginner VBA programmer in Word/VBA, Excel/VBA and all other VBA implementations in Microsoft Office. We introduce some time-saving techniques to assist the VBA developer. |
||
VBA |
2 |
This module will provide participants with a solid foundation in the release and maintenance of end-user applications. In particular we introduce a Microsoft Word/VBA method of remote installation of Application templates and a useful naming convention. |
||
VBA |
1 |
This module will provide participants with the skills they need to begin checking user input to a data stream. In particular we introduce the idea of writing a user-defined Excel function to check validity of a date being entered into a regular data cell. |
||
VBA |
2 |
By the end of this segment you will have learned how to scroll windows within desktop applications such as Excel and Word. In particular, you will learn how to make all open Windows leap simultaneously to the same position, for example, all to the top, all to the bottom, or all to the same point partway through. |
||
VBA |
2 |
This module will provide participants with the boost they need to establish practices in VBA that will reduce development time and produce maintainable code. In particular we introduce the concepts that are rarely placed before VBA programmers – but which are essential to good programming. |
||
VBA |
2 |
This module will provide participants with the skills they need to start using Structures and the general-purpose-receptacles known in VBA as Dictionaries. In particular we introduce Class Modules and events applicable to dictionaries. |
||
VBA |
2 |
This module will provide participants with the skills to begin to make use of ranges of cells in a most productive manner. In particular we introduce the R1C1 for of cell addressing and develop macros to sum across the feet of columns and the ends of rows of numeric data. |
||
VBA |
2 |
This module will provide participants with the skills they need to build a fully-functional GUI form and begin code modules that validate input data.. In particular we introduce the concept of transportable code by demonstrating our ability to move the GUI form – unchanged – between Microsoft Word and Microsoft Excel. |
||
VBA |
2 |
This module provides participants with skills in navigating and making use of the Visual Basic Editor. In particular we tour the two common code repositories for Microsoft Word and Excel and make use of the two most useful panes in the VBE. |
||
VBA |
2 |
This module will provide participants with the skills they need to begin producing tree-based interfaces for their users. This skill will be of particular interest to anyone who programs within a hierarchical environment, whether it be people or program procedures! |
||
VBA |
2 |
This module will show participants how to improve the user-experience and by doing so reduce errors in the use of their application. We introduce some design techniques and show how to implement them in the developer’s environment to increase system response to the end-user’s needs. |
||
VBA |
3 |
String Functions Date and Time Functions Information Functions String Utility Functions – Stripping Characters String Utility Functions – Parsing Strings Channel Utility Functions – Document Variables In Excel |
||
VBA |
1 |
This module centers on a discussion and exploration of development-speeding shortcut keys in the Visual Basic Environment. For most attendees, this will also be an essential introduction to the machinery behind the VBE, with the bonus that the shortcut keys presented here work in every Microsoft office application’s Visual Basic Environment. |
||
VBA |
2 |
This module will provide participants with booster methods for more effective VBA – faster, error-free coding. In particular we introduce settings in the Visual basic Editor that help guide the programmer into safe programming techniques. |
||
VBA |
2 |
This module will provide participants with essential skills for the VBA developer, applicable across all Microsoft office applications. In particular we look at the VB environment, some programming techniques, and how to keep track of what was going on just before the program crashed! |
||
VBA |
3 |
This module will provide participants with the skills they need to save data in a regular text file. In particular we introduce the concept of how to save data from your application into a text file. You will learn how to start a new file, and how to append data to an existing file. |
||
Windows |
1 |
This short module will introduce participants to the 12 most commonly used keystrokes employed by professionals. If you don’t have time for “16 Absolutely Essential Key Strokes” then this module is for you! |
||
Windows |
2 |
This short module will introduce participants to the 16 most commonly used keystrokes employed by professionals. |
||
Windows |
3 |
This module will provide participants with the skills they need to manage their files and make the best use of Windows as a filing cabinet. File Management - Never lose that file again! |
||
Windows |
2 |
This module will provide participants with the skills they need to understand the guiding philosophy behind the efficient use of Microsoft Windows. The module is designed for users of Microsoft Windows. It will provide a solid foundation for work in all Windows-based desktop applications. |
||
Windows |
2 |
This module will provide participants with the skills they need to recognize and eliminate major causes of slowdowns in their Windows-based computer systems. |
||
Windows |
3 |
This module will provide participants with an immediate 90% increase in productivity through better use of Windows facilities. Move beyond the single-task, slow-application mentality into the realm of Power User. |
||
Windows |
3 |
This module will provide participants with skills to start using Windows as professionals, that is, telling Windows what to do rather than react to Windows’ prompts and messages. |
||
Windows |
3 |
Attendees will learn how to make use of many built-in features of Windows to speed up and simplify their work of locating and managing critical files. |
||
Word |
3 |
This module will provide participants with the skills they need to Enhance a document with user-friendly information. |
||
Word |
2 |
This module will provide participants with the skills they need to Exercise control over the generation of Auto text entries. Auto text can be a very powerful element of well planned Word environment for a law firm or other large organization. Frequently used names and phrases, letterhead mastheads, office addresses, logos, signature blocks, court captions and notarization paragraphs are just some of the types of material that can be stored as Auto text and should be maintained in standard text and format throughout the organization. |
||
Word |
2 |
This module will provide participants with a set of extremely common and therefore frequently useful shortcut keystrokes,. If you don’t have the time to remember every shortcut, grab this minimal set and start enjoying Microsoft Word. What qualifies these keyboard shortcuts to be the best? Two things: they are easy to remember, and they are generally useful. Generally useful means that you'll use them in every Microsoft Word session. |
||
Word |
3 |
This module will provide participants with the skills they need to reduce the incidence of disastrous results to a Microsoft Word editing session. Most common problems in Microsoft Word can be avoided by following practices that have been developed and proven over the years. |
||
Word |
1 |
This module will provide participants with the skills they need to create, use and modify Character styles. Character styles are preferable to Text attributes. For that reason we present them before text attributes in the fond hopes that you will be successful in your work. |
||
Word |
2 |
This module will provide participants with the skills they need to use and maintain columns of text in a Microsoft Word document. In this module we will use section breaks to control the number of columns in a document. |
||
Word |
2 |
This module will provide participants with the skills they need to record and run command macros in Microsoft Word. |
||
Word |
0 |
Here is a list of hot keys in Word. |
||
Word |
1 |
This module will provide participants with the skills they need to build complex macros out of micro-macro building blocks. The module is designed for users of Microsoft Word or similar programs who wish to upgrade their skills and knowledge to reduce the time spent solving computer problems and increase the time they spend solving client and customer problems. |
||
Word |
3 |
This module will provide participants with the skills they need to reduce large documents to a manageable size and the knowledge required to avoid the problems of large documents in the future. |
||
Word |
2 |
This module will provide participants with the skills they need to build templates of boilerplate text. Templates For Text is a sound principle. The template on which a document is based can reduce the amount of work needed to produce a document. Many basic techniques work to make the experience pleasurable and profitable. |
||
Word |
2 |
This module will provide participants with the skills they need to cope with strange strings in their documents and the knowledge required to manage teams of collaborative editors in their organization. |
||
Word |
2 |
This module will provide participants with the skills they need to customize the Microsoft Word environment to support their regular daily use of Microsoft Word and the knowledge required to enhance their working environment in the future. We lay special emphasis on reducing the motor-movements of the body and increasing the use of the eye-brain combination as a more efficient way of working. |
||
Word |
2 |
This module will provide participants with the skills they need to fix basic problems that arise in the operation of Microsoft Word the knowledge required to diagnose problems in the future. |
||
Word |
3 |
In this module we look at the creation of tables, conversion between text and tables, and linking table data from the Access database system. We perform a mail-merge. |
||
Word |
1 |
This module will provide participants with the variety of powerful skills they need to delete text, using the keyboard and using the mouse. |
||
Word |
2 |
This module will provide participants with the skills they need to speed up their text entry into document, and to reduce the time spent dealing with Microsoft Word’s spell-checker. |
||
Word |
4 |
This module will provide participants with the skills they need to automate their production and delivery of text, reducing a typical job from 60 minutes to half an hour. Field codes permit us to place run-time variable data within a document; Macros lift the burden of boring, repetitive tasks from our hands; Forms provide pre-configured documents, in which we type new data; AutoText permits us to take welcome shortcuts during the Keying-in part of our work day. |
||
Word |
3 |
This module will provide participants with the skills they need to learn and use the different types of, and parts of, basic Microsoft Word documents. We pay especial attention to the decision-making process before a document is begun, to make sure we start off on the correct path. |
||
Word |
3 |
This module will provide participants with the basics of inserting and managing collections of pictorial images, and the knowledge required to manipulate and control the various sources of images. |
||
Word |
1 |
This module will provide participants with the skills they need to edit and maintain their simple text macros. The module is designed for users of Microsoft Word who wish to continue their path of development in Visual basic for Applications, |
||
Word |
2 |
This module will provide participants with the skills they need to make detailed changes to the image and text associated with Toolbar Buttons in Microsoft Word. |
||
Word |
3 |
This module will provide participants with the skills they need to make use of Microsoft Word’s field codes and the knowledge required to implement features of document automation. |
||
Word |
3 |
This module will provide participants with the skills they need to perform various translations of documents into and out of Microsoft Word. |
||
Word |
3 |
This module will provide participants with the skills they need to use professional techniques of find-and-replace |
||
Word |
2 |
This module will provide participants with the skills they need to recover a large (typically over 1 megabyte) corrupted document. We pay especial attention to the use of navigation and selection keys to trap the corruption and rescue our investment of time and money in the corrupted document. |
||
Word |
2 |
This module will provide participants with the skills they need to manipulate objects, using frames as our vehicle. Then we will look in more detail at pictures (as framed objects) and graphic text (as framed objects). We can insert graphic objects, such as pictures and graphic text, into our documents for reader impact. |
||
Word |
1 |
This module will provide participants with the skills they need to reduce the incidence of split lines of text, and the knowledge required to avoid the problem in the future. |
||
Word |
3 |
In this module we introduce data from applications other than Microsoft Word. In particular we will look at bringing spreadsheet data into Word. |
||
Word |
1 |
This module will provide participants with the skills they need to build macros attached to shortcut keystrokes. Keyboard macros are super-fast solutions to one-off problems of a boring and repetitive task. There is no need to learn VBA to achieve powerful calculations and conditional text entry within a document. |
||
Word |
2 |
This module will provide participants with Tips'n'Tricks for recovering "lost" text. |
||
Word |
3 |
This module will provide participants with the skills they need to make better use of template facilities to drive document production. |
||
Word |
2 |
This module will provide participants with the skills they need to understand how Master Documents are supposed to work. Warning: I have yet to find a version of Microsoft Word in which master Documents work. Most experts caution against using the Master Document feature. These notes are supplied to help you understand Master Documents should you inherit such a beast. |
||
Word |
1 |
This module will provide participants with a miscellaneous but extremely useful set of skills. |
||
Word |
1 |
This module will provide participants with the skills they need reuse existing text by super-efficient means of moving and copying text. Re-using typed text makes more sense than re-typing the text. |
||
Word |
2 |
This module will provide participants with the skills they need to those awkward things that refuse to lie down straight and the knowledge required to avoid such problems in the future. |
||
Word |
2 |
This module will provide participants with the skills they need Master skills in navigating to and selecting text. |
||
Word |
3 |
This module will provide participants with the skills to assign numbers to paragraphs. This session will introduce you to the basic scheme behind numbering. There is much more to be learned, but here is the Good Foundation. |
||
Word |
2 |
This module will provide participants with the skills they need to Explore and set the essential options in Microsoft Word and the knowledge required to improve their interface in the future. |
||
Word |
3 |
Outline Processing is a sound practice for document development. Without a skeleton or structure, the body will be poorly-formed. Outline Processing is the fastest way to develop ideas into a complete and well-formatted document. |
||
Word |
2 |
This module will provide participants with the skills they need to understand and use Page Numbering. Page numbering can be controlled with Sections. In this session we will use section breaks to control Page Numbering, then we will resurrect a broken document by proper application of section breaks. |
||
Word |
1 |
This module will provide participants with the skills they need to use, create and modify paragraph styles in Microsoft Word. |
||
Word |
2 |
This module will provide participants with the skills they need to use a variety of channels of assistance, both off-line and on-line. |
||
Word |
1 |
This module will introduce participants to a table of useful shortcut keys as a time-saving device. |
||
Word |
1 |
This module will provide participants with the skills they need to edit the dictionary and how to customize automatic text generation features. |
||
Word |
2 |
This module will provide participants with the skills they need to understand relationships amongst both Paragraph and Character styles. For each type we recommend that you sketch out a hierarchy of styles on paper before committing your ideas to the computer. |
||
Word |
6 |
Here we introduce you to the use of existing styles, and their modification for your own local purposes. Paragraph styles are preferable to Text attributes. For that reason we present them before text attributes in the fond hopes that you will be successful in your work. The creation, maintenance and management of paragraph styles is well worth a full day course. In particular, note that the creation of list-numbered styles is a topic in itself. |
||
Word |
2 |
This module will provide participants with the skills they need to create and maintain the structure, content and layout of tables. |
||
Word |
2 |
This module will provide participants with the skills they need to Understand the need for and the use of template files and the knowledge required to create and maintain templates in the future. |
||
Word |
3 |
This module provides the Microsoft Word user with an understanding of why things go wrong, and suggests some solutions for trouble-free word-processing. We pay particular attention to the impact of our template strategy on our work. and the knowledge required to avoid problems in the future. |
||
Word |
3 |
This module will provide participants with the skills they need to understand Templates and Document Structure. |
||
Word |
3 |
This course shows you how to create a template from scratch. Reference is made to more detailed training modules for some sections, but we do cover all the basics here. If you think that you might benefit from a custom template, this course is for you. |
||
Word |
1 |
This module will provide participants with the skills they need to learn the various time-saving techniques of text entry; it’s not about typing speed! This is the "Keying in" part of life. In this course we examine the different means of entering text into the document, we are not concerned with your typing speed. |
||
Word |
1 |
This module will provide participants with the skills they need to record and playback (or “Run”) simple text-generating macros. This is the first step along the path to macro development, and provides an easy introduction to the whole idea of eliminating boring and repetitive tasks from the daily grind. |
||
Word |
2 |
A great many one-day public training courses provide the bare minimum of skills that relieve you of staring numbly at a monitor screen. In this session we will teach you how to fly. |
||
Word |
3 |
This module will provide participants with the skills they need to build and maintain toolbars, toolbar menus and toolbar macro buttons in Microsoft Word. |
||
Word |
2 |
This module will provide participants with the skills they need to establish control over changes to documents in Team Collaboration and in isolation. In today’s mobile world more and more users find themselves working on a dispersed team, or working from several physical locations. |
||
Word |
2 |
This module will provide participants with the skills they need to understand Templates And Document Structure, especially the relationship of the template Normal.dot to everyday work with Microsoft Word. |
||
Word |
3 |
This module will provide participants with the skills they need to Gain Mastery over common problems and annoyances and the knowledge required to in the future. |
||
Word |
3 |
This module will provide participants with the skills they need to locate and destroy incriminating evidence and the knowledge required to reduce it in the future. |
||
Word |
6 |
This module will provide participants with the skills they need to understand and fix the most basic problems in tour errant Microsoft Word documents. |
||
Word |
3 |
This module will provide participants with the skills they need to make better use of Microsoft Word by mastering the built-in tools that serve document developers. |
||
Word |
2 |
This module will provide participants with the skills they need to Make use of the Word Startup Switches and the knowledge required to take better control of Microsoft Word in the future. |
||
Word |
2 |
This module will provide participants with the skills they need to understand how graphics work in Microsoft Word and the knowledge required to create graphics in a correct manner in the future. |
||
Word |
3 |
This module will provide participants with the skills they need to share their work with other team members and the knowledge required to expand their collaboration skills in the future. |
||
Word VBA |
2 |
This module will provide participants with the skills they need to implement a simple procedure for the extraction of key words from any text. While particularly suitable to Microsoft Word processing applications, we can use this code to extract text from any source from within any Microsoft application that supports VBA. |
||
Word VBA |
3 |
This module will provide participants with the skills they need to intercept document events; that is, things that happen when the end-user acts to open, close or save a document. In particular we introduce “event” concepts for VBA programmers – and the skills learned here can be extended to other Microsoft Office applications. |
||
Word VBA |
3 |
This module will provide participants with the skills they need to implement a variety of numbering schemes for new documents, invoice numbers, task numbers and the like. We introduce a variety of schemes and empower the user to pick the scheme that best suits their purpose. |
||
Word VBA |
3 |
This module will provide participants with the skills they need to begin in-depth processing of the myriad devices available to the VBA programmer. In particular we introduce the concepts of Objects together with their properties and methods, and we show how to navigate through Collections of Objects of any kind. |
||
Word VBA |
2 |
This module will provide participants with the skills they need to process cell contents and properties in Tables in Microsoft Word. In particular we introduce the concepts of iterating through collections of tables, rows, columns and cells while making changes to their contents and properties. |
||
Word VBA |
2 |
This module will provide participants with the skills they need to start creating and using regular Expressions for string search and manipulation. In particular we introduce the six most commonly used concepts of regular Expressions for Word VBA programmers – all centered on thinking of the end-user’s needs. |
||
WordVBA |
2 |
This module will provide participants with the skills they need to choose and assign shortcut key combinations to macros. In particular we explore the set of assigned shortcut keys and isolate some combinations for our own use. |
||
WordVBA |
2 |
This module will provide participants with the skills they need to hook up simple application macros to on-screen buttons. In particular we reinforce macro creation and editing skills and make use of two types of command button. |
||
WordVBA |
2 |
This module will provide participants with skills to record and run both simple macros and compound macros. Judicious development of small applications can be achieved by using small macros as building blocks. In particular we stress the Golden Rules of macro writing, and how to ensure 100% success with every recorded macro. |
||
WordVBA |
1 |
This module will provide participants with the skills they need start off on the right foot and begin building robust and acceptable code modules. In particular we introduce the five most important concepts for Word VBA programmers – all centered on thinking of the end-user’s needs. |
||
WordVBA |
3 |
This module will provide participants with the skills they need to begin passing data between the component applications in Microsoft office. In particular we explore movement of data and control between Microsoft Word and Microsoft Excel. |
||
WordVBA |
1 |
This module will provide participants with the skills to code routines to eliminate duplicate words and paragraphs from documents and, by extension, to eliminating duplicate items in other Microsoft Office Applications. We introduce the concept of re-dimensioning dynamic arrays and the algorithm for detecting duplicates in a sorted list. The techniques learned here can easily be applied to Excel, PowerPoint and other Microsoft Office Applications. |
||
WordVBA |
3 |
This module will introduce participants to the extremely rapid development process of applications made possible through the user of library code. In particular we work to store values user-interface values in text files known as INI files. |
||
WordVBA |
2 |
This module will provide participants with the skills they need start off on the right foot and begin building robust and acceptable code modules. In particular we introduce the five most important concepts for Word VBA programmers – all centered on thinking of the end-user’s needs. |
||
WordVBA |
3 |
This module starts participants off on the path to making use of a set of libraries of pre-tested code which will speed up application development. In particular we differentiate between the internal structure of a library project, and the way that libraries fit into the structure of the application development strategy. |
||
WordVBA |
3 |
This module will provide participants with the skills they need to begin recording macros and understanding some elementary principles of Visual basic for Applications (VBA). In particular we introduce the concept of recording and editing macros, a principle used by professional VBA programmers to explore new facets of VBA in Microsoft Office Applications. |
||
WordVBA |
2 |
This module provides participants with skills to obtain data from text files. In particular we learn how to process individual records of a data file and how to split those records into meaningful fields. |
||
WordVBA |
2 |
This module will provide participants with two distinct skills surrounding stack manipulation. Stack manipulation, also known as Last-In-First-Out (LIFO) is an essential tool of application developers, especially within string analysis. We begin by managing a stack through pre-supplied library code; then we move on to develop our own code to manage data in stacks. |
||
WordVBA |
3 |
This module will provide participants with the skills they need to begin setting up data communications between different applications within Microsoft office. In particular we introduce the coding necessary within Word VBA to make use of data stored in a Microsoft Access database. |
||
WordVBA |
3 |
This module will start attendees off on the path of truly productive development of Microsoft office applications. In particular we show how to use the developer-friendly Word/VBA environment and use it to manipulate Access databases, all in VBA. |
||
WordVBA |
2 |
Word does not support transposition of a table by a diagonal. We would like to take a table from a word document, pass it to Excel, ask Excel to transpose the rows and columns and send it back to us, all via the clipboard. This module takes participants through the processes involved with passing table data to Excel and receiving back the results. |
Loading
Toronto and Mississauga, Monday, September 19, 2011 6:45 PM
Copyright © 1996-2011 Chris Greaves. All Rights Reserved.