This Week’s Tip : Microsoft Excel – Creating Tables

Microsoft Excel – Creating Tables

DID YOU KNOW … that Excel Tables help you manage data more efficiently, reduce errors and analyse information faster, especially as your dataset grows?  Here’s 3 good reasons to learn how to use Tables:

1. When you convert data into an Excel Table, it automatically expands as you add new rows or columns. Formulas, formatting and data validation are applied instantly to new entries – saving precious time.
2. Excel Tables come with built in filter and sort buttons on every column header. They also work seamlessly with PivotTables, Charts and Power Query.
3. Tables use structured references, making them easier to read and understand.

Take just a few minutes today to learn more. Click the play button below to get started.

This lesson is part of our CPD Accredited Excel 365 Intermediate Course

Our Weekly Tips are delivered via email every Tuesday. Learn something new every week – in Bite Size bites of learning.  To sign up to our Weekly Tip Newsletters – sign up here

Take a look at our Microsoft Office Courses – available within our E-Learning Library and as Virtual Classes.

Spring into Action – with our Microsoft 365 Training Solutions

On demand e-Learning Library – Try our three month taster for your Business – start anytime.  >>Read More
Your Place or Ours? – Deliver our SCORM Compliant CPD courses on your own Learning System. >>Read More
Virtual Classes – 2/3 hour or full days delivered on Microsoft Teams, tailored for your organisation.  >>Read More

Copilot Workshops – Full and 1/2 day sessions – delivered virtually on Teams.  >>Read More
Power BI Workshops – Introduction, Intermediate, Advanced Levels – delivered virtually on Teams.  >>Read More

Let’s have a conversation to see how we can help.  Get in touch.