Leave a Reply

    Your email address will not be published. Required fields are marked *

    The Absolute Beginner’s Guide to Microsoft Excel Spreadsheets

    Sep 8th, 2015 / Data Analysis / , ,
    The Absolute Beginner's Guide to Spreadsheets

    If you use spreadsheets on a daily basis, this post isn’t for you.

    Within the past year I’ve led 61 trainings (and counting!) about both data analysis/statistics and data visualization. In each session, there’s one person who’s enthusiastically eager to learn but has almost zero experience with spreadsheets. Spreadsheet novices, rejoice! This one’s for you.

    Key Spreadsheet Terminology

    Sometimes Excel novices say that learning to use Excel is like learning a new language. Here are some key Excel terms to get you off to a good start.

    Your entire Excel file is called an Excel workbook.

    Your workbook will probably include multiple sheets. When you open a new file, you’ll see Sheet1, Sheet2, and Sheet3 included along the bottom of your screen.

    Your sheets are organized into tabular Columns and Rows.

    Tabs are displayed across the top of your Excel workbook. Each tab contains a variety of incredible features. For example, the Home tab contains features that let you format text and numbers. The Page Layout tab is where you adjust printer settings and the Data tab contains a sorting button.

    Finally, the Formula Bar is where you’ll get to view formulas that are typed into your spreadsheet.

    Ann K. Emery on key Excel terminology
    Basic Text Formatting

    Novices are often pleasantly surprised to learn how many similarities exist between Microsoft products like Excel, Word, and PowerPoint. Whether you need to format text, adjust colors, or insert images, you can apply your existing Word and PowerPoint skills as you begin using Excel.

    Just like with Word and PowerPoint, you’re not stuck with regular ol’ text inside of Excel. You can adjust some or all of your spreadsheet’s contents to bold, italic, or underlined numbers and letters.

    Ann K. Emery on basic text formatting (bold, underline, italic) within Excel
    Adjusting Colors

    Colors are highly customizable in Excel, just like in Word and PowerPoint. Change your font’s color with the Font Color button on the Home tab. Or, fill in your cells with the Fill Color button on the Home tab.

    Ann K. Emery on formatting colors in Excel
    Inserting Images

    Want to include your organization’s logo within your spreadsheet? Images are just as easy to use in Excel as in Word and PowerPoint. Head over to the Insert tab and click the Pictures button. Then continue formatting your image — re-sizing, re-coloring, flipping, etc. — just like you normally would.

    Ann K. Emery on inserting image files into your Excel spreadsheet

    Building Diagrams with SmartArt

    I primarily use SmartArt within my PowerPoint slides or Word documents, but sometimes diagrams are helpful in my Excel file, too. Head over to the Insert tab and click the SmartArt button to see all your options. I tweak each diagram’s colors and fonts for a customized look.

    Building diagrams with Excel's SmartArt

    Inserting Hyperlinks

    It’s easy to include hyperlinks inside your spreadsheet. Just type the link, and when you hit Enter on your keyboard, the text will magically turn itself into a hyperlink. Right-click on the hyperlink and select Edit Hyperlink to display new text for the link, like Link to Udemy text from our example. If you don’t need the hyperlink anymore, simply delete the cell’s text, or just right-click on your link and select Remove Hyperlink.

    Ann K. Emery on inserting hyperlinks into your Excel spreadsheet


      Leave a Reply

      Your email address will not be published. Required fields are marked *

      Related Courses

      Most “professional” reports are too long, dense, and jargony. Transform your reports with these practical tips. You’ll never look at reports the same way again.

      Learn More

      From spreadsheet stress to superstardom in just 12 weeks. Data analysis techniques & time-saving secrets for busy number-crunchers.

      Learn More


      #f-post-el-35{display:none !important}

      #f-post-el-35{display:none !important}

      Learn More