How to use microsoft excel for beginners

How to use microsoft excel for beginners how to#

Some of the more popular Paste Special options include: To do this, copy your information as usual, but instead of using Ctrl + V, right click and select Paste Special from the menu. Instead of copying everything and removing what you donвЂ™t want, you can use Paste Special. Say you want to copy and paste something but not everything like a just a number or format. As if Ctrl + C and Ctrl + V didnвЂ™t make copying easy enough, Microsoft built Paste Special. Consider the simple copy and paste functions. There are so many different ways to accomplish tasks in Excel. This is useful if youвЂ™ve changed your spreadsheet and want to add more to printable area. In the same drop-down menu, thereвЂ™s the option to clear the print area. On the Page Layout ribbon, click the drop-down under Print Area and select Set Print Area. To set your print area, highlight the cells you want printed. If you like to keep all your work on one spreadsheet but only need to print out a certain portion, setting the print area is a great way to save time when you hit Ctrl + P.

How to use microsoft excel for beginners how to#

Now that you know how to automatically update what prints in the margin, another time-saving trick is set up print areas for your tabs to update what prints within the margins. Next, add the following text to your header footer: File name To make sure you donвЂ™t have to update these values every time you need to print a spreadsheet, you can add formulas that update automatically.ДЇirst, change your view of Excel so you can see the header and footer. One of the best ways to keep track of what's printed out of Excel is by adding page numbers, timestamps and file paths to the header or footer.

While it seems everything is going paperless, sometimes thereвЂ™s still a need to print. Just filter on the date column and select your desired time frame.ДЇrom our example, you can quickly see there were only two orders in September 2014. For example, let's say you wanted to see how many orders were made in a certain time frame. Here, you can select different values in the table and sort them. Now there will be a drop-down arrow at the top of each column in the filter. Then, click the funnel icon in the top left of the Home ribbon. To do this, highlight all the data you want included in the filter (a quick way to do this is Ctrl + A). This is so useful because it allows you to rearrange and summarize data in a way thatвЂ™s actually useful. ExcelвЂ™s basic function for handling all this information is the Sort & Filter function. Speaking of a lot of data, Microsoft has amazing tools to handle it all, which probably explains why it became the most important workplace computer program around the world. With your customized QAT youвЂ™ll be blazing through your next spreadsheet with ease. Once you have your favorites added, you can also rearrange your QAT shortcuts by right-clicking on it and then clicking вЂњCustomize Quick Access Toolbar.вЂќ in the menu. One of my personal favorites in my QAT is the Sort & Filter function as I usually work with a lot of data. Microsoft offers several ways to make this happen but the easiest way is to right-click on what you want to add and select вЂњAdd to Quick Access ToolbarвЂќ. Instead of switching between the different tabs of the ribbon every time, you can add your personal favorites to whatвЂ™s known as the Quick Access Toolbar. But most beginners use just a few of these repetitively. Looking around any version of Excel youвЂ™ll notice thereвЂ™s an endless array of tools at your fingertips. Adding frequent actions to quick access toolbar