The Home Menu – This is where you land by default when you open a workbook (and what you see in the image above). Most of the functionality is the same, however. If you are using a different version of MS Excel than Excel 2010, some of the items called out in the image above may appear different, or in different locations. While there are a lot of menus, buttons, and icons available when you look at the default workbook window, for now there are only a few important ones we will focus on. When you save an Excel file, the Workbook is what you are saving. All of the core functionality we associate with the Excel application occurs within the Workbook. Each Workbook you create contains one or more Worksheets. The Workbook is the basic container for the work you do in Microsoft Excel. There is significant risk of purchasing illegal or pirated software from those sites.īecause this post is rather long, I have provided some navigation aids here and at the end of each section to save you (and your mouse wheel) from excessive scrolling. I STRONGLY recommend against purchasing software from Craigslist or EBay. You can find many deals on-line, or even support my efforts with this site by using the links above to buy directly from Microsoft. If you do not have Microsoft Excel on you machine, or if you are using an older version (I use Excel 2010 throughout this series) you might consider purchasing a copy. This post is targeted at entry-level users with minimal familiarity with the program, and we will be covering some very basic concepts related to the structure of a Workbook, some essential navigation items, and core menus required to use the program. In this post we will take a high-level look at the structure of the basic Excel application, workbooks, worksheets, and how they all relate together. The good news is that it does not take a science degree to become proficient with the more advanced features of Excel, nor is such proficiency beyond the grasp of most users. While many applicants claim to possess some level of proficiency or familiarity with Excel, the truth is that many are merely familiar with the program, know how to create lists, and possibly add a few numbers together. If you are one of these people, you are missing out, and most likely working much harder than you need to.Īs an additional consideration, employees who demonstrate a facility with data manipulation and analysis know-how increase their desirability and value to employers. Some people use spreadsheets to present and layout data in a pleasing grid-like manner, and to apply pretty colors and formatting. For many people a spreadsheet is nothing more than a handy way to create and organize lists. Spreadsheets are misunderstood by the majority of people who use them. Anyone hoping to read programming stuff is just going to have to wait. This is driven by my need to prepare a training for my staff at work, and in keeping with the DRY principle (Don’t Repeat Yourself) I am killing two birds with one stone. Somehow, I thought it was going to be more glamorous than this. Having represented this site as a technology blog with a focus on programming and software development, I find myself starting off with a tutorial on Excel basics instead.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |