#Advanced microsoft excel training pdf how to#

Once upon a time, spreadsheets were the most tedious thing in the world. You can copy individual cells or selections of cells with Ctrl C and paste them elsewhere with Ctrl V. To delete an entire column or row (not just empty the cells of data, but completely remove the cells), hit Ctrl. You can select and entire column or row by clicking on its letter or number respectively. To delete the contents of a cell, just hit Delete. When you're done editing a cell, hit Enter to accept and move down one cell, or Tab to accept and move right one cell. If you're entering a formula, be sure to start with =. To change the contents of a selected cell, just start typing. Select multiple cells by clicking and dragging, or by holding Shift and you move your selection. You can move your selection around with the arrow keys, page up/down, and home/end. You can select a single cell by clicking it. The intersection of a column and row is a cell. All Excel spreadsheets are made of columns and rows, represented with letters and numbers respectively.

#Advanced microsoft excel training pdf how to#

It's much better to invest some time upfront to learn about Excel features that will speed up your work and automate repetitive tasks.įirst things first: let's learn how to find our way in Excel. However, choosing this path wastes your time and crushes your soul. Many tasks can be done through monotonous repetition. There are many ways to complete tasks in Excel, but some are better than others. There is a Wrong Way and a Right Way to Excel This guide is meant to go over the most commonly used Excel features for managing the datasets we work with. People come to the Tax Foundation with all sorts of backgrounds and varying levels of experience. PivotTables to Summarize and Organize Data.Using IF and Other Logical Functions to Compare Data.Using VLOOKUP to Match Data from Different Tables.Text Functions to Find, Extract, and Manipulate Text.Transposition to Flip Everything Around.Advanced Sorting to Arrange Things How You Want Them.Number Formats to Enhance Presentation and Prevent Weird Errors.

Text to columns to Separate Conjoined Values.

For an hour-long presentation of Excel skills, see this YouTube video. For more and deeper info, check out Microsoft's Excel help center. This training course is designed for incoming interns, but can serve as a handy refresher for any person looking to up their Microsoft Excel game.