Advanced Excel Course
Learn advanced Excel techniques including Goal Seek, Data Tables, Pivot Tables, and Extended Graphics
Updated on Apr, 2024
Language - English
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
What will you learn in this course:
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
What are the prerequisites for this course?
You should have an intermediate understanding of Excel before taking this course.
You should also have Excel 2007 installed.
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
Pivot Tables
5 Lectures
Extended Graphics
2 Lectures
Final words
2 Lectures
Instructor Details
Lisa Newton
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
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
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now