Excel Formulas: 10 Formulas That Helped Me Keep My Job

Don’t waste any more hours in Microsoft Excel doing things manually. There are many ways to use Excel formulas to decrease the amount of time you spend in Excel and increase the accuracy of your data and your reports.

Excel Formulas You Should Definitely Know:

1. SUM

Also Read - The 10 most useful Excel keyboard shortcuts

Formula: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5)

The SUM formula does exactly what you would expect. It allows you to add 2 or more numbers together. You can use cell references as well in this formula.

The above shows you different examples. You can have numbers in there separated by commas and it will add them together for you, you can have cell references and as long as there are numbers in those cell it will add them together for you, or you can have a range of cells with a colon in between the 2 cells, and it will add the numbers in all the cells in the range.

Double CLick the below button to  read full post

   

If above button is'nt working then CLick here

12 Basic Shortcuts That Will Make You An Excel Guru And Add Hours To Your Life

The problem with a list of hundreds of shortcut keys is that it is overwhelming. You cannot possibly absorb 233 new shortcut keys and start using them. The following sections cover some of my favorite shortcut keys. Try to incorporate one new shortcut key every week into your Excel routine.

1) Quickly move between worksheets

Ctrl+Page Down jumps to the next worksheet. Ctrl+Page Up jumps to the previous worksheet. Say that your workbook has 12 worksheets named Jan, Feb, Mar, . . . Dec. If you are currently on the Jan worksheet, hold down Ctrl and press Page Down five times to move to Jun.

2) Jump to the bottom of data with Ctrl+Arrow

Provided there are no blank cells in your data, press Ctrl+Down Arrow to move to the last row in the data set. Use Ctrl+Up Arrow to move to the first row in the data set.

Add the Shift key to select from the current cell to the bottom. If you have data in A2:J987654 and your cursor is in A2, you can hold down Ctrl+Shift while pressing the down arrow and then the right arrow to select all the data rows but exclude the headings in row 1.

   

If the above is not working then use this link -

http://www.technoration.com/p/microsoft-excel-is-crucial-tool-for.html

20 Excel Tips for Becoming a Spreadsheet Pro

There are very, very few people on planet Earth who could ever say they’ve completely mastered every intricate little thing about Microsoft Excel. It’s the world’s premiere spreadsheet application, and has been the industry standard for over 20 years, replacing the once-venerable Lotus 1-2-3, the first killer app for PCs in the 1980s. Microsoft Excel’s dominance as a spreadsheet has yet to be truly tested, certainly not by Corel’s Quattro Pro (yes, still sold today!), especially not by the open source tools from Apache or LibreOffice, nor even by Google’s Sheets (the spreadsheet part of Google Drive).

24 Excel Keyboard Shortcuts to Help You Work Faster, Better

Spreadsheets are the lifeblood of finance departments everywhere. Whether you are an analyst with a Wall Street firm or an entrepreneur doing cost project analysis, you’ll have to use Microsoft Excel. Beginners, meanwhile, will benefit greatly from this free course on Excel.

Make working with spreadsheets a little easier with these Excel keyboard shortcuts that will have you working like the pros in no time:

How to apply different Passwords or Permissions to separate Ranges in Worksheets in Excel

Qsn: I need to share a spreadsheet with different group of people and I want only specified group access specified ranges, like sales group members should be able to edit only sales data range and human resources group members to edit personal data range. Please help me how to do it.

Ans: Apply different Passwords or Permissions to separate Ranges in a Worksheet

Change case using the mouse or the keyboard (Word 2007-2013)

To do so, start by selecting / highlighting the text, and then go to the Home tab, Font group. Locate the drop-down arrow to the right of the Change Case icon (the one with a capital letter “A” and a lower-case letter “a” side by side) and click it, then choose one of five different cases. The cases you can apply are:

How to Quickly insert a Row or Column – Excel Keyboard Shortcut

I have been trying to adapt as many Excel keyboard shortcuts as I can (not just for productivity, but for ergonomic reasons). Today we will learn how to quickly insert a new Row or Column using Keyboard Shortcuts in Excel.

Method #1

Insert Row:

1. Select a Cell or Row
2. Press [ Alt ] [ i ] [ r ] ‘keys in sequence’

Insert Column:

1. Select a Cell or Column
2. Press [ Alt ] [ i ] [ c ] ‘keys in sequence’

This is pretty simple and easy to insert a Column or Row quickly into your spreadsheet, in case you want to insert multiple Columns and Rows select required number of Rows or Columns as Step 1 then press [ Alt ] [ i ] [ r ] or [ Alt ] [ i ] [ c ]. However, if you want to delete a Row or Column Method #2 below will help you do that with two more key strokes.

Method #2

There is a two-step process that is very convenient for inserting or deleting a Row or Column:

Insert Row:

1. Select a Row: [ Shift ] + [ SpaceBar ]
2. Press [ Ctrl ] + [ Shift ] + [ = ] ‘this is equivalent of [ Ctrl ] + [ + ]’

Delete Row

1. Select a Row: [ Shift ] + [ SpaceBar ]
2. Press [ Ctrl ] + [ Shift ] + [ – ] ‘this is equivalent of [ Ctrl ] + [ _ ]’

Insert Column

1. Select a Column: [ Ctrl ] + [ SpaceBar ]
2. Press [ Ctrl ] + [ Shift ] + [ = ] ‘this is equivalent of [ Ctrl ] + [ + ]’

Delete Row

1. Select a Row: [ Ctrl ] + [ SpaceBar ]
2. Press [ Ctrl ] + [ Shift ] + [ – ] ‘this is equivalent of [ Ctrl ] + [ _ ]’

It’s easy to memorize these because Ctrl is pretty much the most powerful key there is and “+” and “-” make sense for adding and deleting. A trick for remembering which shortcut to use for selecting the Row or Column is the mnemonic that both “Ctrl” and “Column” start with “C”. Remembering the SpaceBar is easy because the SpaceBar is a long key, so it can easily represent a Row or Column.

To insert more than one Row or Column at a time, use the ArRow Keys as you hold Shift before going to step 2. You can also just hold down Ctrl+Shift as you repeating hit the “+” key, or hold down Ctrl as you repeatedly hit the “-” key.

Do you know a better way to do it? Please share it with us in comments section.