Warning: count(): Parameter must be an array or an object that implements Countable in /home/customer/www/bluegrass-group.com/public_html/wp-content/plugins/msp_marketing_edge_autoblog/meta_data.php on line 52

Newsletter

Stay up to date with the latest technology trends delivered straight to your inbox every month.

 

Microsoft 365 Excel – How to videos

Making the most of Microsoft Excel

We’ve put together a series of How To videos on all the basic elements of Microsoft 365; Word, Excel, PowerPoint and Teams to help you make the most of these fantastic tools.

Firstly, let’s learn some more about Microsoft Excel with these easy to follow 1 minute videos.

EXCEL: Always see the headings when scrolling

Excel is great for looking at lots of data, but when you can’t see the column or row headers, you have to scroll back and forth to check what the data means. Did you know there’s a great time saver which can lock the headers in place? Here’s how to do it.

EXCEL: Instantly see all data in columns & rows

Sometimes in an Excel document the column sizes need to be adjusted so you can see the data clearly. Rather than trying to change all the column and row sizes manually, we show you how to do it in just a few clicks.

EXCEL: Speed up typing

Do you find yourself typing duplicate words or numbers into Excel? You can speed up this process by using the clever Flash Fill feature. It’ll save you from typing out the same info multiple times. Here’s how to use it.

EXCEL: Do super-fast sums without formulas

Excel is great for calculations with formulas. But if you find your head spinning trying to remember how they work, we have the ultimate Excel hack for you. This video shows you how to do super-fast sums without formulas.

EXCEL: Turn numbers into money with one click

If you’re using Excel to track budgets or other financial data, it can be helpful to have your currency symbol alongside the numbers. Here’s how to turn numbers into money, with just one click.

EXCEL: Save time adding new columns or rows

Adding multiple columns and rows into spreadsheets can be time-consuming, not to mention boring. Give that trackpad a rest and add as many new columns and rows as you need in one go. Here’s how.

EXCEL: Create ranges of data without doing any typing

If you need to create sequential numbers, dates or other data in Excel, it can take forever. Not anymore. We’ll show you how to do it with the minimum of typing.

EXCEL: Swap rows into columns and vice versa

When you need to swap your rows into columns or columns into rows, it can be tricky. Not only is it time consuming, but you run the risk of mixing up your data. We’ll show you how to do it in just a few clicks.

EXCEL: Make dull data stand out and become dynamic

You may think it impossible to make Excel sheets appear interesting. Well, you’d be wrong. In this video you’ll learn how to make your data stand out.

EXCEL: Insert live Excel data into Word

If you need to display data from an Excel sheet in your Word document, don’t waste time trying to recreate it. We’ll show you how to use live Excel data in your Word document in just a few clicks.

EXCEL: Make a drop-down list to select from

Don’t waste valuable time typing the same data into Excel repeatedly. We’ll show you how to create a dropdown list that will get the job done in no time.

EXCEL: Understand your data with super-fast graphs

Excel is such a clever tool, it can make sense of your data for you. This video will teach you how to take a sheet of numbers and turn them into helpful graphs, fast.

EXCEL: Combine text from two cells into one

When you need to combine two cells into one, there’s no need to cut and paste every cell. With this simple formula, you can do it quickly and accurately.

Want to learn more about 365?

 

Hopefully these videos have provided some useful tips on how to make the most of this basic 365 feature.

To learn more about the other features of Microsoft 365, click on our other tutorial video pages below:

Learn more about Teams here

Learn more about PowerPoint here

Learn more about Word here

 

If you’d like to talk to our Microsoft experts about how your business can make the most of Microsoft 365 simple call us now on 01392 796 779 or book a later call using our live calendar

REQUEST A CALL BACK

Complete the form and one of our team will be in touch.

Or view our calendar and book a call when it suits you.Book Date

If you want to speak to someone today, give our team a call on 01392 796 779. We'd be delighted to help.

Find out more about our IT support packages

To speak to us today simply call 01392 796 779
or complete the form below