Microsoft EXCEL 2010
Original price was: £295.00.£49.00Current price is: £49.00.
Course Description
In order to succeed in today’s business world, you must have competent skills in Microsoft Office. Whether you’re an administrative assistant, office manager, sales professional or business manager, utilising all of the powerful features of Microsoft Office will make you more efficient and subsequently more marketable. Almost every job in the business world involves office products. Take your skills to the next level and make your current job easier to manage by completing our Microsoft Excel 2010 course.
The Microsoft Excel 2010 course has been designed to provide you with the essential skills you will need to be proficient in Excel 2010, in a work or home environment, in as short a time as possible. You don’t need any prior experience of Microsoft Excel, but you will need to be familiar with using a computer and the Windows environment.
Get the skills employers are currently looking for, enrol today!
What is included in this course?
When you enrol, you’ll not only gain powerful, career-enhancing skills but also receive exclusive benefits, including:
Who is this course aimed at?
Anyone looking to develop their Microsoft Excel 2010 skills.
By choosing online learning instead of a classroom based course, it eliminates the need for time away from work, saving you valuable time and money. It is ideal for those with tight schedules as our online courses give you 12 months unlimited access to all the course materials, so you can study at a pace that suits you. Allowing you to easily resume your studies whenever you have the time. All you need is internet connection to study, so you can study from the comfort of your home or any environment that suits you.
Course Assessment Process
In order to earn your certification, you’ll have to sit an exam after completing your course with us. To prepare you for your exam, we provide interactive quizzes after each module and a mock exam at the end of your course to ensure you’re fully prepared for the real thing. Once you’ve passed with at least 85%, you’ll be ready to book your exam as a private candidate.
Booking your exam is pretty simple, just purchase your exam voucher and schedule your exam. To make life easier, we can help you find an appropriate exam centre and give you all the information you need to secure your place.
Please note that the exam fees aren’t included in the course price.
Got a question about exams? Contact one of our course advisors. We’re happy to help!
Requirements
Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.
For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player
Career Path
We’ve put together a list of relevant job titles you can apply for after achieving the Microsoft Office certification (note that some careers may require further study, training and/or work experience):
- Office Administrator
- Business Administrator
- Personal Assistant, Clerical Assistant
- Receptionist
- Secretary
- Customer Service Representative
- Project Officer, Project Manager
- Business Manager
- Sales Executive, Sales Manager, Sales Director
- Human Resource Officer
- Finance Assistant. Book-keeper, Accountant
- Healthcare Assistant, Nurse
- Database Administrator
Course Outline
Course Syllabus
Introduction
- Course Outline
- Introducing Excel 2010
- The Excel Interface
- Keyboard Shortcuts
- Section Review
Basic File Commands and Operations
- Creating, Saving and Closing Workbooks
- Personalizing Files and Opening Workbooks
- Viewing Existing Workbooks and Applying Templates
- Keyboard Shortcuts
- Section Review
Creating, Managing and Navigating the Worksheets
- Creating and Managing Worksheets
- Navigating the Worksheets
- Keyboard Shortcuts
- Section Review
Entering and Managing Worksheet Data
- Worksheet Basics and Cell Range Selection
- Entering Cell Content and Multiple Cells
- AutoContent and Undo, Redo and Repeat
- Updating and Clearing Cell Content
- Inserting and Deleting, Rows and Columns
- Copying, Cutting, Pasting and Moving Contents
- Keyboard Shortcuts
- Section Review
Formatting Cells and Worksheets
- Formatting Cells and Applying Formats
- Alignment
- Merging Cells and Cell Styles
- Numbers
- Apply and Modify Formats
- Using Table Features
- Keyboard Shortcuts
- Section Review
Applying Formulas and Functions
- Creating Formulas
- Using Cell References
- Managing and Updating Formulas
- Creating Functions
- Conditional Statements
- Error Messages
- Keyboard Shortcuts
- Section Review
Analyzing and Organizing Data
- Find and Replace
- Sorting
- Filtering
- Conditional Formatting and Keyboard Shortcuts
- Section Review
Naming and Hyperlinks
- Naming Cells and Ranges
- Hyperlinks
- Section Review
Displaying Data Visually Using Charts
- Charting
- Layout Chart Element Options and Format
- Spark lines
- Keyboard shortcuts
- Section Review
Preparing to Print and Printing
- Preparing to Print with Page Layouts
- Section Review
Share Worksheet Data with Other Users
- Sharing a Document and Managing Comments
- Section Review
Including Illustrations and Graphics in a Workbook
- Inserting and Formatting Pictures
- Inserting and Formatting Clip Art
- Inserting and Formatting Shapes, Word Art and Text Boxes
- Inserting and Formatting Smart Art
- Keyboard Shortcuts
- Section Review
Customize the Excel Interface
- Section Review
Training Features
Flexible Learning
Study247 anytime, anywhere on any device.
World Class E-learning Platform
Study in a user friendly, state-of-the-art e-learning platform.
Expert Instructor-Led Training
Access step-by-step video tutorials delivered by leading industry experts.
Visual Demonstrations & Multimedia Presentations
Develop your skills based on real world scenarios.
Quizzes & Mock Exam
Interactive quizzes after each module and a mock exam at the end of your course to ensure you're fully prepared for your final certification exam.
Flash Cards & Educational Games
Allow you to train in ways that keep you engaged and focus.
Social Learning & Networking
Interact and collaborate with other students, form study groups, engage in discussions, rate different courses and stay up to date with all the latest industry knowledge.
Navigation & Controls
Allows you to study in bite-size chunks. You can pause, rewind or fast forward your tutorials, take study notes and more.
Payment Options
For purchases of 1–9 learner enrolments, simply select the number of learners you wish to enrol and click Add to Basket. You can then complete your purchase using most major credit or debit cards, or PayPal. Once payment has been confirmed, we’ll process your order and email your course login instructions.
For 10 or more learner enrolments, bulk purchase discounts, or if you would prefer to pay by BACS bank transfer or invoice, please contact us using the enquiry form or email sales@study247.co.uk.
Purchase Order Payments: To purchase courses using a purchase order (PO), please email your PO details to sales@study247.co.uk, and our team will assist you with the enrolment process.
Student Reviews
There are no reviews for this course yet.
Unlock exclusive student discounts.
Related courses
This course is beneficial for anyone wanting to start-up their own business and take control of their own…
Original price was: £595.00.£89.00Current price is: £89.00.
In order to succeed in today's business world, you must have competent skills in Microsoft Office.
Original price was: £295.00.£49.00Current price is: £49.00.
In order to succeed in today's business world, you must have competent skills in Microsoft Office.
Original price was: £295.00.£49.00Current price is: £49.00.