A 1 day Introduction Course, aimed to give users the confidence and knowledge to create and use Excel spreadsheets. By the end of the day, users will be able to create, amend and manipulate their own spreadsheets.
A 1 day Introduction Course, aimed to give users the confidence and knowledge to create and use Excel spreadsheets. By the end of the day, users will be able to create, amend and manipulate their own spreadsheets.
Course Basics
Introduces the user to the layout of Excel, identifying commonly used features and functions.
• Menu bar
• Ribbon
• Status bar
Spreadsheet Management
Build confidence by performing simple tasks whilst navigating through Excel.
• Creating new documents
• Saving spreadsheets
• Closing Excel
Data Management
Sorting and Filtering your data to get more accurate statistics from your spreadhseet.
• Sorting Data
• Subtotalling Data
• Using Filters
• Freezing Panes
Formatting Excel
Changing the look and feel of spreadsheets.
• Selecting cells, columns and rows
• Displaying data as currency (£)
• Displaying figures as percentages (%)
• Changing cell, text and border colour
Formulas and Functions
Creating and using simple formulae to return totals, averages, largest and smallest figures from a range of data.
• Understanding simple formulas
• Using AutoSum
• Understanding Absolute Cell References
• Using AutoFill tools
Formula Auditing
Understanding and fixing complex spreadsheets that other users may have set up
• Trace Precedents
• Trace Dependents
• Evaluating formulas
• Tracing errors
• Using the Watch Window
Charts
How to use your data in various chart types.
• Using the Chart Wizard
• Select appropriate chart types
• Specifying the data source
• Customising your charts
Aspire Leadership has been providing unique bespoke in-house and public leadership development and management training courses for over ten years.
We tailor all our training to suit your organisation’s needs, whether that’s communication skills, influencing, assertiveness, or presentation skills courses.
In this beginner’s course, you will learn the fundamentals and basic concepts of Microsoft Excel. This will allow you to
For complete beginners who need to understand the functionality of Excel. Learn to work efficiently, producing factual and well formatted spreadsheets.
n site Microsoft Word courses tailored to your needs, designed for businesses and professionals. All Microsoft Office Word versions including 2003, 2007, 2010, 2013, 2016 and Office 365 covered.
The course enables the delegates to create complex queries, make forms and build a database with a good relational structure. During the one day course, the delegates will learn how to create basic to advanced reports, design Access databases, manage interfaces with Access Forms and automate tasks ...
This one day course is a comprehensive fast paced introduction to Word and covers all the features need to layout standard business documents in a professional way. Designed for the student who is already using Word or has attended the Introductory course and would like to expand their knowledge.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy