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 : pdf
Downloads: 536
Created: 2020-08-24
Microsoft Excel for Beginners

Warning: Trying to access array offset on false in /home/tutovnfz/public_html/article.php on line 233

Others Excel Tutorials

Beginning Microsoft® Excel®

Excel 2016 PivotTables and PivotCharts

Excel Basics: Microsoft Office 2013

Excel Data Analysis

Microsoft Excel 2016 Tutorial

Others related eBooks about Microsoft Excel for Beginners

Office 365

Download free course Office 365, pdf file on 680 pages by Matthew Katzer, Don Crawford....

Quick guide to PowerPoint 2010

This 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 Step

This 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 Word

This 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 professionals

Download 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 programming

Introduction 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 Tutorial

Download Excel 2016 Functions Tutorial, free PDF document intended to anyone wants to learn the basics of Excel functions....

Excel Data Analysis, 2nd Edition

This 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 & Tricks

These 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 Excel

Download basic formulas in Excel tutorial, free training document in PDF under 6 pages by Lauren Wicks....