How to Videos
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.
When you’re looking at data in Excel, make sure you’re looking at the bigger (or smaller) picture by using the Zoom functions. This video shows you how to zoom in and out easily.
If your Excel document is very long, it can take a lot of scrolling to get back to the top. Find out how to do it quickly, without moving the mouse or endless scrolling. It’s a shortcut you’ll use over and over.
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.
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 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.
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.
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.
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.
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.
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.
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.
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 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.
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.
Eclipse Integrated Systems has been a game changer for our business. Their managed IT services have significantly improved our network reliability and security. The team is incredibly responsive and proactive, addressing potential issues before they become problems. Their cloud solutions have streamlined our operations, and the data backup service gives us peace of mind. Overall, their service is excellent, and their customer support is top-notch. I highly recommend Eclipse to any business looking for dependable IT support.
Chief Technology Officer, Oak Knoll School of the Holy Child
“What I appreciate most about Eclipse is their proactive approach to IT management. They continuously monitor our systems to ensure they are secure, updated, and running efficiently, which has resulted in improved productivity and reduced downtime for our Radiology practice.”
Chief Executive Officer of Radiology, River Radiology
“Marc and his team are highly knowledgeable, responsive, and proactive. They work tirelessly to understand our needs and I have no hesitation in recommending Eclipse to any school seeking a reliable and effective technology partner.”
Director of Technology, Whitby School
“I highly recommend Eclipse for their high level of expertise, professionalism, attention to detail, and commitment to delivering tailored and innovative solutions that meet specific project requirements.”
Principal, NK Architects
Let’s connect and chat through your IT needs. Quick, friendly, and tailored to your business.
