Microsoft Excel for Beginners
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 |
| File type : | |
| Downloads: | 536 |
| Created: | 2020-08-24 |
Warning: Trying to access array offset on false in /home/tutovnfz/public_html/article.php on line 233
Others related eBooks about Microsoft Excel for Beginners
Office 365Download free course Office 365, pdf file on 680 pages by Matthew Katzer, Don Crawford....
Quick guide to PowerPoint 2010This pdf tutorial will help you understand PowerPoint 2010 features and create presentation for school or work. I will show you how to use each feature step by step so you you will learn PowerPoint 2010 easily and efficiently....
Microsoft Word 2103 Step by StepThis PDF tutorial provides invaluable handson experience for who want to learn about new features in Word 2013 .It's a free and complet training document under 576 pages for download....
How to Create Professional Reports and Documents in Microsoft WordThis is a free Microsoft Word PDF tutorial in 10 chapters and 39 pages. This course aims to give students the basics of Microsoft Word concepts. ...
Excel VBA tutorial for professionalsDownload free VBA tutorial course in PDF, training file in 31 chapters and 128 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
Introduction to Excel VBA Macro programmingIntroduction to Excel VBA Macro programming, Learn Excel tools by utilizing them in various cases, Understand the logic and syntax behind Visual Basic programming, which interacts with the Excel interface...
Excel 2016 Functions TutorialDownload Excel 2016 Functions Tutorial, free PDF document intended to anyone wants to learn the basics of Excel functions....
Excel Data Analysis, 2nd EditionThis book offers a comprehensive and readable introduction to modern business and data ana..., download free Excel Data tutorial in PDF (358 pages) created by Hector Guerrero ....
Microsoft Excel Tips & TricksThese are some of my favorite tips and power features that’ll get you well on your way to ‘Excel Guru Status’ giving you not only the recognition you deserve, but also making your work more enjoyable....
Basic Formulas in ExcelDownload basic formulas in Excel tutorial, free training document in PDF under 6 pages by Lauren Wicks....