Microsoft Excel 2016 and VBA


SKU: GC1919 Categories: ,

Microsoft Excel 2016 and VBA

Our Microsoft Excel 2016 and VBA training materials provides you with a fully-customizable package of courseware content for delivering Microsoft Office training to your employees and/or students. Everything you need to run the course is included, just add trainer!

All courseware print licences are perpetual – buy once and use forever!

  • Fully customizable. Sold on a site licence basis, you can tailor ALL content to meet specific learning or corporate requirements.
  • Digital download. Content is available to download after purchase.
  • Proven. Our course materials are used in hundreds of training centres around the world. Every course is fully beta tested and validated in the classroom before undergoing a full production release.
  • Simple… No need to invest in expensive DTP applications – all files are easily editable in any word processor.
  • Print on demand. You only need to print exactly what you need, when you need it.
  • Totally flexible. Courses can be modified to meet specific requirements. Sections can be removed. New content added. One or more titles can be combined. Whatever your training requirements, our courseware can help you meet that need.
  • Unlimited users. Content is sold on a site licence basis. You can train as many staff or employees at that location as you like. Forever!
  • Buy once. Use forever! You’re buying a perpetual licence. One payment gives you an unlimited site licence for use as long as you need it.
  • No limits! Unlike some content providers, our licence enables you to reprint the courseware as many times as you like. 1 student or 100,000. No limits…

Student manual

Fully customisable. May be opened in any word processor and changed to meet your exact needs.

Student workbook

Fully customisable. Additional book includes series of practical tasks and review questions.

Student workbook exercises

Sample exercises to accompany the student workbook.

Trainer manual

Fully customisable with additional information for trainers.

Timetable and lesson plans

Detailed timetable and plans ensure you deliver the best possible course

PowerPoint presentations

PowerPoint presentations. Fully customisable. Complete set of PowerPoint slides for use by the trainer.

Course contents

  • Create a Macro Using the Macro Recorder • Visual Basic for Applications • Object-Oriented Programming • Macros • Macro Options • The Macro Recorder • Personal Macro Workbooks • How to Create a Macro Using the Macro Recorder
  • Edit a Macro • The Visual Basic Editor • Projects • Modules • The Modules Folder • Objects • Properties • Methods • VBA Comments • How to Edit a Macro
  • Debug a Macro • The Debugging Process • Debugging Tools • How to Debug a Macro
  • Customize the Quick Access Toolbar and Hotkeys • How to Customize the Quick Access Toolbar and Hotkeys
  • Set Macro Security • Digital Certificates • Digital Signatures • Macro Security Settings • How to Set Macro Security • Review Questions
  • Insert Text • The Selection Property • The ActiveSheet Property • The Name Property • The Value Property • Concatenation • How to Insert Text
  • Format Text • How to Format Text
  • Sort Data • The Range Object • The Select Method • The CurrentRegion Property • How to Sort Data
  • Duplicate Data • Data Types • Variables • Variable Naming Rules • Operators • The Assignment Operator • Arithmetic Operators • Comparison Operators • Logical Operators • The For Next Loop • Do Loops • The Worksheets Object • The Count Property • The Offset Property • The Copy Method • The Paste Method • How to Duplicate Data
  • Generate a Report • The Columns Property • The AutoFit Method • The Address Property • The Call Statement • The Font Property • The End Property • How to Generate a Report
  • Determine the Dialog Box Type • Message Boxes • Input Boxes
  • Capture User Input • The InputBox Function • Constants • The MsgBox Function • The Code Continuation Character • The vbCrLf Constant • Decision Structures • The Select Case Statement • The If Then Structure • The Else Clause • How to Capture User Input • Review Questions
  • Insert, Copy, and Delete Worksheets • The Add Method • The Copy Method • The Delete Method • How to Insert, Copy, and Delete Worksheets
  • Rename Worksheets • Expressions • The DateSerial Function • The Format Function • How to Rename Worksheets
  • Modify the Order of Worksheets • The Move Method • How to Modify the Order of Worksheets
  • Print Worksheets • The PrintPreview Method • The PrintOut Method • How to Print Worksheets • Review Questions
  • Create User-Defined Functions • User-Defined Functions • Types of Functions • Arguments • How to Create User-Defined Functions
  • Automate SUM Functions • Declared Range Objects • The Set Statement • Range Object Cell Addressing • The Rows Property • The Formula Property • The Columns Property • Address Property Cell Reference Settings • How to Automate SUM Functions
  • Appendices • Keyboard Shortcut Quick Reference Sheet • Glossary