In the ever-evolving business landscape, Microsoft Excel remains a cornerstone for professionals seeking to harness the power of data. With its robust features, Microsoft Excel empowers business users to transform data into actionable insights, and having the ability to analyse data and present it visually to support communications is a critical skill.
From organising raw information to creating sophisticated data models, it’s your go-to tool, and by the conclusion of this program, you will be able to confidently review and clean your data across multiple spreadsheets, take raw data and change how it is presented, find hidden formulas, and format blank cells and errors, taking you to the next level on your path to data mastery.
By the end of this program of learning, you will know:
How to use text to columns & Flashfill to split data
How to use Flashfill & CONCAT formulas to join data
How to write TRIM, PROPER, LOWER & UPPER formulas
How to find, highlight & remove blank cells & duplicates
How to transpose data
How to use Go To Special box
How to write FIND, LEFT, LEN, RIGHT & MID formulas
How to record a very basic reformatting macro to clean data
This course has been designed specifically for individuals who are quite confident in their use of Microsoft Excel and wish to explore the vast array of data analysis features and formulas that are present in Microsoft Excel a little further. In this program, we will guide you through every feature step-by-step, transforming your day-to-day business practices while setting you up for business success.
This course can be delivered online, or
Face-to-face in our training centre, or
At your place of work.
If you would like to have this class online, you will need access to two screens, a webcam, speakers, and a microphone.
This highly engaging program of learning is a 3-hour interactive workshop.
Ahead of booking onto this program of learning, you must ensure:
1. That you are familiar with the content covered in the Microsoft Excel Essentials course.
All training spreadsheets for future practice
A full colour booklet to accompany the lesson
Contact a member of the ALX team for further details using the ‘Contact Form’ below.
Fill out the form below to discover how ALX Training can help you:
Or talk to us directly...
+44 1534 873785
admin@alxtraining.com
Windward House
La Route de la Libération
St Helier, JE1 1BG
Jersey
https://what3words.com/stamp.happy.fanfare