# 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 Entry without using VBA! Click to view this free Excel Data Entry Form tutorial now!

Count or Sum cell values based on cell colour in Excel using VBA and Non-VBA approach Free Excel tutorials | Excel functions and formula guide | Excel cheat sheets | Excel tips and tricks #Excel

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) […]

Excel formulas have a powerful tool in conditional formatting. This article covers three ways to boost productivity with MS Excel.

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.

Oh yes, you read that right. There is a video on Just a Girl and Her Blog. What?! I've always been afraid to do video tutorials because I get all shy about having my picture taken (which is why you see the same 4 photos of me over and over ;) ) and being recorded, but I recently sucked it up and did a little screencast for my 'How to Start a Blog' page, which made me think, 'Hey! Maybe this video stuff isn't so bad after all!' {Sure, it's just my voice and not my face, but...baby steps…

A checklist is a good way to keep track of tasks. Here's 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!