Excel Fundamentals

Contents

  • Understanding Workbooks
  • Navigating in a File
  • Typing Text or Numbers Into A Worksheet
  • Typing Simple Formulas In A Worksheet
  • Filling A Series.
  • Inserting And Deleting Worksheets
  • Copying A Worksheet
  • Renaming A Worksheet
  • Moving or Copying A Sheet To Another Workbook
  • Changing Worksheet Tab Colours
  • Grouping Worksheets
  • Freezing Rows And Columns
  • Selecting Ranges
  • Selecting Rows
  • Selecting Columns
  • Understanding Formatting
  • Applying General Formatting
  • Changing Fonts
  • Changing Font Size 
  • Understanding Borders
  • Applying A Border To A Range 
  • Wrapping And Merging Text
  • PRACTICE EXERCISE
  • Understanding Functions
  • Using The SUM Function To Add
  • Calculating An Average
  • Finding A Minimum Value
  • Common Error Messages
  • PRACTICE EXERCISE
  • Understanding Quick Analysis
  • Quick Formatting
  • Quick Charting 
  • Quick Totals
  • Quick Sparklines
  • Quick Tables
  • Practice Exercise 
  • Printing A Worksheet
Size : 7199.48 Kb
File type : pdf
Downloads: 604
Created: 2020-08-24
Excel Fundamentals

Others Excel Tutorials

Microsoft Excel Tips & Tricks

Beginning Microsoft® Excel®

The Beginner’s Guide to Microsoft Excel

Excel 2016 Shortcuts

Microsoft Excel 2013 Tutorial

Others related eBooks about Excel Fundamentals

Microsoft Excel 2013 course

Download free Microsoft Office Excel 2013 file under 505 pages,step by step to learn Excel and build your skills , course tutorial training on pdf by Curtis D. Frye....

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

Microsoft Word 2013

Download courses Microsoft Word 2013 in PDF ,a free training document under 15 pages for beginners....

PowerPoint 2010 Advanced

Download advanced tutorial in PDF about PowerPoint 2010, free course under 201 pages by Stephen Moffat....

Word 2013 Keyboard Shortcuts

Free Microsoft Word 2013 Keyboard Shortcuts in PDF for download ,a free training document under 20 pages to make Word easy to use and understand....

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

Office 365

Written for the IT professional and business owner, this book provides the business and te..., download free Office tutorial in PDF (680 pages) created by Don Crawford ....

VBA API Tutorial

Download VBA API Tutorial on 24 pages intended to advanced level users. Free training document in PDF....

Microsoft PowerPoint 2013 step by step

This courses is designated to beginning-level and intermediate-level computer users. It teach you some skills that can be used to make a beutiful presentation....