Intermediate
Excel lms

Excel Beginner

Andries Andries
Overview
Curriculum
  • 10 Sections
  • 44 Lessons
  • 8h Duration
Collapse 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

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.

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

Andries Andries

  • Automate repetitive tasks

    • Enhance Excel functionality

    Increase productivity

    16h
    53
    Buy Now
    Advanced
    Excel lms

    Excel Advanced

    Andries Andries

  • Advanced data analysis techniques

    • Solver for optimization problems

    What-If Scenarios for exploring possibilities

    8h
    34
    Buy Now
    Intermediate
    Excel lms

    Excel Intermediate

    Andries Andries

  • Conditional Formatting Mastery

    • Data Validation Techniques

    Advanced Formulas and Functions

    8h
    44
    Buy Now
    Scroll to Top