We Excel

Excel Shortcut Keys

Hi to all my loyal readers.

There have been a few addional updates to the the list of shortcuts for Office 2007. As many are not familiar with some of the new shortcuts I thought I would post the list on the blog. Click on Read the rest of this entry below to view the list.  If you would like shortcuts for other programs please drop me a comment or an email. Read the rest of this entry »

Microsoft Excel Training on Cell References

Cell referencing is a usual challenge to beginners of Excel. On my training courses I often draw the analogey to learning how to drive with gears. At first you have to think carefully and concentrate, but it soon becomes instinctive. I beleive the same is true for realtive and absolute formulas.

Read the rest of this entry »

How to write a formula to calculate the last day of the month for a given date

This article will describe a simple formula to calculate the last day of the month of any date.

The complication arises due to the fact that months may have 28, 29,30 or 31 days.

I will take you through the thought process of getting to the final formula.

Read the rest of this entry »

Proud Father

This is highly unprofessional but I could not resist bragging about my son who has started his own blog at the age of 11 years old.

He is enthusiastic about photography and has started a blog on the topic.

Please go and check it out on www.kidzphotography.co.za

Cell Formatting

Right clicking on any cell or range of cells will display a menu option of Format Cells.

This menu gives users access to the following fuctionality:

1. Format of the content of the cell e.g. text, number, date etc
2. Alignment of the content of the cell
3. Choice of font
4. Cell borders
5. Cell fill
6. Cell protection

Many of these features will be discussed in detail in future articles, however a very useful shortcut to get to this menu is the key combination of Ctrl+1

Vulnerabilities in Microsoft Office Excel Could Cause Remote Code Execution

Microsoft Security Bulletin MS09-009 – Critical

Version: 1.0

General Information

Executive Summary

This security update resolves a privately reported and a publicly disclosed vulnerability. The vulnerabilities could allow remote code execution if the user opens a specially crafted Excel file. An attacker who successfully exploited these vulnerabilities could take complete control of an affected system. An attacker could then install programs; view, change, or delete data; or create new accounts with full user rights. Users whose accounts are configured to have fewer user rights on the system could be less impacted than users who operate with administrative user rights.

Read the rest of this entry »

Page Break Preview in Office 2007

During many of the training sessions I give, a common question has been where the “Page Break Preview” option has been hidden in Office 2007.

Many people used to access it from the button on the top of the print preview screen (Excel 2003 and prior). It is longer there.

It can now be found in one of two places.

Read the rest of this entry »

New Beginnings

WeExcel has been developing in the Excel for 10 years. Our solutions are advanced and specialised in the Excel environments. We wish to share these skills, tips and tricks with others.

We encourage people to share this blog with others as well as post comments and questions.

We will from time to time post challenges out to the general public as well as ask people to vote on issues.

We also intend to share the good, the bad and the ugly issues surrounding Excel. Microsoft has done superb work on Excel yet there are issues that need to be addressed, and we hope that discussions around these issues will encourage Microsoft to take note and address them.

We hope that people find this blog usefull.