This [course_title] is designed to teach you the basics elements and functions of Microsoft Excel 2007. In this series you will learn all about how to get started with Excel, you will be able to identify the different spreadsheet components, and some other main components of Excel. With the help of this course you will learn, the excel 2007 interface & the ribbon, entering & editing data, the formula bar, rows, columns, cells, ranges, worksheets & workbooks, formatting data & cells, basic math calculations & formulas, saving, loading, printing sheets and more.
No matter if you have a little or no experience with Microsoft Excel you can join this course anyways. You will begin by learning about the parts of the Excel interface, including the Title Bar, Window control buttons, Office button, and more.
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:06:00 | ||
| Exploring the Excel Window | 00:15:00 | ||
| Getting Help | 00:06:00 | ||
| Navigating Workbooks | 00:06:00 | ||
| Entering and Editing Data | |||
| Entering and Editing Text and Values | 00:12:00 | ||
| Entering and Editing Formulas | 00:11:00 | ||
| Working with Pictures | 00:04:00 | ||
| Saving and Updating Workbooks | 00:06:00 | ||
| Modifying a Worksheet | |||
| Moving and Copying Data | 00:13:00 | ||
| Moving and Copying Formulas | 00:08:00 | ||
| Absolute and Relative References | 00:04:00 | ||
| Inserting and Deleting Ranges, Rows, and Columns | 00:04:00 | ||
| Using Functions | |||
| Entering Functions | 00:15:00 | ||
| AutoSum | 00:04:00 | ||
| Other Useful Functions | 00:07:00 | ||
| Formatting Worksheets | |||
| Formatting Text | 00:04:00 | ||
| Formatting Rows and Columns | 00:11:00 | ||
| Formatting Numbers | 00:07:00 | ||
| Conditional Formatting | 00:05:00 | ||
| Copying Formats and Applying Table Formats | 00:07:00 | ||
| Printing | |||
| Preparing to Print | 00:08:00 | ||
| Page Setup Options | 00:09:00 | ||
| Printing Worksheets | 00:04:00 | ||
| Creating Charts | |||
| Chart Basics | 00:10:00 | ||
| Modifying Charts | 00:07:00 | ||
| Printing Charts | 00:01:00 | ||
| Managing Large Workbooks | |||
| Viewing Large Worksheets | 00:08:00 | ||
| Printing Large Worksheets | 00:05:00 | ||
| Using Multiple Worksheets | 00:10:00 | ||
| Assessment | |||
| Submit Your Assignment | 00:00:00 | ||
| Certification | 00:00:00 | ||
Course Reviews
No Reviews found for this course.
Related Courses
