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: | 536 |
| 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
This course is not intended to serve as a beginner's tutorial on Excel. Those who are new to Excel and who need a tutorial should work through abook or a CD, or take an online course.
Download basic formulas in Excel tutorial, free training document in PDF under 6 pages by Lauren Wicks.
Learn how to use PivotTable and PivotCharts in Microsoft Excel 2016, free training document for download.
This is a free Excel PDF tutorial in 11 chapters and 23 pages. This course aims to give students the basics of Microsoft Excel tips and trics.
With this tutorial, you will learn a lot of shortcuts and custom formatting options about Dates and Times in Excel 2016. Training documents courses on 17 pages for beginners.