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
Size912.249 Kb
File typepdf
Downloads584
Created2020-08-24
Cover of Microsoft Excel for Beginners

Download

  • Introduction to VBA in Excel - PDF Tutorial

    This is a tutorial showing how to use the macro facility in Microsoft Office—Visual Basic for Applications—to simplify analytical tasks in Excel....

  • 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....

  • VBA Excel 2010, 2013 and 2016 Tutorial in PDF

    Download VBA Excel 2013 Tutorial in PDF, free training document intended to beginner users on 10 pages....

  • Excel Basics: Microsoft Office 2013

    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....

  • How to use formulas in Excel calculation

    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....

  • Quick guide to Word 2010

    A course to learn how to use the Word 2010 version, PDF training course to download for free, Microsoft Office Word 2010, training support in 4 pages...

  • Microsoft Excel 2007 : Essential Guide

    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....

  • Pivot Tables in Microsoft Excel

    The following is a list of items you should check before creating a Pivot Table, PDF tutorial under 9 pages for beginners....

  • Microsoft Excel 2013

    Download free Microsoft Excel 2013 Tutorial , a PDF training file under 12 pages for beginners....

  • Quick guide to Microsoft Excel 2016

    Quick guide to Excel 2016 intended to beginners in order to learn the fundamentals of Microsoft Excel 2016, training document in pdf....