Requested resource is not accessible

This course covers between introductory and advanced excel functions for both beginners and experts. Learners will develop basic knowledge and are introduced specifically to Excel.

The course covers the following Units and topics:

Unit 1.

-Introduction

-Excel file = “Workbook”, not “Document”

-Columns (Represented by Letters) and Rows (Represented by Numbers)

-Cells = Intersection of Column and Row = Name or Address like B5 or A1, Worksheet = Sheet = All the Cells, Sheet Tab = Name of worksheet and Insert New Sheets

-Double-click Sheet Tab to highlight sheet name, then type sheet name, then hit Enter

-You can add new sheets with Plus button to the right of the sheets

-Workbook = All the sheets = File = File Name

-Selection Cursor is the “thick white cross with a slight black shadow” cursor

-Move Cursor

-Fill Handle = after you select a cell the little black square in the lower right corner

-Cross Hair or “Angry Rabbit” Cursor

-Entering data or formulas

Unit 2.

-Cross Hair or “Angry Rabbit” Cursor Magic

-Default Alignment In Excel

-Stylistic Formatting examples

-Select whole table

-Entering data into a large range of cells

Unit 3.

-Formulas

-First Formula using SUM

-Cell References

-AVERAGE Function

Unit 4.

-Percentage Formula with Relative Cell Reference and Absolute Cell References Cell

-Number Formatting

-Page Setup

-Move Sheet and Copying Sheet

-Summary

Course Curriculum

Excel
Excel Unit 1 Details FREE 00:08:00
Excel Unit 2 Details FREE 00:15:00
Excel Unit 3 Details FREE 00:13:00
Excel Unit 4 Details FREE 00:30:00
TAKE THIS COURSE
  • FREE
  • 4 days
108 STUDENTS ENROLLED
Copyright © Portalay 2020. All rights reserved.