Advanced Spreadsheets Using Excel
We will build on your knowledge of Microsoft Excel and teach you how to construct a clear, concise, and informative expert spreadsheet that can be used in any business, club, or personal use situation. You will be introduced to some of the more complex operations within the program. Follow our step-by-step instructions as we produce a multi-sheet workbook that will be used to record a real-life activity before we look at performing a range of complex analysis actions on the results.
· Lesson 1: Spreadsheets Recap
· Lesson 2: Advanced Formulas and Functions
· Lesson 3: Vlookup
· Lesson 4: Pivot Tables
· Lesson 5: Multiple Worksheets and Graphs
· Lesson 6: Final Task
The final task of this course is the ability to use a pre-configured spreadsheet to set up formulas and retrieve data. The task is based on the features you have learned through the lessons and a recommendation is to complete each function in the spreadsheet in order, so the task flows correctly.
In the task, you will be asked to carry out calculations using functions like COUNTIF, VLOOKUP, and Pivot tables combined with Conditional Formatting and the creation of graphs using the data provided.
Learning the skills of using these functions and tables will allow you to make the tasks generally quicker and potentially more accurate.
We use the online learning suite Moodle to enable you to learn both from the comfort of your own home or any other location.
24 hours a day, 7 days a week, and 365 days a year!
HELP WHEN YOU NEED IT
Free tutor support 6 days a week online, by phone, email, or live chat.
SHOW YOUR ACHIEVEMENT
Gain a certificate for each course you complete to demonstrate your new skills; for a new employer, to evidence your professional development, or for personal interest.
LEARN BY DOING
Practical tasks in each course to aid your understanding.
If you are interested in the course above or want to find out more about our exciting range of courses please fill in the form below.
Our Delivery Partners
*terms and conditions apply