Scribd
Upload
25 views2 pages

00 - Excel Tutorial Menu

This document outlines the tutorial menu for learning Excel, including sections on spreadsheet basics, customizing Excel, modifying worksheets, formatting cells, formulas and functions, sorting and filling cells, adding graphics, creating charts, setting page properties and printing, and keyboard shortcuts. Key topics covered include screen elements, adding and renaming worksheets, the standard toolbar, recording and running macros, moving through and modifying cells, formatting cells using various tools, creating formulas and functions, sorting data, autofilling cells, inserting clip art and images, using the Chart Wizard to create and format charts, setting print options like page breaks and orientation, and more.

Uploaded by

piping1234
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
25 views2 pages

00 - Excel Tutorial Menu

This document outlines the tutorial menu for learning Excel, including sections on spreadsheet basics, customizing Excel, modifying worksheets, formatting cells, formulas and functions, sorting and filling cells, adding graphics, creating charts, setting page properties and printing, and keyboard shortcuts. Key topics covered include screen elements, adding and renaming worksheets, the standard toolbar, recording and running macros, moving through and modifying cells, formatting cells using various tools, creating formulas and functions, sorting data, autofilling cells, inserting clip art and images, using the Chart Wizard to create and format charts, setting print options like page breaks and orientation, and more.

Uploaded by

piping1234
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 2

EXCEL TUTORIAL MENU

Spreadsheet Basics

 Screen elements
 Adding and renaming worksheets
 The standard toolbar - opening, closing, saving, and more.

Customizing Excel
 Menus
 Customize toolbars
 Recording a macro
 Running a macro

Modifying A Worksheet
 Moving through cells
 Adding worksheets, rows, and columns
 Resizing rows and columns
 Selecting cells
 Moving and copying cells
 Freeze panes

Formatting Cells
 Formatting toolbar
 Format Cells dialog box
 Dates and times
 Styles
 Style dialog box
 Create a new style
 Format Painter
 AutoFormat

Formulas and Functions

 Formulas
 Linking worksheets
 Relative, absolute, and mixed referencing
 Basic functions
 Function Wizard
 Autosum

Sorting and Filling


 Basic ascending and descending sorts
 Complex sorts
 Autofill
 Alternating text and numbers with Autofill
 Autofilling functions

Graphics
 Adding clip art
 Add an image from a file
 Editing a graphic
 AutoShapes

Charts
 Chart Wizard
 Resizing a chart
 Moving a chart
 Chart formatting toolbar
 Copy a chart to Microsoft Word

Page Properties and Printing


 Page breaks
 Page orientation
 Margins
 Headers, footers, and page numbers
 Print Preview
 Print

Keyboard Shortcuts

You might also like