Home • Training • Custom Database • Contact

Onsite Microsoft Excel Training Course

We provide Microsoft Office training for you onsite at your office. Our training courses are fully inclusive of all the equipment and materials required for up to 8 delegates per day.

We come to you to deliver the training
We bring all the equipment required for the training

Every delegate receives course material to take away
Courses can be tailored to your requirements

	Microsoft Excel Basic		Microsoft Excel Intermediate		Microsoft Excel Advanced

	Our Microsoft Excel Basic course introduces you to the central workings of Excel enabling you to produce spreadsheets that can benefit your business. It is expected that you will have a basic knowledge of using computers but no prior experience with Microsoft Excel.		Our Microsoft Excel Intermediate course builds on your prior knowledge of Excel and incorporates this into producing more complex spreadsheets to enhance business capabilities. It is expected that you will have had a working experience and/or training within Microsoft Excel prior to this course.		Our Microsoft Excel Advanced course introduces techniques employed by experienced users to enhance your use of Excel and build feature rich spreadsheets. This will not only benefit your business but will develop your own key skills. Previous training and a working knowledge of Excel are needed before embarking on this course
	Entering and editing data Creating workbooks Entering and editing labels and values Entering and editing formulas Saving and updating workbooks Modifying a worksheet Moving and copying data Moving and copying formulas Using absolute references Inserting and deleting ranges Using functions Entering functions Using AutoSum Using AVERAGE, MIN, and MAX Formatting worksheets Formatting text Formatting rows and columns Number formatting Using Format Painter and AutoFormat Printing Preparing to print Page Setup options Printing worksheets Creating charts Chart basics Modifying charts Printing charts Web features Saving workbooks as Web pages Hyperlinks Sending workbooks via e-mail		Working with large worksheets Viewing options Hiding, displaying, and outlining data Printing large worksheets Using multiple worksheets and workbooks Using multiple worksheets Linking worksheets by using 3-D formulas Consolidating data Linking workbooks Managing workbooks Customizing Excel Using the Options dialog box Customizing toolbars and menus Advanced Formatting Borders and shading Using special number formats Working with dates Working with styles Other advanced formatting List management Examining lists Sorting and filtering lists Advanced filtering Advanced charting Chart formatting options Using combination charts Using graphic elements Documenting and auditing Auditing features Comments and text boxes Protection Workgroup collaboration Using templates Built-in templates Creating and managing templates		Working with advanced formulas Using names Using decision-making functions Creating nested functions Using financial functions Lookups and data tables Working with lookup functions Using MATCH and INDEX Creating data tables Advanced list management Creating subtotals Validating cell entries Exploring database functions Working with data forms Working with PivotTables and PivotCharts Working with PivotTables Rearranging PivotTables Formatting PivotTables Working with PivotCharts Exporting and importing Exporting and importing text files Exporting and importing XML data Querying external databases Using analytical options Working with Goal Seek and Solver Working with the Analysis ToolPak Working with scenarios Working with views Working with macros Running and recording a macro Working with VBA code Function procedures Interactive Web pages Creating interactive Web spreadsheets Publishing PivotTables on the Web

Home | Training | Bespoke Database Solutions | Contact us | Site map

Access Database Course | Excel Spreadsheet Course | Outlook Course | PowerPoint Presentation Course | Microsoft Project Course