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. When you are comfortable writing formulas, you can do almost anything. These include SUM, IF, VLOOKUP, COUNTIF, and CONCATENATE. Then begin to learn some of the more commonly used functions. If you are new to formulas, start with creating basic calculations that add, subtract, multiply and divide values. These are the muscles of Excel.įrom performing basic calculations in cells to using more advanced formulas - you will stand head and shoulders above the rest if you have this skill. One of the main ways to master Excel is to be accomplished at writing formulas. And if you scroll to the right, column A remains visible. Now when you scroll down, the first 3 rows remain visible.
For example, if you want to freeze 3 rows and 1 column, click on cell B4.Ĭlick View > Freeze Panes > the first Freeze Panes option. You can freeze as many rows, and columns, as you need.Ĭlick in the first cell after the rows and columns you want to freeze. In the image below, we are looking at row 1259 but the headings are still visible on screen. So to freeze this area, click View > Freeze Panes > Freeze Top Row. The headings for a spreadsheet are usually just in the top row. This wonderful feature keeps your headings and other labels visible at all times as you scroll around the spreadsheet. 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. And Ctrl + Z to undo the last action.Īs you begin to use these shortcuts in your daily work, push yourself to learn more. Good ones to learn include Ctrl + C and Ctrl + V to copy and paste. If you are 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. This is very useful to navigate large lists.
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. 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. The Enter key can be used 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.
#How to use microsoft excel at work how to
How to navigate the interfaceĪ good start is to be efficient at navigating the Excel interface. How to master Excel quickly in 11 steps 1.
This article will guide you through 11 of the best tips and tricks to help you harness the power of Excel and impress your boss and work colleagues. You may, therefore, have a desire to learn how to master Excel so that you can work quicker, easier and with more efficiency. It is incredibly powerful, with more features added to it continuously.
#How to use microsoft excel at work software
Microsoft Excel is one of the world's most popular business software packages.
0 kommentar(er)
