Microsoft Excel 2010 Basic

Overview:

If you’ve acquired basic knowledge of an earlier version of Excel, the Microsoft Excel 2010 Basic course is the next step for learners to gain an introduction and learn the basics. The course will teach learners to create files, edit existing documents and create new workbooks. The Microsoft Excel 2010 Basic qualification will give individuals the skill and knowledge on how to use different file formats and save an Excel spreadsheet file, and freeze rows and columns in a spreadsheet.

The Microsoft Excel 2010 Basic course gives individuals an understanding of entering text and numbers and printing documents, learning how to create and edit spreadsheets, and how to organise data with multiple sheets. The course will make you comfortable with basic functionality and layout of Excel 2010.

The Microsoft Excel 2010 Basic course will help you impress your colleagues and management. It is one of the most popular editions of Microsoft and will give you an edge when working in an office environment. 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 2010 Basic course.

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 navigate the Excel 2010 interface and work with common tools and features
• Learn how to perform calculations on workbooks and worksheets
• Learn how to modify worksheets and format worksheets
• Learn how to manage workbooks and worksheets
• Learn how print workbooks and worksheets

Course Titles

• Module 01: Getting Started
• Module 02: Entering and Editing Data
• Module 03: Modifying a Worksheet
• Module 04: Functions
• Module 05: Formatting
• Module 06: Printing
• Module 07: Charts
• Module 08: Managing Large Workbooks
• Module 09: Graphics and Screenshots

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 no prior experience of Excel 2010.
• Students looking to expand their skills in Microsoft Office Excel from an older version.
• The course is ideal for individuals working in office positions.
• Anyone interested in developing their skills in Microsoft Office Excel 2010.

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 2010 Basic 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 2010 Basic.

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 2010 Basic you will be qualified to work in the following positions. The Microsoft Excel 2010 Basic 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 anuum
• Office Manager – £24,073 per anuum
• Receptionist – £15,961 per anuum
• Personal Assistant – £25,003 per anuum
• Project Assistant – £20,785 per anuum
• Business Executive – £23,667 per anuum
• Secretary – £19,460 per anuum
• Business Analyst – £35,543 per anuum
• Technical Support Analyst – £22,753 per anuum

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: GETTING STARTEDCOURSE INTRODUCTION1.0 TOPIC A: SPREADSHEET TERMINOLOGY2.0 TOPIC B: THE EXCEL ENVIRONMENT3.0 TOPIC C: GETTING HELP4.0 TOPIC D: NAVIGATING A WORKSHEET➤ MODULE 02: ENTERING AND EDITING DATA1.0 TOPIC A: ENTERING AND EDITING TEXT AND VALUES2.0 TOPIC B: ENTERING AND EDITING FORMULAS3.0 TOPIC C: WORKING WITH PICTURES4.0 TOPIC D: SAVING AND UPDATING WORKBOOKS➤ MODULE 03: MODIFYING A WORKSHEET1.0 TOPIC A: MOVING AND COPYING DATA2.0 TOPIC B: MOVING AND COPYING FORMULAS3.0 TOPIC C: ABSOLUTE AND RELATIVE REFERENCES4.0 TOPIC D: INSERTING AND DELETING RANGES, ROWS, AND COLUMNS➤ MODULE 04: FUNCTIONS1.0 TOPIC A: ENTERING FUNCTIONS2.0 TOPIC B: AUTOSUM3.0 TOPIC C: OTHER COMMON FUNCTIONS➤ MODULE 05: FORMATTING1.0 TOPIC A: TEXT FORMATTING2.0 TOPIC B: ROW AND COLUMN FORMATTING3.0 TOPIC C: NUMBER FORMATTING4.0 TOPIC D: CONDITIONAL FORMATTING5.0 TOPIC E: ADDITIONAL FORMATTING OPTIONS➤ MODULE 06: PRINTING1.0 TOPIC A: PREPARING TO PRINT2.0 TOPIC B: PAGE SETUP OPTIONS3.0 TOPIC C: PRINTING WORKSHEETS➤ MODULE 07: CHARTS1.0 TOPIC A: CHART BASICS2.0 TOPIC B: FORMATTING CHARTS➤ MODULE 08: MANAGING LARGE WORKBOOKS1.0 TOPIC A: VIEWING LARGE WORKSHEETS2.0 TOPIC B: PRINTING LARGE WORKSHEETS3.0 TOPIC C: WORKING WITH MULTIPLE WORKSHEETS➤ MODULE 09: GRAPHICS AND SCREENSHOTS1.0 TOPIC A: CONDITIONAL FORMATTING WITH GRAPHICS2.0 TOPIC B: SMARTART GRAPHICS3.0 TOPIC C: SCREENSHOTS