Category Archives: Excel

4 easy steps to keep the leading zero in Excel!

When working on spreadsheets you might have a need to have a column that has leading zeros. For example, let’s use an ID number, if I was to input the beginning of my id “0010” Excel would automatically remove the first two zeros.  … Continue reading

Posted in Excel | Leave a comment

Tips for Using Excel in Office 365

Let your data tell a story With Office 365 you can easily tell the story of your data. Perform complex tasks quickly, visualize your data to understand it better, and share your workbooks for better results. Analyze your data instantly … Continue reading

Posted in Excel, Microsoft, Office365 | Leave a comment

Capturing Screenshots in Office

To follow along with last week’s post we wanted to give you a few tips on using screenshots in the Microsoft Suite. From the Insert tab (available in all of the Office products), select the Screenshot icon.  Microsoft gives you two … Continue reading

Posted in Excel, Microsoft, Outlook, PowerPoint, Tech Tips, Word | Leave a comment

What’s behind the Excel Design tab? 5 tips worth knowing.

If you’ve been working with Excel for a while, my guess is that you are probably somewhat familiar with the basics of converting your data into a table. However, you may not be aware of some of the features behind … Continue reading

Posted in Excel, Microsoft, Tech Tips | Leave a comment

Pivot Tables in Excel 2013

By: Rajat Shetty Excel Pivot tables help summarize your data. They also allow you to avoid using complex formulas like Vlookup, SumIF, etc. to create a table. It can take a little while for a newbie to get the hang of … Continue reading

Posted in Excel, Microsoft, Tech Tips | Tagged | Leave a comment