Unit 03 Microsoft Excel - Create Cells and Ranges (PPT)

Unit 03 Microsoft Excel - Create Cells and Ranges (PPT)
Unit 03 Microsoft Excel - Create Cells and Ranges (PPT)
Unit 03 Microsoft Excel - Create Cells and Ranges (PPT)
Unit 03 Microsoft Excel - Create Cells and Ranges (PPT)
Unit 03 Microsoft Excel - Create Cells and Ranges (PPT)
Unit 03 Microsoft Excel - Create Cells and Ranges (PPT)
Unit 03 Microsoft Excel - Create Cells and Ranges (PPT)
Unit 03 Microsoft Excel - Create Cells and Ranges (PPT)
File Type

Presentation (Powerpoint) File

(53 MB|42 pages)
Also included in:
  1. Welcome to our brand-new course covering the latest and greatest version of Microsoft Excel 2019 and 365. About The CourseMicrosoft Excel is the spreadsheet program of choice for companies, governments agencies, and organizations around the world. We have specifically designed this course to help y
    $40.00
    $35.00
    Save $5.00
Product Description

To be an accountant in the age of spreadsheet program is — well, almost sexy.” — Steven Levy in “A Spreadsheet Way of Knowledge” (1984)

Howdy and welcome to Unit 3, Create Cells and Ranges.

In this unit we develop some core skills when it comes to entering data into our Excel worksheets. We look at the different ways to not only enter data but to also make life so much easier with features like AutoFill, AutoComplete, and Drop-Down List to name just a few.

We also discover how to format our cells so they are easier to use just plan old nicer to look at. Then we end with the find and replace feature that can save you hours of time in large workbooks.

Unit Objectives:

  • Use different methods to enter data into cells
  • Cut, copy, paste and move data within Excel
  • Format cells to make worksheets easier to use
  • Find and replace data within a spreadsheet

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

About The Course

Microsoft Excel is the spreadsheet program of choice for companies, governments agencies, and organizations around the world. We have specifically designed this course to help you go from beginner to a certified professional.

In this course, you will learn how to use the most recent versions of Microsoft Excel, the 2019 and constantly updated Office 365 version.

This course follows the objectives created by Microsoft and ensures that not only will you develop the knowledge, skills, and abilities (KSAs) to use Excel but you will also be prepared to take and pass the Microsoft Office Specialist 77-727 Excel Core exam.

In this course, you will develop the KSAs to:

  • Create worksheets and workbooks
  • Navigate through worksheets and workbooks
  • Format worksheets and workbooks
  • Customize options and views for worksheets and workbooks
  • Configure worksheets and workbooks to print or save
  • Insert data in cells and ranges
  • Format cells and ranges
  • Summarize and organize data
  • Create and manage tables
  • Manage table styles and options
  • Filter and sort a table
  • Summarize data by using functions
  • Perform conditional operations by using functions
  • Format and modify text by using functions
  • Create a chart
  • Format graphic elements
  • Insert and format objects
Total Pages
42 pages
Answer Key
N/A
Teaching Duration
1 hour
Report this Resource to TpT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TpT’s content guidelines.
Loading...
$5.00
Digital Download
Share this resource
Report this resource to TpT
mrfordsclass

mrfordsclass

126 Followers
Follow
More products from mrfordsclass
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign Up