Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel Basics - Introduction to Excel - Formatting, Formulas, Cell References, Page Setup

ExcelIsFun via YouTube

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This introductory course teaches the fundamentals of Microsoft Excel through a gradebook project. Learners practice workbook structure, data entry, formatting, formulas, cell references, page setup, and copying worksheets.

Syllabus

) 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.
) 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.
) Formulas.
) First Formula using SUM.
) Cell References.
) AVERAGE Function.
) Percentage Formula with Relative Cell Reference and Absolute Cell References Cell .
) Number Formatting.
) Page Setup.
) Move Sheet and Copying Sheet:.
) Summary.

Taught by

ExcelIsFun

Reviews

5.0 rating, based on 2 Class Central reviews

Start your review of Excel Basics - Introduction to Excel - Formatting, Formulas, Cell References, Page Setup

  • Profile image for Hendra Ebenecer
    Hendra Ebenecer
    Very detailed, explained slowly so that beginners can quickly understand. Provides a shortcut, and provides information on what to do if an error occurs, which is very good.
  • Profile image for POSIANO FRANCIS
    POSIANO FRANCIS
    Very helpful...straight to the fundamentals...it lay a good foundation for future excel endeavors... I really encourage those who want to learn excel to start with basics as those being taught through this course

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.