Managed IT Services & IT Support | Mighty Manatee IT

  • Home
  • Services
    • Data Security
    • Business Continuity
    • Managed IT Services
    • IT Consulting
    • VoIP
  • Partners
    • Sophos Showcase
  • How To
    • Word
    • Excel
    • PowerPoint
    • Teams
  • Blog
  • Support
    • Remote Support
  • About
    • Our Name
    • Swag
    • Privacy Policy
  • Contact
  • Home
  • Services
    • Data Security
    • Business Continuity
    • Managed IT Services
    • IT Consulting
    • VoIP
  • Partners
    • Sophos Showcase
  • How To
    • Word
    • Excel
    • PowerPoint
    • Teams
  • Blog
  • Support
    • Remote Support
  • About
    • Our Name
    • Swag
    • Privacy Policy
  • Contact
Picture

Excel How To

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 must 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.

Easily zoom in and out

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.

Get to the top row without scrolling

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. 

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.

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. 

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. 

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. 
​Mighty Manatee IT provides a range of Managed IT Services, Business Continuity, Cloud Computing, Data Security, Computer Support, IT Consulting, and Infrastructure support in Lake County and Orange County. This includes, but is not limited to, the following communities: Clermont, Eustis, Fruitland Park, Groveland, Leesburg, Mascotte, Minneola, Mount Dora, Tavares, Umatilla, Astatula, Howey-in-the-Hills, Lady Lake, Montverde, Oakland, Ocoee, Orlando, Windermere, Winter Garden and Winter Park.
Picture
Picture
Picture

352-247-8300
1170 Stoneham Drive
Groveland, Florida 34736
STAY CONNECTED
Picture
© 2023 MIGHTY MANATEE IT
ALL RIGHTS RESERVED