Microsoft Excel is a tool that can turn you, a nameless face at your company, into a rock star. By knowing how to organize, manipulate, and present data in a relevant and easy to view manner, you can become the go to person in your organization that managers and C-level executives learn to trust and reward.
Every journey, including the journey to becoming your company's Excel guru, starts with the first step. In the case of Microsoft Excel, the first step is making sure you have a solid understanding of the Excel User Interface. This quick Excel User Interface training guide will help you develop a good foundation to build upon when you attend our Excel Basic, Excel Intermediate, and Excel Advanced training classes.
The Microsoft Excel user interface (UI) contains all of the work spaces and commands that you will use to create and work with workbooks and worksheets. The general areas along the top and bottom of the Excel User Interface contain elements that display information about the current workbook and provide you with access to some of the more commonly used commands and tools.
The following list describes the function of elements of the Excel UI.
Title Bar: Displays the workbook file name
Quick Access Toolbar: Provides you with an easy access to commonly used Excel commands, such as Save, Undo, and Redo. You can customize the Quick Access Toolbar to suit your needs.
Ribbon: Provides you with access to the most commonly used commands for working with excel workbooks and worksheets. The ribbon is organized into a series of tabs, each containing groups of related commands. You can customize the ribbon to suit your needs.
Formula Bar: Displays the contents of the currently selected cell in a worksheet. You can also use the Formula Bar to edit cell contents.
Name Box: Displays the cell reference for the currently selected cell, or the cell reference of the active cell in the currently selected range. The Name Box can also display custom range names and can be used to navigate to a particular cell.
Status Bar: Displays the status of various conditions pertinent to Excel, such as the mode of the active cell, and whether or not Caps Lock or Number Lock is enabled. You can customize what information is displayed on the status bar.
View and zoom controls: Provide you with quick access commands that change the current workbook view and change the magnification level of the displayed worksheet.
Column Headers: Identify each separate column with a unique letter or letter combination.
Row Headers: Identify each separate row with a unique number.
Select All button: Selects all cells in the worksheet.
Scroll bars: Navigate vertically and horizontally across worksheets.
Worksheet tab navigation controls: Navigate among the various worksheets within a workbook.
Worksheet tabs: Open a particular worksheet within the workbook. You can also use worksheet tabs to name, rename, and arrange worksheets, and you can apply certain formatting options to the tabs.
New Sheet button: Adds a blank worksheet to the workbook.
More about Expand Learning and our Excel Training We invite you to attend Microsoft Excel training in Salt Lake City, Utah. Our locally owned and operated classroom is designed to allow you to get the most out of your Excel class with training delivered by local Excel pros.
Attend a Microsoft Excel class in our Salt Lake City, Utah facility and learn to organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. You will also learn to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.
Expand Learning Solutions offers local instructor-led training classes in Salt Lake City, Utah for all available Excel versions. We offer 3 levels of Excel, including:Excel Basic, Intermediate, and Advanced classes. We also offer 2 day Excel VBA (Excel Programming with Visual Basic for Applications).
If you can't attend at our facility, we still have you covered with Microsoft Excel Training via live online options and self-paced options.