Decide on the list of information you need to keep in the Table. With your mouse highlight the entire area. Next go to the menu at the top and select insert. Now you will have an option for Table. When you select Table, Excel 2007 also lets you select a new style for the table. […]
One of the most frustrating and time-consuming jobs in an office can be creating the staff roster. With constant requests for changes because of holidays, special occasions or staff absences most administrators are too busy creating rosters to think about developing a better system. With a few lines of VBA code we’re going to create […]
Because Excel is primarily an application for data analysis, sometimes its presentation tools suffer by comparison. For example, sometimes your data has text of various length and may exceed the available printing space. This article will show you how to calculate the correct column width to ensure the text fits within the page. A typical […]
Once you've started developing VBA applications in Excel it's worth creating your own code library. Reusing procedures and functions makes sense when a little fine tuning is all you need to make the code work for a current project. There are several ways to save and organize your own code, and this article will explain […]
Plantillas de excel
If you’re serious about storing information in MS Excel it’s important you set up your data correctly from day one. By preventing duplicate entries it can save a lot of problems later on. Let’s say you’re maintaining a list of customers and you’re concerned some information may have been entered more than once. This could […]
10 Excel Tips and Tricks which are dead useful: Automatically SUM () with Alt + =: Did you know you could add an entire row or column by simply clicking the first empty cell? Click, press ALT + '=' and simply add up the numbers in every above cell. Number Formatting Keyboard Shortcuts format: There […]
We were planning for our 2009 excel course schedules when this excel calendar template idea flashes across my head. I started asking myself: Why not plan my schedule in Excel? If I could also list down all the public holidays in one section of the worksheet and the calendar can actually displayed them in red, […]
Most users manually enter either a date and time or both when they enter data onto an Excel spreadsheet for example on an invoice or a project plan. There is a quicker second way to insert a timestamp when a user updates a spreadsheet, it just needs a bit of formula knowledge. Want to learn? […]
All Excel users should be able to activate cells and input data into an Excel Worksheet – after all, these are the most basic Excel actions. However, many Excel beginners do not fully understand the difference between a cell being 'activated' and a cell being in 'edit mode'. Even the more accomplished Excel users often […]