Microsoft Excel Advanced with CPD Certificate - Liverpool
Classroom based CPD Accredited course with Post Course Support – All Level Introduction to Advance and beyond
Summary
Bank Transfer
Credit or Debit Card
PayPal
- Tutor is available to students
Add to basket or enquire
Location & dates
Exchange Flags
LIVERPOOL
Merseyside
L23PF
United Kingdom
Overview
This intensive 1 day, hands-on course Microsoft Excel Advanced course is fully Accredited by CPD and helps you gain comprehensive, practical understanding of Excel.
You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.
This course is suitable for anybody wanting to learn 2013, 2010 or 2007, as it covers all the aspects and differences between the versions.
Benefits of Studying Excel with Infero Training:
- Instructor-Led course in a small group for maximum knowledge retention
- Comfortable Premises with the latest technology
- Microsoft Official Curriculum (optional)
- Free 12 Months Post Course Support
- Certificate of Completion
- CPD Points
- Refreshments
Certification
Upon completion of the course, you will receive CPD Points.
This course is also one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets. The Microsoft Certified Application Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified
CPD
Course media
Description
Course Content
Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously
Topic 1A: Use 3-D References
Topic 1B: Use Links and External References
Topic 1C: Consolidate Data
Lesson 2: Sharing and Protecting Workbooks
Topic 2A: Collaborate on a Workbook
Topic 2B: Protect Worksheets and Workbooks
Lesson 3: Automating Workbook Functionality
Topic 3A: Apply Data Validation
Topic 3B: Work with Forms and Controls
Topic 3C: Work with Macros
Lesson 4: Applying Conditional Logic
Topic 4A: Use Lookup Functions
Topic 4B: Combine Functions
Topic 4C: Use Formulas and Functions to Apply Conditional Formatting
Lesson 5: Auditing Worksheets
Topic 5A: Trace Cells
Topic 5B: Search for Invalid Data and Formulas with Errors
Topic 5C: Watch and Evaluate Formulas
Lesson 6: Using Automated Analysis Tools
Topic 6A: Determine Potential Outcomes Using Data Tables
Topic 6B: Determine Potential Outcomes Using Scenarios
Topic 6C: Use the Goal Seek Feature
Topic 6D: Activate and Use the Solver Tool
Topic 6E: Analyse Data with Analysis ToolPak Tools
Lesson 7: Presenting Your Data Visually
Topic 7A: Use Advanced Chart Features
Topic 7B: Create Sparklines
Course Objectives
Upon successful completion of this course, students will be able to:
- Work with multiple worksheets and workbooks simultaneously.
- Share and protect workbooks.
- Automate workbook functionality.
- Apply conditional logic.
- Audit worksheets.
- Use automated analysis tools.
- Present your data visually.
Who is this course for?
This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.
Requirements
Before taking this course, students are recommended to take the following courses, or have equivalent knowledge:
- Microsoft Excel Introduction
- Microsoft Excel Intermediate
Career path
Being proficient in Excel can open the door to many career opportunities such as:
- Administrative Assistant
- Data Analyst
- Accountants
- Financial Analyst
- Retail Store Manager
- Project Manager
- Business Analyst
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Provider
Infero Training is an up and coming, independent training provider offering more than 400 Instructor-led Business and IT courses throughout the UK. We deliver high quality, bespoke training to an ever-growing client base.
We are equally suited to working with large companies and small independent ones like ours!
Our tight-knit, customer-focused management team are quick to respond to the ever-changing marketplace, introducing the latest products and services.
We support our clients throughout the entire training cycle. The first step often being our expert guidance on training courses and materials, right through to post course support.
We are Microsoft Partners and registered on the UK Register of Learning Providers. With approval from the Skills Funding Agency and the Crown Commercial Service, plus accreditation from Continuing Professional Development (CPD), you can rest assured that Infero can deliver training at the highest quality.
Whatever your size or type of business we will take the time to understand your business needs and how we can help you to reduce costs and improve efficiency.
Add to basket or enquire
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.
