|
Our newsletter is produced on a monthly basis for our subscribers. It's objective is to provide an invaluable source of information and advice on office automation through the use of Microsoft® Excel.
We hope you find the newsletter informative and useful. Please tell us what you think via Contact Us.
If you are not a subscriber then use the following link to Register as a member to our website and you will be included to the subscription list for our monthly newsletter
After you have a developed an Excel spreadsheet that is going to be used by others you should consider protecting the spreadsheet to guard against any unplanned changes to formulas and formatting by less experienced users. Excel's Cell Protection feature can provide this functionality ensuring that critical formulas are not inadvertently changed when using the spreadsheet. In this month's newsletter I will demonstrate Excel's Cell Protection and how it can be used to protect your spreadsheet.
For past newsletters access via the following links
Rather than trying to remember the cells specific reference eg C27, you can create a Name for that cell that can be used in the workbook to reference that cell. For example if the worksheet contains Sales Data and the cell in question is the total of sales for all sales staff it may be called TotalSales. Then wherever we need to use that value we can refer to the name rather then the specific cell reference.
One of the lesser known features of Excel is "Goal Seek". This feature is very useful when attempting to determine what specific values are required to acheive another result within an worksheet.
Invalid and inconsistent data is one of most common problems in Spreadsheets. If the data supplied is not in the right format or is not entered consistently then any following formula's or calculations will either not work or worse still provide a result that is not correct.
One of the little known and used features of Excel is the Web Query. This feature enables you to setup a standard query that will when needed visit a web page and extract data from that web page for use in your Excel workbook.
Dashboard reporting can help your business focus on their key performance areas. In this month's newsletter we demonstrate how Microsoft Excel can be used to deliver a simple and cost effective Dashboard reporting solution.
The "Invoice Generator" provides a simple and effective business tool to create, manage and track invoices for your customers. The system allows for the storage of customer details, product descriptions and service costs along with exchange rate functionality that enables invoices to be created for international clients.
Excel Template that will help you keep track of all those personal and business things that need to get done. The "To Do List" template provides a method to organise, prioritise and track the activities that are important in our lives.
Keeping track of time and effort for a business is a key aspect in determining profitability. A system and process to record and report on employees time is critical to that measurement. Excel provides some basic time recording templates
Did you know that Microsoft Excel provides FREE Excel templates pre-installed and available for your use. In this month's newsletter we will demonstrate how useful these standard templates can be.
In this months newsletter we describe some little known features of Excel that could help you in developing more efficient and effective spreadsheets...
The Mortgage Calculator will enable you to quickly determine the payments and interest required on a mortgage or loan. You can specify standard loan variables like loan amount and interest rate, as well as things like one-off payments or increased payments.
Does your business perform work for clients or customers ? Do you keep an accurate record of the time spent by your staff as they work for those clients and customers ? Do you know which clients and projects are the most profitable for your business ?
This month we develop a Macro that will extend that basic Data Sort functionality that is provided by Excel 2003.
This month we develop a Macro that will split a list of Names into two (2) columns one for the First Name and one for the Last Name. This type of Macro can be very useful when trying to create Mailing lists from source data that is not in the right format.
Macro's are a powerful tool within Excel that can allow you to perform complex tasks with the click of button. A Macro is simply a series of commands recorded into a script that is executed when required.
Named Ranges are a powerful tool within Excel that allow you to specify meaningful names for a cell or a range of cells within your Worksheet.
For many users of Excel the restricted default sort option can often not provide the flexibility that is needed when performing complicated data analysis tasks.
Microsoft Excel and Access offer a powerful data analysis tool that enables interactive reporting on large amounts of data. The Pivot Table/Chart tool is typically used to analyse transactional information allowing the user to view the data in many different ways.
It's amazing how many organisations have invested money in office software such as Excel, Word, Powerpoint and Outlook, but are not using it effectively. So much more can be achieved to further automate and enhance your business using the software you already have ....... If you know how!
|
