This is a basic computer workshop. Microsoft Excel is a spreadsheet program. We use it to create reports that need calculations and charts. In this workshop we will learn how to move around and work inside the spreadsheet.
Table of contents
- Vocabulary
- Status Bar Modes
- Keyboard Navigation
- Ribbon
- Clipboard
- Formatting Cells
- Cells Structures
- Inserting
- Deleting
- Cell Size (Row Height/Column Width)
- Fill Handle
- Building an Equation
- Type in the exact cell address
- Use the mouse to point to the cell address
- Mathematical Operations
- AutoSum
- Exercise 1: Customer
- Resizing Columns
- Freeze Panes (Lock Titles to Top of Page)
- Format
- Exercise 2: Quarter Total
- Fill Handle
- Format
- Chart
- Exercise 3: Items by Quarter
- Insert Rows
- Merged Title
- Fill Handle Across
- Total Row (AutoSum)
- Exercise 4: Sales Report
- Format
- Math
| Size : | 912.249 Kb |
| Downloads: | 535 |
| Created: | 2020-08-24 |
Warning: Trying to access array offset on false in /home/tutovnfz/public_html/amp/article-amp.php on line 263
Others related eBooks about Microsoft Excel for Beginners
Quick guide to Excel 2016 intended to beginners in order to learn the fundamentals of Microsoft Excel 2016, training document in pdf.
With this PDF tutorial you will learn how to use the Formulas in Excel to compile, claculate and manage data, free training document by OWL.
The purpose of this course is to provide a basic guide for student who wants to be familar with the basics of Microsoft Excel 2007.
Download Formulas and Functions in Excel PDF tutorial, free training document by Theresa Scott.