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: | 584 |
| Created: | 2020-08-24 |
Others related eBooks about Microsoft Excel for Beginners
This course is intended to beginning computer users. You are only expected to know how to use the mouse and keyboard, open a program, and turn the computer on and off. You should also be familiar with the Microsoft Windows operating system.
With this reference, you will learn how to use easily Microsoft Excel 2016, all keyboard shortcuts that you need to work as a professional. Free training document in pdf designated to beginners.
The following is a list of items you should check before creating a Pivot Table, PDF tutorial under 9 pages for beginners.
How to Use Microsoft® Excel® The Careers in Practice Series is an textbook appropriate for a course covering Microsoft Excel at a beginner to intermediate level. It is geared toward and will be accommodating for students and instructors with little to no experience in using Microsoft Excel