• LOGIN
  • No products in the cart.

You must be logged in to take this course  →   LOGIN | REGISTER NOW

 This Microsoft Office 2010 Excel Beginners – Complete Video Course will teach you the basic functions and features of Excel 2010. After an introduction to spreadsheet terminology and Excel’s window components, you will learn how to use the Help system and navigate worksheets and workbooks. Then you will enter and edit text, values, formulas, and pictures, and you will save workbooks in various formats. You will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course is designed to introduce you to using Microsoft Excel if you’re unfamiliar with any major aspect of it. The series will lead you through the fundamentals of creating and working with Excel spreadsheets. Today’s Excel spreadsheet isn’t just for financial professionals. Microsoft Excel offers intuitive tools that make it easy to access, connect, and analyze critical data—regardless of your profession.

Assessment

This course does not involve any written exams. Students need to answer 5 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.

Certification

Edukite courses are free to study. To successfully complete a course you must submit all the assignment of the course as part of the assessment. Upon successful completion of a course, you can choose to make your achievement formal by obtaining your Certificate at a cost of £49.

Having an Official Edukite Certification is a great way to celebrate and share your success. You can:

  • Add the certificate to your CV or resume and brighten up your career
  • Show it to prove your success

 

Course Credit: Edukite

Course Curriculum

Getting Started
Spreadsheet Terminology 00:02:00
The Excel Environment 00:05:00
Getting Help 00:03:00
Navigating a Worksheet 00:06:00
Entering and Editing Data
Entering and Editing Text and Values 00:09:00
Entering and Editing Formulas 00:09:00
Working with Pictures 00:03:00
Saving and Updating Workbooks 00:07:00
Modifying a Worksheet
Moving and Copying Data 00:13:00
Moving and Copying Formulas 00:07:00
Absolute and Relative References 00:06:00
Inserting and Deleting Ranges, Rows, and Columns 00:07:00
Functions
Entering Functions 00:15:00
AutoSum 00:04:00
Other Common Functions 00:11:00
Formatting
Text Formatting 00:06:00
Column Formatting 00:12:00
Number Formatting 00:06:00
Conditional Formatting 00:10:00
Additional Formatting Options 00:12:00
Printing
Preparing to Print 00:09:00
Page Setup Options 00:14:00
Printing Worksheets 00:04:00
Charts
Chart Basics 00:11:00
Formatting Charts 00:05:00
Managing Large Workbooks
Viewing Large Worksheets 00:14:00
Working with Multiple Worksheets 00:12:00
Printing Large Worksheets 00:08:00
Graphics and Screenshots
Conditional Formatting with Graphics 00:09:00
SmartArt Graphics 00:05:00
Screenshots 00:05:00
Assessment
Submit Your Assignment 00:00:00
Certification 00:00:00

Course Reviews

4.9

4.9
10 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

524 STUDENTS ENROLLED

Best Recommend Courses

Subscribe to our newsletter

  • Get top tips & guidance from our in-house study abroad experts

Inquiry

info@edukite.org

top
©2021 Edukite. All Rights Resereved
EduKite is a part of Ebrahim College, Charity commission reg no. 1108141