img

Need Help? Call: +44 (0)151 650 6907

img

Blog

How to Create a Named Range in Excel

14th Mar 2024 SquareOne Training

Using named ranges in Excel is like giving a unique identity to a cell or range of cells. It’s a fantastic way to make your formulas more readable, your references more understandable and your spreadsheet more organised. Continue reading to harness the power of named ranges in Excel.

Read More

How to Change the Order of Rows in a Pivot Table

7th Mar 2024 SquareOne Training

Do you want to learn how to quickly change the order of the rows in your Pivot Table? If so, continue reading to learn two quick ways of doing this! The first option shows you how to use the context (right-click) menu to change the order of your pivot table, and the second option allows you to manually sort the order of your rows by dragging them.

Read More

How to Insert a Picture Inside a Cell in Excel

29th Feb 2024 SquareOne Training

While you’ve been able to use pictures in Excel for many years, Excel has recently enabled the ability to add a picture inside a cell. so, it becomes the actual cell value. It is a quick and easy feature to use so follow the simple steps below to make your worksheet more visually pleasing and make your data easier to read:

Read More

10 Excel Formula Tips for Beginners

15th Feb 2024 SquareOne Training

Are you new to Excel and feeling overwhelmed by all its formulas and functions? Don't worry, you're not alone. Excel can initially seem daunting with its many features, but with a bit of guidance and practice, you can become efficient in no time. Here are ten tips to help beginners get started with Excel formulas.

Read More

A Quick Guide on How to Select the Current Region in Excel

1st Feb 2024 SquareOne Training

Microsoft Excel offers a powerful array of features to help with data manipulation and analysis. One feature that will speed up your workflow is the ability to select the “current region” The current region refers to a range of cells containing data surrounded by empty cells or worksheet boundaries. Instead of having to tediously drag to select your entire current region, you can use a simple keyboard shortcut for a more efficient approach. Carry on reading to master this time-saving technique.

Read More

7 Formatting Keyboard Shortcuts to Save You Time in Excel

25th Jan 2024 SquareOne Training

Excel is great for data management and organisation. However, navigating through its countless features and functions can become overwhelming. Luckily Excel has a lot of keyboard shortcuts to make things easier for you. These Formatting shortcuts can significantly enhance your efficiency and streamline your workflow within Excel.

Read More

How to Stop Your Image from Getting Distorted When Enlarging it in PowerPoint

18th Jan 2024 SquareOne Training

Have you ever attempted to resize an image in PowerPoint, only to find that it distorts when you drag its sides toward the edge of your slide? Continue reading to Unlock the secret to flawless image enlargement in PowerPoint with our step-by-step guide and prevent distortion when enlarging your images! Elevate your PowerPoint skills and enhance your visual impact when creating a presentation – Let's dive into the details!

Read More

10 Excel Keyboard Shortcuts to Help You Save Time

11th Jan 2024 SquareOne Training

Excel has many Keyboard shortcuts built in to help you save time and significantly speed up tasks instead of navigating through menus you can execute commands swiftly. Helping you become more efficient. They also stop you from spending time on repetitive tasks and allow you to focus on other essential aspects of your work. Read this blog to learn the best keyboard shortcuts to help you work seamlessly in Excel.

Read More

How to Quickly Increase or Decrease the Size of Your Text in Word & Outlook

4th Jan 2024 SquareOne Training

Microsoft platforms all have handy keyboard shortcuts built into them that help you save time and improve efficiency. In this blog, we will teach you the keyboard shortcuts to increase and decrease the size of your text in Word and Outlook. This is a handy shortcut to know when you want to bring emphasis to your text, improve readability, or make your document/email look more polished. Keep reading to learn how.

Read More

How to Quickly Make Charts and Tables in Excel Using Keyboard Shortcuts

21st Dec 2023 SquareOne Training

Charts and graphs are both important features in Excel as they are a great way to visually represent your data. They are a great way to bring your data to life and help you analyse and create insights from your data. Continue reading this blog to learn how to make both charts and tables in Excel in just a few clicks making your worksheets more aesthetically pleasing and easier to read.

Read More

How do I replace . with / in Excel?

14th Dec 2023 SquareOne Training

Have you ever used dates in Excel with full stops and then needed to change them to / and had to manually go through your worksheet and change each one? If so, this tip will be great for you. In this blog, we will show you how to quickly change all the. (full stops) with /
This will help you save a lot of time when working with dates in Excel.

Read More