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: 602
Created: 2020-08-24
Excel Fundamentals

Others Excel Tutorials

Microsoft Excel 2007 : Essential Guide

Pivot Tables in Microsoft Excel

Beginning Microsoft® Excel®

Excel 2016 Functions Tutorial

Excel 2016 Math with Dates and Times

Others related eBooks about Excel Fundamentals

Publisher 2016 tutorial pdf

Download free course about Publisher 2016, getting started with Microsoft Office Publisher 2016 by Bharathi G, PDF training document under 182 pages....

Essential PowerShell

This book written to provide clear and concise explanation of topics for programmers both starting to learn the PowerShell programming as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it....

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

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

Microsoft Excel 2013 for beginner

Download free Microsoft Office Excel 2013 Tutorial course material, tutorial training, PDF file on 25 pages....

Beginning Excel 2019

Download free course Beginning Excel 2019, pdf file on 387 pages by by Noreen Brown, Barbara Lave, Hallie Puncochar, Julie Romey, Mary Schatz, Art Schneider, Diane Shingledecker....

Microsoft PowerPoint 2007

This PDF tutorial is aimed at beginner who wants to creat their own PowerPoint presentation ,easy course with illustrative images,free training lesson under 14 pages by Dawn Rauscher....

PowerPoint 2013 course

Download Microsoft powerpoint 2013 courses for student, free training document in PDF designated for brginners....