# Office programs

## Collection by Susan Collins Boydston Ballard

107
Pins
•
56
Followers

MyExcelOnline Excel E-books | Get our 101 Excel Formulas & Functions Ebook that covers: VLOOKUP, IF, SUMIF, COUNT, SUMPRODUCT, INDEX, MATCH and our 101 Ready To Use Excel Macros that you can copy & paste to SAVE HOURS!

Let me show you how easy it is to Create Form in Excel for Data Entrywithout using VBA! Click to view this free Excel Data Entry Form tutorial now!

One of the most sought after feature among heavy Excel users i.e. count or sum cells in Excel based on cell background color. I really wish we had a formula or a feature that does it for us but it isn’t available yet. But we do have the solution if we turn to VBA and […]

Don’t waste any more hours in Microsoft Excel doing things manually. There are many ways to use Excel formulas to decrease the amount of time you spend in Excel and increase the accuracy of your data and your reports. Excel Formulas You Should Definitely Know: 1. SUM Formula: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5) […]

The power of Microsoft Excel lies in its formulas. Let me show you the wonders you can do with formulas and conditional formatting in three useful examples.

Create an automatic form to simplify data entry and data search

These are the 50 Things you can do with Excel Pivot Table that will make you an Excel Pro within an HOUR! Click here to learn more about Pivot Tables.

If you've ever wanted to learn to make your own pretty labels in Microsoft Word, follow along with my quick and easy video tutorial! (Screen shots provided too!)

A checklist is a good way to keep track of tasks or processes. We'll show you how to make a checklist in Excel, one simple step at a time.

View ContentsExcel and accountants are two interconnected entities. Around the world excel is the most active computer application in the hands of accountants. Even if accountants have some other accounting software at their disposal they always like to involve excel. Most common example is that data entry work is carried out in specialized accounting software […]

Think you know everything about Microsoft Word? Here are all the hidden tricks and time saving hacks

The number of ways you can use Excel is countless, and so are the number of features packed inside Microsoft’s most popular number-crunching application. Whether you’re a casual user or an Excel expert, it pays to know everything that the program’s capable of, and here are 18 easy tricks that can make a difference.

Have you ever imported data into Excel, from your credit card statement, or somewhere else, and found that Excel dates won't change format? And, if you try to sort that column of dates, things end up in the wrong order. That happened to me this week, and here’s how I fixed the problem, using a … Continue reading "Excel Dates Won’t Change Format"

101 Excel Formulas & Functions Examples | Learn the most popular Excel formulas & functions like VLOOKUP, INDEX, MATCH, IF, SUMPRODUCT, COUNT, SUMIF & more!