MS and Adobe Training Courses
 

How to build your Custom Excel Course
Each topic shown below has a duration shown in brackets. This is how long we expect to teach that topic.

By selecting a topic, we will indicate the total duration in minutes next to the check box for the entire course. We also show the total number of training days at the top, rounded to half days.

To create your course, simply choose topics on the right to make up full or half days. Complete the form and send it to us. A member of our team will contact you back immediately.

More Custom Courses
Access Custom Training Courses Custom Access Courses
Excel Custom Training Courses Custom Excel Course
PowerPoint  Custom Training Courses Custom PowerPoint Course
Word Custom Training CoursesCustom Word Course
Project Custom Training Courses Custom Project Course
Outlook Custom Training Courses Custom Outlook Course
Visio Custom Training Courses Custom Visio Course
Publisher Custom Training Courses Custom Publisher Course
 
Contact Mouse Training
 
 
* First Name :
* Last Name :
Company :
* Tel No :
* Email Address :
Estimated number of delegates to be trained :
Total Minutes Selected :
Total Training Days :
 
Course topic and minutes expected to teach each topic Check to include Total Minutes
The Ribbon (tabs, groups and commands) (5)
The Quick Access toolbar (5)
Persistent undo and redo (5)
Access Keys (2)
Super Tooltips (5)
The Zoom Slider (1)
Live Previews (5)
SmartArt & Word Art (5)
Saving and Compatibility mode (10)
Contextual tabs (5)
Quick Styles and Themes (10)
Dialog Box Launchers (1)
The Minimize Toolbar (1)
Starting New Workbooks (1)
File Management (5)
Entering Text, Numbers, Dates (15)
Editing and Deleting cells (10)
Selection Techniques (10)
Moving and Copying data (10)
Inserting New Columns and Rows (10)
Formatting Spreadsheets (60)
Printing and Previewing spreadsheets (60)
Creating a Formula using +, -, × and ÷ (20)
Copying a Formula (10)
Relative and Absolute ($) Reference (20)
Using Autosum (10)
Functions: Average, Min, Max, Count (10)
Using Logical Functions (IF, AND, OR) (60)
Using Nested Functions (Function within another) (15)
Lookup and Reference Functions, e.g. Vlookup, Index, etc (60)
Date & Time Functions eg NETWORKDAYS (15)
Text Functions eg LEFT, MID, RIGHT, TRIM, etc (45)
Using Charts (60)
Insert, Deleting and Moving Worksheets (5)
Recolour, Hide, Move or Copy Worksheets (5)
Linking sheets in the same file (15)
Linking different Excel files (20)
Using Data Consolidation (20)
Viewing Different Files at once (5)
Saving a Workspace (5)
Sorting Data (10)
Adding Subtotals on a list (10)
Using Autofilter (15)
Using Advanced Filter (15)
Database Functions: Dsum, Dmin, Dmax (15)
Outline and Group Spreadheets (10)
Pivot Tables (90)
Pivot Chart (10)
Setting up Scenarios (15)
Uing Goal Seek and Solver (15)
Creating and using Custom Views (10)
Sharing a File (10)
Tracking changes (10)
Protecting Cells, Sheets, Files (20)
Formula Auditing Spreadsheets (20)
Customizing Toolbars (10)
Importing / Exporting Text files (10)
Spreadsheet Form Controls (Combo, Radio Buttons, etc) (30)
Recording and Running Macros (90)
Using the Visual Basic Editor (15)
Essential Language Elements (30)
Obejcts, Properties, Methods, Object Hierarchy (90)
Using Variables and Constants (30)
Creating Functions (45)
Control Structures (If, ElseIf, Select Case) (45)
Interactive Code (Message and Inputbox) (45)
Using Looping structures (90)
Error Handling (15)
Creating Userforms (90)
Creating Custom Menus and Toolbars (10)
Using Event Procedures (90)
Using Event Procedures (5)
Macro Distribution (Addins) (10)
Please provide information on any other topics you would like to include    
 

 

All Right Reserverd MTC Training Solutions Ltd
 
 
Home | Software Training | Soft skills Training | Bespoke Training | Consultancy | Services | About Us | Contact Us | Privacy Statement | Sitemap © 2007 MTC All rights reserved