This Microsoft Office 2007 Excel Beginners 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.
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
Who is this Course for?
Microsoft Office 2007 Excel Beginners is perfect for anyone trying to learn potential professional skills.
As there is no experience and qualification required for this course, it is available for all students from any academic background.
Entry Requirement:
- This course is available to all learners, of all academic backgrounds.
- Learners should be aged 16 or over to undertake the qualification.
- Good understanding of English language, numeracy and ICT are required to attend this course.
Assessment:
This course does not involve any MCQ exams. Students need to answer 3 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.
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 | ||
| Mock Exam | |||
| Mock Exam- Microsoft Office 2007 Excel Beginners | 00:20:00 | ||
| Final Exam | |||
| Final Exam- Microsoft Office 2007 Excel Beginners | 00:20:00 | ||
Course Reviews
Related Courses
Project Leader Training
£507.00£55.00
Administrator & Microsoft Office Specialist Training
£507.00£39.00
Microsoft Word For Beginners
£507.00£69.00
Microsoft Excel For Beginners
£507.00£39.00
Bookkeeper Administrator
£507.00£49.00
First Aid Trainer
£507.00£59.00
Excel Course was Great
I’ve always thought I was pretty advanced in Excel, until today, where quite a few items I learned were eye openers
Useless
Bad English in the questions in the Final Exam, so a lot of the questions are pot luck with your final answer. The “You can retake the final exam at any point” isn’t true, you have to pay for it, then ask/tell them to reset the final exam. Like me today, asked them to reset the final exam and it still hasn’t been reset.
Complete rubbish. Do NOT use it