Microsoft Excel For Beginners

Microsoft Excel for Beginners is a comprehensive introductory course designed to teach individuals with little to no prior experience how to effectively use Microsoft Excel. This course covers the fundamental features : Interface, Tabs and Ribbons, Document Windows, Navigation Tips, Office (File) Button and Save Backstage, Entering Data, Fonts, Fills & Alignments, Cut, Copy & Paste, Paste Special, Undo & Redo, Moving, Finding and Replacing a Value, Comments, Currency Format, Format Painter, Formatting Dates, Naming and Moving Worksheets, Copying Worksheets, Adding, Deleting and Hiding Worksheets, Grouping Worksheets, Move, Copy, Delete and Hide Grouped Worksheets, Inserting and Deleting Columns and Rows, Inserting & Deleting Cells, Inserting Multiple Columns and Rows, Modifying Cell Width and Height, Hiding and Unhiding Rows and Columns, Using Operations, Creating Formulas, AutoSum, Common Functions, Searching for Functions, Copying Formulas, Using Relative and Absolute References, Workbook Views, Show/Hide, Zoom Features, Freeze Panes, Split Windows, Viewing Multiple Windows, Minimize the Ribbon, Autofill a Series, Insert Pictures, Modifying Pictures, Insert Shapes, Insert Smart Art, Page Orientation, Page Breaks, Print Area, Margins, Print Titles, Headers and Footers, Scaling, Sheet Options, Save As Previous Version, Auto Recover Save Options, Save as PDF.

Beginner 0(0 Ratings) 8 Students enrolled English
Created by Yustino Nyendeza
Last updated Sat, 08-Jul-2023
+ View more
Course overview
Microsoft Excel for Beginners is a user-friendly course specifically designed to empower individuals with little to no prior knowledge of Excel. Whether you're a student, a professional, or simply someone seeking to enhance your spreadsheet skills, this course provides a solid foundation in using Microsoft Excel effectively.

Throughout the course, you'll be guided step-by-step through the essential features and functionalities of Excel. Starting with the basics, you'll learn how to navigate the Excel interface, create and format spreadsheets, and enter data accurately. Building upon this foundation, you'll discover how to perform calculations using formulas and functions, enabling you to automate tasks and save time.

What will i learn?

  • Interface, Tabs and Ribbons, Document Windows and Navigation Tips
  • Office (File) Button and Save Backstage
  • Entering Data, Fonts, Fills & Alignments
  • Cut, Copy & Paste Paste Special, Undo & Redo
  • Comments, Moving, Finding and Replacing a Value
  • Currency Format, Format Painter and Formatting Dates
  • Naming and Moving Worksheets, Copying, Adding, Deleting and Hiding Worksheets
  • Grouping Worksheets and Move, Copy, Delete and Hide Grouped Worksheets
  • Inserting and Deleting Columns and Rows
  • Inserting & Deleting Cells and Inserting Multiple Columns and Rows
  • Modifying Cell Width and Height, Hiding and Unhiding Rows and Columns
  • Using Operations, Creating Formulas, AutoSum and Common Functions
  • Searching for Functions and Copying Formulas
  • Using Relative, Absolute and Mixed References
  • Workbook Views, Show/Hide, Zoom Features, Freeze Panes and Split Windows
  • Viewing Multiple Windows, Minimize the Ribbon, Autofill a Series and Insert Pictures
  • Modifying Pictures, Insert Shapes, Insert Smart Art and Page Orientation
  • Page Breaks, Print Area, Margins, Print Titles Headers and Footers
  • Scaling Sheet Options, Save As Previous Version, Auto Recover Save Options and Save as PDF
Requirements
  • Computer and Operating System: You will need access to a computer or laptop with a Windows or Mac operating system. Excel is compatible with both platforms.
  • Microsoft Excel: You will need a version of Microsoft Excel installed on your computer. The course covers Excel 2016, Excel 2019, and Excel for Microsoft 365 (the cloud-based subscription version). Ensure that you have one of these versions installed
  • Internet Access: While the course materials may be available for download, having internet access will allow you to access additional resources, participate in online discussions (if available), and explore supplementary learning materials.
  • Time Commitment: Dedicate a few hours each week to go through the course content, practice exercises, and complete assignments. The exact time required will vary depending on your learning pace and prior familiarity with similar software.
  • Learning Mindset: Approach the course with a willingness to learn and explore new concepts. Excel can be a powerful tool, and having a positive attitude and a desire to practice and apply what you learn will contribute to your success in the course.
Curriculum for this course
24 Lessons 07:28:44 Hours
Excel for Beginners
15 Lessons 04:18:44 Hours
  • Microsoft Excel Interface
    Preview 00:15:47
  • Clipboard and Font
    00:16:00
  • Alignment
    00:17:26
  • Worksheets
    00:18:14
  • Format Numbers
    00:24:49
  • Other Format Options
    00:15:43
  • Operations, Formulas and Freeze Panes
    00:16:13
  • Printing
    00:21:30
  • Cell References
    00:19:18
  • Fill Series Numbers
    00:14:27
  • Insert Pictures Or Shapes
    00:25:44
  • Freeze Panes
    00:17:33
  • Smart Art and Saving Docs
    00:14:21
  • View Multiple Files
    00:12:57
  • Comments and Notes
    00:08:42
Excel For Beginners Worksheets
2 Lessons 00:00:00 Hours
  • Sheet for Printing Course
    .
  • Sheet for Cell Reference
    .
Course Quizzes
7 Lessons 03:10:00 Hours
  • Clipboard and Font Quiz
    0:40:00
  • Alignment Quiz
    0:20:00
  • Worksheet Format & Format Numbers Quiz
    0:20:00
  • Operations, Formulas and Freeze Panes Quiz
    0:20:00
  • Printing quiz
    0:30:00
  • Cell References Quiz
    0:30:00
  • Others Quizes
    0:30:00

Frequently asked question

Who is this course designed for?
This course is designed for individuals with little to no prior experience with Microsoft Excel. It is suitable for students, professionals, and anyone seeking to learn Excel from scratch.
What version of Excel does this course cover?
The course covers Excel 2016, Excel 2019, Excel 2021 Excel 2021 and Excel for Microsoft 365 (the cloud-based subscription version). The concepts and techniques taught in the course are applicable to these versions.
Do I need to have Excel installed on my computer to take the course?
Yes, you will need to have Excel installed on your computer to follow along with the course exercises. Excel is part of the Microsoft Office suite and can be purchased or obtained through a subscription.
How long is the course?
The course duration can vary depending on your learning pace. However, on average, it can be completed within a few weeks, dedicating a few hours each week.
Are there any prerequisites for taking this course?
No, there are no prerequisites. This course is designed for beginners, assuming no prior knowledge of Excel. Familiarity with basic computer operations and navigating software applications would be beneficial.
Will I receive a certificate upon completing the course?
Yes, after finishing the course and doing the Assessment Test and score at least 75% marks.
Can I upgrade to a more advanced Excel course after completing this beginners' course?
Absolutely! Once you have a solid foundation in Excel from this course, you can explore more advanced Excel courses to further enhance your skills and delve into more complex topics.
+ View more
Other related courses
07:16:45 Hours
Updated Wed, 05-Jul-2023
0 3 TSh350000 TSh50000
About instructor

Yustino Nyendeza

0 Reviews | 18 Students | 8 Courses
Student feedback
0
0 Reviews
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Reviews

TSh350000 TSh30000
Includes: