Excel Basics 2022

Learn to use Excel for creating professional spreadsheets and fill the gaps.

5.0

Course in English

30 days Money Back Guarantee
Certificate of Completion
More than 3 hours of content
Additional Material
Lifetime
access

Teacher: Aziz Issa

Details

Description

GOAL: Learn to use Excel for creating professional spreadsheets and fill the gaps.

COVERAGE: Based in the most recent version of Excel: Office 365, August 2022.

METHODLOGY: Training course based on step-by-step video tutorials with business examples.

CONTENT INDEX

Introduction to Excel: Opening Excel, The Worksheet, Introduction to Formulas, More about Formulas, Excel Interface,
Expanding a Spreadsheet.

Working with the Grid and the Cells: Navigation on the Worksheet, Editing Data, Cells Selection, Cells Manipulation, Content Manipulation, Resizing Columns and Rows.

Basic Features: Quick Formatting Features, SUM Function, AutoSum, Workbooks, Frequently Used Lists.

Formulas with Efficiency: Cells Reference Captation, Copying Formulas, Relative and Absolute Cells Reference.

Formatting Features: Font Formatting, Number Formatting, Date and Time Formatting, Format Painter, Table Styles.

Essential Features: Basics about Worksheets, Manipulating Worksheets, Introduction to Functions, Statistical Functions, Column Charts, Sorting Data, Filtering Data, Printing Feature.

View full description Hide full description

Objectives

Learn to use Excel for creating professional spreadsheets
Fill the gaps at using Excel

Instructional level

Introductory

Requirements

Basic skills in using the computer

Who should take this online course

- Beginners

- Those wanting to fill the gaps

Chapter 1: Introduction to Excel
- 1 Opening Excel 01:50 min
  
  DescriptionIntroduction to Excel Opening Excel Opening Excel New Workbook
- 2 The Worksheet 03:11 min
  
  DescriptionThe Worksheet
- 3 Introduction to Formulas 08:12 min
  1
  
  DescriptionIntroduction to Formulas
- 4 More about Formulas 06:59 min
  2
  
  DescriptionMore about Formulas
- 5 Excel Interface 08:24 min
  
  DescriptionExcel Interface
- 6 Expanding a Spreadsheet 11:57 min
  2
  
  DescriptionL06 Expanding a Spreadsheet
Chapter 2: Working with the Grid and the Cells
- 1 Navigating on the Worksheet 05:06 min
  
  DescriptionL01 Navigating on the Worksheet
- 2 Editing Data 05:26 min
  2
  
  DescriptionL02 Editing Data
- 3 Cells Selection 08:25 min
  1
  
  DescriptionL03 Cells Selection
- 4 Cells Manipulation 05:26 min
  1
  
  DescriptionL04 Cells Manipulation
- 5 Content Manipulation 05:58 min
  1
  
  DescriptionL05 Content Manipulation
- 6 Resizing Columns and Rows 06:15 min
  1
  
  DescriptionL06 Resizing Columns and Rows
Chapter 3: Basic Features
- 1 Quick Formatting Features 07:39 min
  2
  
  DescriptionL01 Quick Formatting Features
- 2 SUM Function 05:35 min
  1
  
  DescriptionL02 SUM Function
- 3 AutoSum 07:25 min
  2
  
  DescriptionL03 AutoSum
- 4 Workbooks 07:05 min
- 5 Frequently Used Lists 06:50 min
  
  DescriptionL05 Frequently Used Lists
Chapter 4: Formulas with Efficiency
- 1 Cells Reference Captation 06:29 min
  2
  
  DescriptionL01 Cells Reference Captation
- 2 Copying Formulas 06:35 min
  2
  
  DescriptionL02 Copying Formulas
- 3 Relative and Absolute Referencing 11:32 min
  2
  
  DescriptionL03 Relative and Absolute Referencing
Chapter 5: Formatting Features
- 1 Font Formatting 05:41 min
  2
  
  DescriptionL01 Font Formatting
- 2 Number Formatting 07:27 min
  1
  
  DescriptionL02 Number Formatting
- 3 Date and Time Formatting 04:44 min
  1
  
  DescriptionL03 Date and Time Formatting
- 4 Format Painter 04:01 min
  1
  
  DescriptionL04 Format Painter
- 5 Table Styles 01:35 min
  1
  
  DescriptionL05 Table Styles
Chapter 6: Essential Features
- 1 Worksheets Basics 05:37 min
  2
  
  DescriptionL01 Worksheets Basics
- 2 Manipulating Worksheets 07:53 min
  1
  
  DescriptionL02 Manipulating Worksheets
- 3 Function Syntax 04:38 min
  2
  
  DescriptionL03 Function Syntax
- 4 Statistical Functions 08:28 min
  2
  
  DescriptionL04 Statistical Functions
- 5 Charts 09:20 min
  1
  
  DescriptionL05 Charts
- 6 Sorting Data 08:21 min
  1
  
  DescriptionL06 Sorting Data
- 7 Filtering Data 09:36 min
  1
  
  DescriptionL07 Filtering Data
- 8 Printing Feature 07:42 min
  1
  
  DescriptionL08 Printing Feature
Chapter 7: Conclusion
- 1 Conclusion 00:27 min
  
  DescriptionS08 Conclusion

The Teachlr

Aziz Issa

IT Trainer, Consultant and Developer. Business Manager.

IT�Developer from 1983 having dealt with several operating systems, including mainframes OS�and Windows. Development of programs in languages such as COBOL, Java, C, C++, Visual Basic, VBA, Clipper, Pascal. Web Development involving HTML, Javascript, PHP, ASP. Websites creation with Word Press. IT�Trainer from 1987 spanning Microsoft Office applications and others such as Lotus, Quatro Pro, and diverse word processors. Training people on the mentioned programming languages and Web development.

Reviews

Sinan Isaac

Nice course. Very informative and good methodology.