This collection of notes provides essential tips, shortcuts, and advanced techniques for mastering Excel. Perfect for quick reference, it covers everything from basic functions to complex formulas and data analysis, helping users streamline their spreadsheet skills and enhance productivity.
Microsoft Excel is an electronic spreadsheet. You can use it to organize your data
into rows and columns. You can also use it to perform mathematical calculations
quickly. This course teaches Microsoft Excel basics as a prelude to the use of
Statistical Analysis System (SAS) software in carrying out more complex statistical
analysis. Although knowledge of how to navigate in a Windows environment is
helpful, this manual is created for the computer novice.
At the end of the course, participants are expected to know how to use Microsoft
Excel to:
Enter text and numbers in a spreadsheet
Enter Excel formulas
Format data
Create Excel functions
Fill cells automatically
Print results
Create Charts, and
Enter advanced Excel formulas
Accordingly, the course is divided into the following five (5) sections.
Section 1: Entering Text and Numbers
Section 2: Entering Excel Formulas and Formatting Data
Section 3: Creating Excel Functions, Filling Cells, and Printing
Section 4: Creating Charts
Section 5: More on Entering Excel Formulas
Section 1: Entering Text and Numbers
1.1 The Microsoft Excel Window
This Section will introduce you to the Excel window. To begin this Section, start
Microsoft Excel 2007 as follows:
1. Click on Microsoft Start Button
2. Point the mouse on All Programs
3. Click on Microsoft Office
4. Click on Microsoft Excel 2007
,The Microsoft Excel window appears and your screen looks similar to the one shown
here.
1.2 The Microsoft Office Button
In the upper-left corner of the Excel 2007 window is the Microsoft Office button.
When you click the button, a menu appears. You can use the menu to create a new
file, open an existing file, save a file, print and perform many other tasks.
1.3 The Quick Access Toolbar
Next to the Microsoft Office button is the Quick Access toolbar. The Quick Access
toolbar gives you quick access to commands you frequently use.
1.4 The Title Bar
Next to the Quick Access toolbar is the Title bar. On the Title bar, Microsoft Excel
displays the name of the workbook you are currently using. At the top of the Excel
window, you should see "Book 1 - Microsoft Excel" or a similar name.
1.5 The Ribbon
In Microsoft Excel 2007, you use the Ribbon to issue commands. The Ribbon is
located near the top of the Excel window, below the Quick Access toolbar.
Microsoft Excel consists of worksheets. Each worksheet contains columns and rows.
The columns are lettered A to Z and then continuing with AA, AB, AC and so on; the
rows are numbered 1 to 1,048,576.
The combination of a column coordinate and a row coordinate make up a cell
address. For example, the cell located in the upper-left corner of the worksheet is
cell A1, meaning column A, row 1. Cell E10 is located under column E on row 10.
You enter your data into the cells on the worksheet.
1.7 The Formula Bar
If the Formula bar is turned on, the cell address of the cell you are in displays in the
Name box which is located on the left side of the Formula bar. Cell entries display
on the right side of the Formula bar.
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller alexcrew1100. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.49. You're not tied to anything after your purchase.
