Intermediate
Excel lms

Excel Beginner

Andries Andries
Overview
Curriculum

Microsoft Excel simplifies complex tasks such as financial analysis, budgeting, and inventory management, making it an indispensable tool for both personal and professional use.

Microsoft Excel simplifies tasks such as budgeting, tracking expenses, and managing inventories, making it indispensable for both personal and professional use.

Curriculum

  • 10 Sections
  • 44 Lessons
  • 8h Duration
Expand All
Section 1 - Introduction
1 Lesson
  1. Excel Beginner Introduction
Section 2 - Fundamentals
9 Lessons
  1. Launching Excel
  2. Start Up Screen
  3. The Excel Interface
  4. The Quick Access Toolbar
  5. The Ribbon
  6. Creating New Excel Workbooks
  7. Saving Excel Files
  8. Opening Excel Files
  9. Beginner Shortcut Keys
Section 3 - Entering and Editing Text
8 Lessons
  1. Entering Text
  2. Working with Numbers
  3. An Introduction to Dates
  4. Find and Replace
  5. Sorting Data
  6. Working with Cell References
  7. Relative Versus Absolute Cell References in Formulas
  8. Understanding the Order of Operation
Section 4 - Basic Excel Functions
5 Lessons
  1. The structure of an Excel Function
  2. Working with the Sum Function
  3. Working with Min and Max
  4. Working with Averages
  5. Working with Count and CountA
Section 5 - Modifying Excel Worksheets
7 Lessons
  1. Moving and Copying Data
  2. Inserting and Deleting Rows and Columns
  3. Changing the Width and Height of Cells
  4. Hiding and Unhiding Rows, Columns and Sheets
  5. Renaming Worksheets
  6. Deleting Worksheets
  7. Moving and Copying Worksheets
Section 6 - Formatting Data
5 Lessons
  1. Adding Borders to Cells
  2. Formatting Percentages
  3. Merging and Centering Cells
  4. A Quick Look at Styles
  5. Basic Conditional Formatting
Section 7 - Images, Shapes and Smart Art
2 Lessons
  1. Inserting Images and Shapes
  2. Working with Smart Art
Section 8 - Printing
3 Lessons
  1. Print Preview
  2. Margins, Scaling and Orientation
  3. Printing
Section 9 – Working with Templates
3 Lessons
  1. Intro to Excel Templates
  2. Opening an Existing Template
  3. Creating a Custom Template
Section 10 - Conclusion
1 Lesson
  1. Conclusion

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Related Courses

Expert
Excel lms

Excel VBA

  • Automate repetitive tasks
  • Enhance Excel functionality
  • Increase productivity
16h
0
0
53
$20
Buy Now

Retake Course

Are you sure you want to retake the course? This action will permanently delete all your progress in this course.
Advanced
Excel lms

Excel Advanced

  • Advanced data analysis techniques
  • Solver for optimization problems
  • What-If Scenarios for exploring possibilities
8h
0
0
34
$15
Buy Now

Retake Course

Are you sure you want to retake the course? This action will permanently delete all your progress in this course.
Intermediate
Excel lms

Excel Intermediate

  • Conditional Formatting Mastery
  • Data Validation Techniques
  • Advanced Formulas and Functions
8h
0
0
44
$10
Buy Now

Retake Course

Are you sure you want to retake the course? This action will permanently delete all your progress in this course.
Scroll to Top