Microsoft Excel 2016 Intermediate
John Academy
Summary
Overview
This Microsoft Excel 2016 Intermediate will teach you to create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at high level.
If you have equivalent knowledge of Microsoft Excel 2016 Introduction then this course is perfect for you to expand your knowledge and skills. So, if you want to advance your skill set by learning to work with advanced formulas, lists, and illustrations you can join this course. You will also work with charts and advanced formatting including styles.
So, why are you thinking? Come and be a part of this course now.
Course media
Description
Learning Outcomes:
- Creating advanced formulas through utilizing range names in formulas and functions and specialized functions
- Analyze data using text, logical, lookup, date and financial functions
- Create and modify tables, sort and filter data, using subtotal features, and working with database functions
- Creating trendline, advanced charts, also formatting and modifying charts in order to visualize data
- Using PivotTables, slicers and PivotCharts to analyze data
- Incorporate SmartArt, as well as insert, modify, layer and group graphical objects
- Customize workbooks, manage themes, and create and use templates
- Preparing and protecting workbooks for multiple users
Why choose us?
- Study in a user-friendly, advanced online learning platform;
- All the study materials are available in your student portal including videos tutorials.
- One of the most successful online education platforms in the UK.
- Affordable, engaging & high-quality e-learning study materials;
- You will have unlimited access to online learning platform in 24 hours a day, 7 days a week in 12 Months.
- Efficient exam systems for the assessment and instant result;
- The UK & internationally recognised accredited qualification;
- Access to course content on mobile, tablet or desktop from anywhere anytime;
- The benefit of applying for NUS Extra Discount Card;
- 24/7 student support.
- Technical supports and live chat service for your inquiries. This is very helpful for international learners.
- Excellent and flexible mentor supports by our team of experienced tutors/trainers via email.
COURSE CURRICULUM
- Apply Range Names
- Use Specialized Functions
- Use Text Functions
- Use Logical Functions
- Use Lookup Functions
- Use Date Functions
- Use Financial Functions
- Create and Modify Tables
- Sort and Filter Data
- Use Subtotal and Database Functions to Calculate Data
- Create Charts
- Modify and Format Charts
- Create a Trendline
- Create Advanced Charts
- Create a PivotTable
- Filter Data by Using Slicers
- Analyze Data with PivotCharts
- Insert and Modify Graphic Objects
- Layer and Group Graphic Objects
- Incorporate SmartArt
- Customize Workbooks
- Manage Themes
- Create and Use Templates
- Protect Files
- Preparing a Workbook for Multiple Audiences
John Academy: A Great Place to Learn for Everyone, Forever
Expert Authors: We select authors with expertise and experience of training professionals. Our authors are industry experts, academics, authors, face-to-face trainers or online trainers; most often they have a combination of these backgrounds
Engaging Content: Our succinct, bite-sized and business-focussed course materials are designed to deliver the most effective training for you. Each course is made up of modules, manageable learning chunks of text, images, videos and tasks.
John Academy: A Great Place to Learn for Everyone, Forever
Expert Authors: We select authors with expertise and experience of training professionals. Our authors are industry experts, academics, authors, face-to-face trainers or online trainers; most often they have a combination of these backgrounds
Engaging Content: Our succinct, bite-sized and business-focussed course materials are designed to deliver the most effective training for you. Each course is made up of modules, manageable learning chunks of text, images, videos and tasks.
Assessment and Certification:
Upon completion of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and the results will be given to you immediately. Before sitting your final exam you will have the opportunity to test your proficiency with a mock exam. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £24 for a PDF copy and £39 for an original print copy sent to you by post.
Who is this course for?
Microsoft Excel 2016 Intermediate is certified by CPD QS & IAO Accredited. This makes it 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.
Requirements
Our Microsoft Excel 2016 Intermediate is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
Career path
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.
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.
FAQs
Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2024. All rights reserved.