What is Microsoft Excel 2010? This online Microsoft excel training course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software at a beginner level. Whether you need to learn the skills for work, fill the gaps in your CV or simply fancy learning something new, this Excel course is perfect. This Microsoft Excel training is a great starting point to prepare for the intermediate and advanced Excel course. This course will give you a full overview of all of the most common features of Excel and how to use them. This online Microsoft excel training is designed to provide you with the essential skills you will need to be proficient in Excel, in a work or home environment, in as short a time as possible. Who is the Microsoft Excel 2010 Course Suitable For This online Microsoft Excel 2010 course is suitable for anyone looking to develop their Microsoft Excel 2010 skills. The course is also suitable for anyone who manages their Microsoft Excel training, this MS training can be used for on-boarding new staff, or as part of a team training plan. What's Included in the Microsoft Excel 2010 Course? Awarding Body MTA Course Duration 6 Hours This is only a guide to the learning hours required and it depends on how quickly an individual can absorb the information. The learning is online so it can be spread out over multiple sessions or done in one session. Learners will have access to this course for up to 12 months from the date of joining. There is no time limit to complete the course during this period. 12 Months Unlimited Access Each student will have 12 months unlimited access to allow you to have access to the training anytime 24/7. Course Content The Microsoft Excel 2010 - Beginners course is organised into the following modules: Introduction Course Outline Introducing Excel 2016 The Excel Interface Keyboard Shortcuts Section Review Basic File Commands and Operations Creating, Saving and Closing Workbooks Personalising 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 Analysing and Organising 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 Customise the Excel Interface Section Review Course Review Assessment / Exam There is no formal assessment on this course. Prerequisites Microsoft Excel 2010 installed on your device. You don't need any prior experience of using Microsoft Excel, our Microsoft Excel 2010 training covers beginners level training to help you develop the skills you need to progress in your career. 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 Career Advice Once you have achieved your certification, you'll have full access to our recruitment package for a wide range of information and advice - including: How to put together a killer CV, Covering Letters and Thank You emails. How to gain relevant work experience. How to prepare for interviews. How to understand Job adverts. How to choose the right recruitment agency. How to look for work on LinkedIn. Information on dealing with redundancy. Related Content Microsoft Powerpoint course Ultimate Microsoft Office 2019 Bundle course Microsoft Teams Microsoft courses Secretarial, PA & Office Skills courses Business, Management & Legal courses
