Microsoft Excel 2010 Intermediate
SmartStyle
Duration: 1 Day
£125
(Exc VAT per delegate on a public scheduled course)
Detailed information
| Type: | Training |
|---|---|
| Method: | In a classroom |
| Accreditation: | N/A |
| Prepares for: | Practical work based Excel skills |
| Geared towards: | Users who already have some experience of using Excel who need to create spreadsheets which include calculations, multiple sheets and charts. |
| Requirements: | Users need to be able to design and create simple spreadsheets which include basic formulae and the use of AutoSum. They should also be able to use simple formatting tools and use cut, copy and paste effectively |
| Internship: | N/A |
| Students per class: | 10 |
Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course program
More Formulae & Functions
Creating an IF Statement
Using Dates in Calculations
Calculating Percentages
Working with Multiple Worksheets
Moving Between Worksheets
Inserting, Deleting & Renaming Worksheets
Moving & Copying Worksheets
Using Group Editing
Entering Formula Across Worksheets
Worksheet Customisation
Naming Cells & Ranges
Conditional Formatting
Creating a Custom Number Format
Password Protecting a File
Protecting Sheets & Cells
Splitting a Worksheet into Panes
Freezing Worksheet Titles
Inserting a Page Break
Charting Essentials
Analysing Trends with Sparklines
Creating Charts & Graphs
Formatting Chart Objects
Modifying the Chart Layout
Adding & Removing Data Labels
Working with Pie Charts
Previewing & Printing Charts
Data List Essentials
Structuring a Data List
Sorting A List of Data
Filtering Data Using AutoFilter
Using Automatic Subtotals
Working with Excel Tables
Creating an IF Statement
Using Dates in Calculations
Calculating Percentages
Working with Multiple Worksheets
Moving Between Worksheets
Inserting, Deleting & Renaming Worksheets
Moving & Copying Worksheets
Using Group Editing
Entering Formula Across Worksheets
Worksheet Customisation
Naming Cells & Ranges
Conditional Formatting
Creating a Custom Number Format
Password Protecting a File
Protecting Sheets & Cells
Splitting a Worksheet into Panes
Freezing Worksheet Titles
Inserting a Page Break
Charting Essentials
Analysing Trends with Sparklines
Creating Charts & Graphs
Formatting Chart Objects
Modifying the Chart Layout
Adding & Removing Data Labels
Working with Pie Charts
Previewing & Printing Charts
Data List Essentials
Structuring a Data List
Sorting A List of Data
Filtering Data Using AutoFilter
Using Automatic Subtotals
Working with Excel Tables
Do you need clarification regarding the course program?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course location
- 2nd Floor Orleans House, Edmund Street - L3 9NGCity and Borough of Liverpool (England)
SmartStyle
Recognised as one of the UK’s leading providers in the field of learning and development, SmartStyle ensure that organisations get the most from their people, their technology and their investment in both.
Delivering bespoke and “off-the-shelf” IT, business skills and professional development training, SmartStyle provide organisations across all sectors, a one stop solution for their learning and development needs, from our centres in Bradford and Liverpool.
Working in partnership with our clients, we identify real needs, aligned with organisational objectives and match innovative learning interventions to those needs - getting the right skills to the right people and delivering maximum return on investment.
Delivering bespoke and “off-the-shelf” IT, business skills and professional development training, SmartStyle provide organisations across all sectors, a one stop solution for their learning and development needs, from our centres in Bradford and Liverpool.
Working in partnership with our clients, we identify real needs, aligned with organisational objectives and match innovative learning interventions to those needs - getting the right skills to the right people and delivering maximum return on investment.
