Microsoft Excel 2007 Intermediate

Overview:

The Microsoft Excel 2007 Intermediate course goes a step further than the basics where individuals learn to create charts and tables. This course will teach individuals to expand on their skills learned in the first course. Learn how to use multiple worksheets and workbooks, create and apply spreadsheet templates, create and manipulate charts and use drawing tools for spreadsheets. Getting certified in Microsoft Excel 2007 Intermediate will give individuals the chance of showcasing your skills and knowledge in an office environment amongst peers and colleagues.

The Microsoft Excel 2007 Intermediate course will teach learners how to use formulas for advanced analysis, create shared workbooks, track changes in workbooks and protecting workbooks and worksheets.

The Microsoft Excel 2007 Intermediate course will give learners an understanding on how to create formulas, create and use range names, create and use outlines and add objects to chart and worksheet. The course is internationally recognised and accredited to a training organisation and you will be issued an internationally recognised qualification following full completion of Microsoft Excel 2007 Intermediate.

Why consider 1Training?

As improvements and advancements are made in technology, online courses are no longer just conventional means of studying at affordable costs. In many aspects online training offers superiority to traditional learning. There is an effectiveness and convenience that traditional learning cannot provide. The overall convenience and flexibility makes it a superior learning method.

1Training offers the most convenient path to gain an internationally recognised qualification that will give you the opportunity to put into practice your skill and expertise in an enterprise or corporate environment. You can study at your own pace at 1Training and you will be provided with all the necessary material, tutorials, qualified course instructor and multiple free resources which include Free CV writing pack, Nus Discounted Card, Free career support and course demo to make your learning experience enriching and more rewarding.

Learning Outcomes

• Learn how to summarise data and correct errors in calculation
• Learn formatting and calculation
• Learn how to customise appearance of charts
• Learn how to print charts separately from worksheets
• Learn how to create an outline, showcase different groups of data

Access Duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course.  The course is self-paced and you can complete it in stages, revisiting the lectures at anytime.

Who is this Course aimed at?

• The course is aimed at individuals who have basic experience of Excel 2007.
• Students wishing to expand their skills in Microsoft Office Excel 2007.
• The course is ideal for individuals working in an office environment.
• Anyone interested in developing their skills in Microsoft Office Excel 2007.

Entry Requirements

• You must be over the age of 16 and have a basic understanding of Maths, English and ICT
• Job seekers / graduates / school leavers

Method of Assessment

At the end of the Microsoft Excel 2007 Intermediate course you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.

Certification

Those who successfully complete the exam will be awarded the certificate in Microsoft Excel 2007 Intermediate.

Awarding Body

The certificate will be awarded by CPD and iAP. This internationally recognised qualification will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in the IT enterprise.

Progression and Career Path

Once you successfully complete Microsoft Excel 2007 Intermediate you will be qualified to work in the following positions. The Microsoft Excel 2007 Intermediate qualification will also put you in line to demand a higher salary or job promotion. The average UK salary per annum according to https://www.payscale.com is given below.

• Office Administrator – £17,158 per annum
• Office Manager – £24,073 per annum
• Receptionist – £15,961 per annum
• Personal Assistant – £25,003 per annum
• Project Assistant – £20,785 per annum
• Business Executive – £23,667 per annum
• Secretary – £19,460 per annum
• Business Analyst – £35,543 per annum
• Technical Support Analyst – £22,753 per annum

Other Benefits

• Written and designed by the industry’s finest expert instructors with over 15 years of experience
• Repeat and rewind all your lectures and enjoy a personalised learning experience
• Gain access to quality video tutorials
• Unlimited 12 months access from anywhere, anytime
• Excellent Tutor Support Service (Monday to Friday)
• Save time and money on travel
• Learn at your convenience and leisure
• Quizzes, tests mock exams, practice exams to ensure you are 100% ready
• Eligible for a NUS discount card
• Free Career Support Service
• 25% Discount on personal Statement and covering letter writing service
• Free Access to Over 150 courses for 2 days (48 hours)
• Free access to course before you purchase (For selected courses only)

COURSE CURRICULUM➤ MODULE 01 - USING MULTIPLE WORKSHEETS AND WORKBOOKS1.0 TOPIC A: USING MULTIPLE WORKBOOKS2.0 TOPIC B: LINKING WORKSHEETS WITH 3-D FORMULAS3.0 TOPIC C: LINKING WORKBOOKS4.0 TOPIC D: MANAGING WORKBOOKS➤ MODULE 02: ADVANCED FORMATTING1.0 TOPIC A: USING SPECIAL NUMBER FORMATS2.0 TOPIC B: USING FUNCTIONS TO FORMAT TEXT3.0 TOPIC C: WORKING WITH STYLES4.0 TOPIC D: WORKING WITH THEMES5.0 TOPIC E: OTHER ADVANCED FORMATTING➤ MODULE 03 - OUTLINING AND SUBTOTALS1.0 TOPIC A: OUTLINING AND CONSOLIDATING DATA2.0 TOPIC B: CREATING SUBTOTALS➤ MODULE 04 - CELL AND RANGE NAMES1.0 TOPIC A: CREATING AND USING NAMES2.0 TOPIC B: MANAGING NAMES➤ MODULE - 05: LISTS AND TABLES1.0 TOPIC A: EXAMINING LISTS2.0 TOPIC B: SORTING AND FILTERING LISTS3.0 TOPIC C: ADVANCED FILTERING4.0 TOPIC D: WORKING WITH TABLES➤ MODULE 06 - WEB AND INTERNET FEATURES1.0 TOPIC A: SAVING WORKBOOKS AS WEB PAGES2.0 TOPIC B: USING HYPERLINKS3.0 TOPIC C: DISTRIBUTING WORKBOOKS➤ MODULE 07 - ADVANCED CHARTING1.0 TOPIC A: CHART FORMATTING OPTIONS2.0 TOPIC B: COMBINATION CHARTS3.0 TOPIC C: GRAPHIC ELEMENTS➤ MODULE 08 - DOCUMENTING AND AUDITING1.0 TOPIC A: AUDITING FEATURES2.0 TOPIC B: COMMENTS IN CELLS AND WORKBOOKS3.0 TOPIC C: PROTECTION4.0 TOPIC D: WORKGROUP COLLABORATION➤ MODULE 09 - TEMPLATES AND SETTINGS1.0 TOPIC A: APPLICATION SETTINGS2.0 TOPIC B: BUILT-IN TEMPLATES3.0 TOPIC C: CREATING AND MANAGING TEMPLATES