Advanced Spreadsheets Using Excel

Online Training by The Thrive Tribe

Advanced Spreadsheets Using Excel

Spreadsheets are indispensable in business or personal ventures. Learn advanced skills in Microsoft Excel, crafting detailed and insightful spreadsheets. Through the course we will create a multi-sheet workbook reflecting real-life scenarios, integrating data analysis.

Funded for anyone 19+ living in Lincolnshire

Learn at your own pace from any location

Enrol NowEnrol Now

Back To All CoursesBack To All Courses

Our Delivery Partners:

Receive Support

Free tutor support 6 days a week online, by phone, email, or live chat.

Show Achievement

Your certificate will demonstrate your personal or professional development.

Learn by Doing

Our courses are full of practical tasks to help you improve your understanding.

Description

About This Course:

The final task of this course is to use a pre-configured spreadsheet on which you will be making changes using features and skills you have learned through the lessons. This being a Beginner’s Spreadsheets course, we recommend making notes of which tabs (Home, Insert, Design….) contain which sections.

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.

Description

About This Course:

The final task of this course is to use a pre-configured spreadsheet on which you will be making changes using features and skills you have learned through the lessons. This being a Beginner’s Spreadsheets course, we recommend making notes of which tabs (Home, Insert, Design….) contain which sections.

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.

Description

About This Course:

The final task of this course is to use a pre-configured spreadsheet on which you will be making changes using features and skills you have learned through the lessons. This being a Beginner’s Spreadsheets course, we recommend making notes of which tabs (Home, Insert, Design….) contain which sections.

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.