background preloader

Excel

Facebook Twitter

Top 40 of the Best Excel Shortcuts You Need to Know. [Image Source: Hooton & Microsoft] Almost everyone uses Excel in some form or fashion in the modern workforce, but many of us may be wasting a little too much time trying to format those pesky spreadsheets.

Top 40 of the Best Excel Shortcuts You Need to Know

In order to help you work a little bit faster, or maybe more efficiently, we have assembled 40 of the best Excel shortcuts that you need to know! F2 : Edit selected cell F4 : Repeat last edit F9 : Calculates all worksheets F11 : New chart ALT : Access the ribbon for formulas ALT + = : Automatically SUM() selected ALT + Enter : Start a new line in the same cell ALT + o-c-a : Auto size columns PG + UP/PG+DOWN : Go to next/previous worksheet CTRL + ` : Display Formulas CTRL + Backspace : Show active cell CTRL + Shift + # : Change Date format with day, month and year. CTRL + K : To insert Hyperlink. CTRL+ Shift + $ : Applies the currency format to the selected cells. Best Hidden Tricks in Microsoft Excel. [Image Source: Wikimedia and George Burruss] Most of us are probably familiar with Excel, but not knowing the shortcuts and tricks can turn any simple spreadsheet into a long drawn-out process.

Best Hidden Tricks in Microsoft Excel

We have put together some of the best hidden tricks in Excel that you may not have known about. New Line in a Single Cell When typing in cells, sometimes your text may need to run over to the next line. If you have ever tried to do this, when you press enter, Excel reads this as you moving on to the next cell and it inserts the following text there. Quick Calculations Most of us have probably run into the issue of needing the sum of two different cells, but not wanting to have to go through the trouble of writing a whole new formula in another cell for it.

Microsoft Excel. How to import a table from PDF into Excel. Many sources of data are PDF files.

How to import a table from PDF into Excel

It is possible to convert tables from such files into Excel and then manipulate the data as required. The conversion process involves moving the data first into Word and then into Excel. The following describes the steps you will need to take. To illustrate these steps, Table 10 from the European Economy Statistical Annex is used. This shows economic growth rates for all 27 EU countries plus the USA and Japan (see site 5 in our links to free economic data) Step 1: Open the relevant PDF file and select and copy table The first page of Table 10 from the Spring 2007 version of the European Economy Statistical Annex is shown below.

To copy the table, click on Select and click and drag the cursor to highlight the whole table. Step 2: Copy this into Word and convert to a table Open a new Word document and paste the copied text by pressing Ctrl V. A table will appear (poorly formatted) which will be all highlighted. Free Excel Templates and Spreadsheets. Looking for free Microsoft Excel ® templates?

Free Excel Templates and Spreadsheets

This page lists all the popular spreadsheet templates and calculators created by Vertex42.com, along with other places where you can find free Excel templates and spreadsheets. If you are looking for solutions for your business, see the Business Templates page. Advertisement. Invoice Templates for Excel. Browse our large collection of free invoice templates.

Invoice Templates for Excel

Our selection ranges from invoices for service providers to billing statements and rent receipts for landlords. If you are looking for a simple low-cost solution for invoicing your clients, these invoice and billing templates are a great place to start. Advertisement Vertex42's collection of invoice templates were designed to work in almost all spreadsheet programs, including OpenOffice and Google Spreadsheets! Most of them also work in the new mobile apps for Office, such as Excel for iPad and iPhone.

New Invoice Templates Billing Invoice Template This billing invoice provides a simple tool for freelance services, accounting, and other small businesses looking for an invoice solution that is easy to customize. Basic Invoice Template This basic invoice provides an extremely simple design, including only the most critical elements of an invoice. Invoice Templates Simple Invoice The "Bold" theme for our new easy-to-use invoice template.