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

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

Others Excel Tutorials

Basic Excel Skills

Microsoft Excel 2013

Beginning Excel 2019

Microsoft Excel 2016 Academic Course

Excel 2016 Math with Dates and Times

Others related eBooks about Excel Fundamentals

Advanced Word 2013

With this PDF tutorial you will be familiar with the basic functionality of Microsoft Word 2013 and you will learn how to write document with ease....

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

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

Download Publisher 2016 PDF tutorial

Download Publisher 2016 PDF tutorial by techtutor under 10 pages intended to beginners....

Microsoft Excel 2013 for beginner

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

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

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

PowerPoint Presentation

This PDF tutorial introduces you to the basic features of PowerPoint which are particularly valuable in the teaching and learning environment....

How to Use Microsoft® Excel®

How to Use Microsoft® Excel® The Careers in Practice Series is an textbook appropriate for a course covering Microsoft Excel at a beginner to intermediate level. It is geared toward and will be accommodating for students and instructors with little to no experience in using Microsoft Excel...