NKW1709 - Excel

  Data Import to Excel Workbooks Data, millions of bits of data, in one huge amorphous mass or fragmented across multiple systems.  How to grab this and make sense of it? How many hours have been spent copying and pasting information from one spreadsheet to another?   How many times have data dumps been taken from systems in the form of CSV files, proving unmanageable and containing excessive amounts of irrelevant data, duplication or error?  There are many specialist applications out there that will take your data sources and swiftly churn out ever impressive trends, graphics and insights.  They are, however, expensive and not often  available to all employees.  A small business might not have the resources to commit to specialist packages. It's okay you can do so much in Excel with the right knowledge, training and awareness of capabilities. For example did you know? You can set up a connection between your database and an Excel workbook, no nee...

  What is conditional formatting?    In literal terms it is getting the format of a cell to change depending upon the content of the cell linked to a rule of some sort. In layman’s terms or to the person on the street it is a helpful way to point out a specific thing in your table of information.    Examples might include entries on an arrivals board at an airport that are late in arriving, examination results of the class that are above and below average and the lists of competitors in triathlon by country or team. Wouldn’t it be really handy when scanning those departure boards at the airport if the flights to Newcastle had a black background and white lettering?    You would be able to pick out the flights pretty quickly if that was the case.    Usually red lettering, numbers or background are the only indications we are given about flight status. So why use conditional formatting? Well, speaking from my own experiences, I use conditional ...