IT Training Services
SJAC - IT Tuition, specialise in the Microsoft Office Suite of applications, Access, Excel, Outlook, PowerPoint and Word, providing, Individual Online Tuition with qualified tutors,
for home users and corporate clients alike.
Click here for details on how to book a 1 Hour Online Individual Tuition Session
Sessions can be tailored to help our clients prepare for their Microsoft Office Specialist Certification. For more information on becoming a Microsoft Office Specialist click on the logo below.
Microsoft Excel
Microsoft Excel Introduction Topics
- Getting Started
- Spreadsheet terminology
- Exploring the Excel window
- Getting help
- Opening and navigating workbooks
- Closing workbooks
- 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
|
Microsoft Excel Intermediate Topics
- Working with Large Worksheets
- Viewing options
- Hiding and displaying data
- Printing large worksheets
- Working with Multiple Worksheets and Workbooks
- Using multiple worksheets
- Linking worksheets by using 3-D formulas
- Consolidating data
- Linking workbooks
- Managing workbooks
- Customising Excel
- Changing options
- Customising toolbars and menus
- Advanced Charting
- Chart formatting options
- Creating combination charts
- Using graphic elements Advanced Formatting
- Borders and shading
- Using special number formats
- Working with dates
- Working with styles
- Other advanced formatting
|
- List Management
- Working with lists
- Sorting and filtering lists
- Advanced filtering
- Documenting and Auditing
- Comments and text boxes
- Auditing features
- Protection
- Workgroup collaboration
- Using Templates
- Built-in templates
- Creating and managing templates
|
Microsoft Excel Advanced Topics
- Working with Advanced Formulas
- Using names
- Using decision-making functions
- Creating nested functions
- Using financial functions
- Lookups and Data Tables
- Working with lookup functions
- Creating data tables
- Advanced List Management
- Creating subtotals
- Validating cell entries
- Exploring database functions
- Working with PivotTables and PivotCharts
- Working with PivotTables
- Rearranging PivotTables
- Formatting PivotTables
- Working with PivotCharts Exporting and Importing
|
- Exporting and importing text files
- Querying external databases
- Using Analytical Options
- Working with Goal Seek and Solver
- Working with scenarios
- Working with views
- Working with Macros
- Running and recording a macro
- Viewing VBA code
- Function procedures
- Interactive Web Pages
- Creating interactive Web spreadsheets
- Publishing PivotTables on the Web
|
Contact us
If you would like to find out more about SJAC - IT Tuition, please contact us.
1 Hour Individual Online Tuition - £50.00
