![\"African-American](\"https:\/\/blogarchive.utc.edu\/center-professional-education\/files\/2020\/05\/header-2.jpg\")
<\/p>\n<\/p>\n
Have you ever struggled with knowing how to use Excel to enhance your workflow? Stephanie Chastain, CPE\u2019s Excel instructor, joined us for Workstation and shared tips that will help you increase efficiency and have a better overall understanding of Excel. I have broken down the tips she shared into a series of blogs with easy-to-follow steps, and you can use the timestamps I included to follow along with the webinar recordings<\/a>!<\/p>\n In Session 1,<\/a> Stephanie focused on sharing productivity hacks to save you time.<\/p>\n NOTE: Stephanie assumes viewers know basic Excel terminology (for example, how you work in a workbook and create worksheets within a workbook). She also shares a disclaimer that there are multiple ways of doing the things she shares about, but she is sharing the method(s) that she thinks is easiest.<\/strong><\/p>\n First, Stephanie hits different topics regarding worksheets and Excel, like renaming, creating, deleting, and searching for worksheets.<\/p>\n When you open a workbook, you will have a default worksheet set up for you (Sheet1). To rename the sheet, you will:<\/p>\n or<\/strong><\/p>\n <\/p>\n There are times when you need more than one sheet in your workbook. To add new sheets to your workbook quickly, you will:<\/p>\n NOTE: Anytime you select insert in Excel, if you’re working with a column, things will be inserted to the left of the column; if you’re working with a row, things will be inserted above the row. Think about where you want things inserted ahead of time.<\/strong><\/p>\n Stephanie also shares another shortcut trick for inserting sheets individually at the 8:30 mark; if you click on the plus sign next to the worksheet tabs, a new sheet will be inserted to the right.<\/p>\n \u00a0<\/strong><\/p>\n Click and drag worksheet tabs to reorder them.<\/p>\n <\/p>\n If you want to insert multiple sheets, choose how many you want to add, and that number of sheets will be added for you by doing the following:<\/p>\n NOTE: If you click, hold the shift key down, and click again, everything will be highlighted between the two clicks. Then, your next action will be applied to everything highlighted.<\/strong><\/p>\n <\/p>\n While Stephanie doesn\u2019t visually show the viewer this, it\u2019s inferred that this would be the same process as inserting a row of sheets, except you would delete instead of insert, and ignore step 7.<\/p>\n <\/p>\n <\/p>\n Let\u2019s say that you know you always want to start out with six tabs in your worksheet. To change the default number of worksheets that show when you open Excel:<\/p>\n <\/p>\n In the bottom left-hand corner, to the left of the worksheet titles, there are two navigation buttons shaped like arrows. The arrows won\u2019t be clickable until you have enough worksheets that the worksheet titles expand past the bottom area and you can no longer see them all. If you have a larger number of worksheets, you can:<\/p>\n The autofill handle is what allows you to quickly populate cells with data without having to manually enter every piece of individual data.<\/p>\n To alleviate having to type 1 into a cell, then hit the down arrow, type 2 into a cell, hit the down arrow, and so on, you can:<\/p>\n Note: Stephanie talks more in-depth about this in her Excel courses,<\/a> but there are ways to customize Excel to autofill data with certain words using whatever nomenclature you used for abbreviations. (For example, months and quarters are commonly used words). (21:02)<\/strong><\/p>\n Stephanie also shared productivity hacks for columns and rows.<\/p>\n Inserting columns and rows is a similar process to adding worksheet tabs at the bottom of your Excel sheet. If you want to insert more than one column (for example, four columns), you would:<\/p>\n This process applies to inserting rows. It also applies to the deleting process, except you would select Delete rather than Insert. It\u2019s also important to remember the \u201cleft and above\u201d insertion tip Stephanie shared.<\/p>\n <\/p>\n To quickly resize to the largest entry in a column:<\/p>\n <\/p>\n To select your entire spreadsheet, click on the arrow shape that is to the left of A and above the 1. That will quickly select everything in your spreadsheet so you can easily change all of your data at once. You can bold all text, change the color of your text, etc.<\/p>\n NOTE: Once you click on the triangle, you can then double-click anywhere on your spreadsheet between two columns and rows and it will automatically resize to the largest entry in your columns and rows. This saves you from clicking and dragging! <\/strong>Also, when your whole spreadsheet is selected, if you click or drag the width of any column, it will resize everything to the same width of the column that you resized!<\/strong><\/p>\n Hi! My name is Marah Whitaker (think Laura with an M). I am the Marketing Assistant for UTC Center for Professional Education. During the workday, I spend time writing blog posts, creating content for social media, <\/span>developing<\/span>\u00a0email campaigns, and building relationships with our customer base.<\/span>\u00a0<\/span>During my free time, you can find me getting lost in a good book, having spontaneous dance parties, playing piano, and going to Buffalo Wild Wings on Wing Night.<\/span>\u00a0Professionally and personally, I\u00a0<\/span>aspire<\/span>\u00a0to live by the Mr.\u00a0<\/span>Feeny<\/span>\u00a0quote, \u201cDream. Believe. Try. Do Good.\u201d I strive to use my passions to\u00a0<\/span>serve<\/span>\u00a0others and contribute positively to the world around me.<\/span>\u00a0<\/span><\/p>\n Connect with m<\/span>e<\/span>\u00a0on\u00a0<\/span>LinkedIn.<\/span><\/a>\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":" Have you ever struggled with knowing how to use Excel to enhance your workflow? Stephanie Chastain, CPE\u2019s Excel instructor, joined us for Workstation and shared tips that will help you increase efficiency and have a better overall understanding of Excel. I have broken down the tips she shared into a series of blogs with easy-to-follow… <\/p>\n
\nSESSION 1 TABLE OF CONTENTS<\/strong><\/span><\/h2>\n
DIFFERENT WORKSHEETS IN EXCEL<\/strong><\/span><\/h3>\n
\n
USING THE AUTOFILL HANDLE<\/strong><\/span><\/h3>\n
\n
COLUMNS & ROWS<\/strong><\/span><\/h3>\n
\n
\nDIFFERENT WORKSHEETS IN EXCEL<\/strong><\/span><\/h3>\n
\n
RENAMING SHEETS<\/strong><\/span> (5:05)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\n
\n
INSERTING SHEETS INDIVIDUALLY<\/span> (6:26)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\n
REORDERING SHEETS<\/span> (7:50)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
INSERTING A ROW OF SHEETS<\/span> (10:52)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\n
DELETING A ROW OF SHEETS<\/span> (11:34)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\n
DELETING MULTIPLE SHEETS THAT ARE NOT IN A ROW<\/span> (11:54)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\n
CHANGING YOUR DEFAULT NUMBER OF WORKSHEETS<\/span> (12:58)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\n
NAVIGATING YOUR WORKSHEETS<\/span> (15:50)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\nUSING THE AUTOFILL HANDLE<\/strong><\/span><\/h3>\n
\n
USING THE AUTOFILL HANDLE TO NUMBER LINES<\/strong><\/span> (19:30)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\nCOLUMNS & ROWS<\/strong><\/span><\/h3>\n
\n
INSERTING COLUMNS AND ROWS<\/span>\u00a0(22:48)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\n
RESIZING COLUMNS<\/span>\u00a0(23:54)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\n
SELECTING YOUR WHOLE SPREADSHEET<\/span> (24:43<\/strong>)<\/h4>\n<\/li>\n<\/ul>\n
\nABOUT THE AUTHOR:<\/h4>\n
![\"Marah](\"https:\/\/blogarchive.utc.edu\/center-professional-education\/files\/2020\/06\/bio.png\")
<\/span><\/p>\n