MICROSOFT EXCEL TUTORIAL PDF 2016 HOW TO

Enter 300 and select the formatting you want to apply.Ī green fill and font color are used here, but there are lots of formatting options available. Click Home > Conditional Formatting > Highlight Cells Rules > Greater Than.ģ. Select the range of cells that you want to apply Conditional Formatting to.Ģ. You can create simple conditions to automatically format cells if a target is reached, a deadline has passed or maybe sales have decreased below a certain threshold.įor a quick example, if a value is larger than 300 we want to change the cell color to green.ġ. It helps the user get a quick understanding of the data they are looking at. Visualize key data with conditional formattingĬonditional Formatting is one of the most popular features of Excel. Now you have a drop-down list, making data entry simple and reliable.Ħ. Or select a range of cells that contain the list items. Then either type the list items into the source box separating each one with a comma. Select the range of cells you want the list to appear in.Ĥ.

MICROSOFT EXCEL TUTORIAL PDF 2016 HOW TO

Learn how to create a simple drop-down listĪ simple Excel dropdown list on a spreadsheet can make entering text much easier and, more importantly, ensure it is accurate.ġ. You can even use formulas within Conditional Formatting rules, charts, and other Excel features to make them more powerful.Ĭheck out some of our favorite Excel formulas and functions.ĥ. Once you are comfortable writing formulas, you can do almost anything. These include SUM, IF, VLOOKUP, COUNTIF, and CONCATENATE. If you aren't sure where to begin, start with creating basic calculations that add, subtract, multiply, and divide values. Then begin to learn some of the more commonly used functions. Whether it's performing basic calculations in cells or using more advanced formulas, if you know how to use these functions, you will stand head and shoulders above the rest! One of the main ways to master Excel is to be accomplished at writing formulas. And double-clicking the fill handle (the square in the bottom right corner of the cell) to copy to the bottom of a list.Įxcel has over 500 keyboard shortcuts and a whole bunch of useful tricks for speeding up how you work.Īlthough you won’t need them all, learning some to make your Excel work easier is a great idea. Two of my favorite shortcuts are Ctrl + to enter today's date in a cell.

Plus, there's Ctrl + Z to undo the last action – great for any accidental actions!Īs you begin to use these Excel shortcuts in your daily work, push yourself to learn more. Some good ones to learn are the famous copy and paste: Ctrl + C to copy and Ctrl + V to paste. If you're a beginner, then start by learning the general keyboard shortcuts. The best way to speed up your day-to-day Excel work is to learn some useful shortcuts both with the keyboard and your mouse or touchpad. Pressing the Ctrl and the Home key together will take you to the first cell in your data range. Pressing the Ctrl key and the Up, Down, Left or Right directional arrow keys together will take you to the last used cell in that direction. This is very useful to navigate large lists on Excel. If you have been using tab to move through the columns, pressing Enter will take you one row down and back to the cell in the column you started in. You can use Enter to move to the cell in the next row down. When typing data into Excel you can use the Tab key to move to the next cell in the column to the right. Need a place to start? Here's our recommendation: Learn how to navigate the Excel interface. How to master Excel quickly in 12 steps 1.

Microsoft excel tutorial pdf 2016