Class notes

Excel Insights: Key Formulas and Techniques

0 purchase

Course
Ms excel

Institution
Ms Excel

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.

[Show more]

Preview 4 out of 45 pages

View example

Uploaded on July 26, 2024
Number of pages 45
Written in 2022/2023
Type Class notes
Professor(s) Adam stark
Contains All classes

excelnotes
exceltips
excelshortcuts
excelformulas
exceltricks
exceltutorials
excelhelp
excelguide
excelfunctions
dataanalysisnotes
excelbasics
wall street

$7.49

Also available in package deal from $20.49

Add to cart

Add to wishlist

100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached

Also available in package deal (1)

excel materials

$ 24.77 $ 20.49 3 items

1. Summary - Master excel: from basics to advanced techniques"
2. Summary - "excel power user: advanced tips and tricks"
3. Class notes - Excel insights: key formulas and techniques
Show more

MS-EXCEL
LECTURE
NOTES

MS-EXCEL LECTURE NOTES FOR OWERRI CBT HI-TECH, OWERRI NIGERIA Page 1

,PREAMBLE

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

MS-EXCEL LECTURE NOTES FOR OWERRI CBT HI-TECH, OWERRI NIGERIA Page 2

,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.

MS-EXCEL LECTURE NOTES FOR OWERRI CBT HI-TECH, OWERRI NIGERIA Page 3

, 1.6 Worksheets

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.

MS-EXCEL LECTURE NOTES FOR OWERRI CBT HI-TECH, OWERRI NIGERIA Page 4

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69411 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling