Excel 4 Business

Excel Forms

If you've ever seen Microsoft Excel, you would describe it as a criss-cross of boxes into which you can enter data. A spreadsheet is a table. One advantage of the simple design is it allows you to analyze your data e.g. one short formula allows you to sum... Read >

Excel Files Types

Excel is Microsoft Office's in-built spreadsheet package. Over the past 20 years, Office has become so ubiquitous that their ".xls" file format has almost become a byword for a spreadsheet. Just as Word documents are saved as ".doc", so Excel files are sa... Read >

Excel and Scientific Formulas

Microsoft Excel is a fantastic tool for analyzing scientific data. Microsoft Word is a fantastic tool for writing up scientific research. So surely Microsoft Office is the only software a scientist would ever require beyond that associated with specialist... Read >

Retail Investors and Microsoft Excel

If you dabble in stocks and shares, you will probably want to keep detailed records of your investments. You may also want to experiment with different trading strategies using historical data. The only way to analyze daily share movements is to use sprea... Read >

Filtering and Analyzing Data in Excel

Microsoft Excel. Do those two words make you tremble? Do they remind you of hours wasted sifting through thousands and thousands of rows of data? Well, if they do, they shouldn’t. You can use a few simple tricks to analyze data faster than ever before. ... Read >

Excel Tables and Charts in Powerpoint and Word

Microsoft Excel is the market leading spreadsheet package. This makes it the default software for numerical analysis and reporting. It is sold as part of the wider Office suite that includes word processing (Word) and presentation software (Powerpoint). T... Read >

Why learn Excel macros?

If you are reading this, you are probably one of the 400 million users of Microsoft’s flagship spreadsheet program, Microsoft Excel. You may well have developed your own files to track the movement of cash or inventory around your own organization. Some o... Read >

Upgrading to Excel 2010

If your office is upgrading from Excel 2007 to 2010 then, relax, there aren’t any major differences between the most recent versions of Microsoft’s industry leading spreadsheet package. However, most workplaces prefer to do a double jump when upgrading so... Read >

Spreadsheet Presentation

When you first use Microsoft Excel, your primary concern is to keep a lot of numbers into a single file. You may also use spreadsheets to analyze data. If asked to identify an advanced user, most people would define an Excel expert as someone who can use ... Read >

Selling e-Consulting Services

I am an Excel consultant. I produce spreadsheets for companies all over the world and, at the start of this century, my job didn't exist. I work remotely and few of my clients ever meet me in person. The fact I don't have to travel means I have very fe... Read >