Advanced Excel Course
Learn advanced Excel techniques including Goal Seek, Data Tables, Pivot Tables, and Extended Graphics
Office Productivity,Microsoft,Excel
Lectures -17
Resources -2
Duration -1 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
This course is designed for intermediate Excel users who want to learn advanced techniques to take their skills to the next level. You will learn these advanced techniques to analyze large amounts of data and create extended graphics to present information clearly and concisely.
Advanced Excel Course Overview
This course is designed for intermediate Excel users who want to learn specific Excel features and functionalities to take their skills to the next level. You'll learn how to use Excel to solve complex problems, analyze large amounts of data, and create professional-looking reports and presentations.
Excel is a powerful tool for data analysis and presentation. This course is designed for intermediate Excel users who want to learn advanced techniques. You will learn how to use Excel to solve complex problems, analyze large amounts of data, and create professional-looking reports and presentations.
Goals
Use Goal Seek and "What if" Analysis to solve complex problems.
Create and use Data Tables and Pivot Tables to analyze large amounts of data.
Create Extended Graphics to present information clearly and concisely.
Learn to automate repetitive tasks using macros and VBA (Visual Basic for Applications).
Prerequisites
You should have an intermediate understanding of Excel before taking this course.
You should also have Excel 2007 installed.
![Advanced Excel Course Advanced Excel Course](https://d3mxt5v3yxgcsr.cloudfront.net/courses/3289/course_3289_image.png)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
1 Lectures
-
Introduction to the course and your tutor 02:51 02:51
Goal seek
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Pivot Tables
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Extended Graphics
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Final words
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Lisa Newton](https://www.tutorialspoint.com/assets/profiles/227404/profile/200_243461-1596604602.jpg)
Lisa Newton
Lisa Newton BA MSc AAT has a masters degree in Investment Management and a first class honours degree in Accounting with Marketing. She formed her first company in 2004 with £150 in the same month of graduating from City University, London UK. Lisa has never had a full time 9 to 5 job in her life. She's a serial entrepreneur and author who holds directorships in various industries including telecoms, property management, publishing, hair & beauty as well as finance. She has won various awards in Business including: Young Entrepreneur of the Year Award 2007, in 2008 Enterprising Business Award, in 2016 BE Mogul Award and has been nominated and shortlisted in numerous others. In 2011 and in 2012 one of her companies won Best Accounting Franchisor Award. In 2015 and 2017 one of her companies won Best Bookkeeping Business London (Accountancy International Awards).
Lisa's books include: How to write a book in two weeks, Constant Cashflow, Make the most of your money, How to start your own bookkeeping business, Cosmic ordering with Vision Boards, How to Franchise Your Business and Quickbooks Online The Handbook. Some of the books are in audio-format on itunes and audible.
Lisa hosts her own show The Authors Podcast which can be found on the iTunes channel.
Lisa supports the charity The MS Society. A speaker, coach, consultant and an avid networker, Lisa enjoys meeting people and working on projects with like-minded individuals.
In her spare time, Lisa likes traveling, dancing salsa, writing books, learning languages, meditation, yoga and cosmic ordering.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)