Excel Essentials - Starting Excel
These topics are covered in Module 1 - Excel Essentials, part of our Introductory Excel Level 1 class.
To work with Excel effectively, you need to know several basic skills and concepts; how to start Excel from the Windows desktop, how to make the most of the Excel interface, how worksheets are used, and how to select cells and ranges.Please call us on 888.815.0604 to register for an Excel class in Chicago or Los Angeles.
Once you are in Windows, starting Excel is a matter of a few clicks.
To load Excel:
- On the taskbar, click the Start button.
- From the Start Menu, point to Programs.
- From the Programs menu, choose Microsoft Excel.
Starting Excel from Windows 8 Only.
In Windows 8 you have no Start Menu, therefore you are unable to start Excel using the above method. The Start Menu is replaced but a Start Screen that contains a number of "Tiles".
To load Excel (Win 8 Only):
- If you are not on your Start Screen press the Windows Key on your Keyboard to return to it..
- From the Start Screen scroll across using your mouse or touch screen to the correct tile.
- Click the mouse or touch the screen (Touch screen only) on the Microsoft Excel 2013 tile.
A worksheet is the electronic equivalent of a paper ledger. It is a powerful platform used to enter, analyze, calculate, and manipulate data. A worksheet can be used for basic calculations such as addition and subtraction, as well as more complicated applications like statistics, audits, or mortgage tables. Moreover, worksheets allow you to quickly format your data into effective business reports.
For more support, or for professional Excel Training Courses in LA and Chicago please contact us.
A worksheet is a grid of 1, 048, 576 rows and 16, 384 columns. The rows are labeled with numbers (1, 2, 3, ...) and the columns are labeled with letters (A, B, C, ..., AA, AB, AC,...), as illustrated in Figure1-1. The intersection of a row and column is a cell, the basic unit for storing data. The highlighted column and row headings indicate the active cell. You'll find the active cell's cell reference in the Name box. The cell reference consists of the highlighted column letter and row number, in this case D9. A range is a rectangular group of cells; the range reference is derived from the cell references of top left cell and the bottom right cell separated by a colon.
The illustration below is how the section of the worksheet would be seen in Microsoft Excel version 2013.
Above - the section of worksheet as actually seen in Microsoft Excel version 2013. Note that the selected areas are shaded a soft gray. This is so that the user can clearly see the contents of selected cells and ranges and even formatting. See example below for an enhanced view of selected formatted cells.
A workbook is a collection of worksheets stored in the same file. These worksheets may contain different types of information, but they are usually related in some fashion. For example, each worksheet of a sales workbook may contain sales data for a specific division.
Workbooks can contain an unlimited number of worksheets, depending on worksheet size and the amount of memory your computer has. Besides worksheets, a workbook can include chart sheets, Visual Basic modules, dialog box sheets, macro modules, and scenario report sheets.
Why learn Microsoft Excel?
Microsoft Excel is one of the most commonly used software programs in the World. Most office administration, clerical, analytical, accounting and finance jobs require a good understanding of Excel.
Our classes are taught by live face-to-face trainers which means there is an actual trainer in the room. Each student will work on their own workstation and the learning experience will be totally hands-on.
Included with all our workshops are training materials, certificate of course completion and a free repeat - if you decide you a need a refresher after a couple of months.
There are 4 different levels of Excel training. For more information about what is covered in each level please click on the links below.
We hope to see you on an Excel class soon!
Related Excel Learnings
The Excel Interface
Opening Excel Workbooks
Excel Data Entry
Selections in Excel
Saving files in Excel
Printing and Exiting Excel
Building Formulas in Excel
Copying Excel Formulas
Work with Basic Functions