Very good course
Excel for Business Professionals - Intermediate
Intermediate Excel skills and knowledge for Business and Professionals
Excel Formulas and Functions,Excel,Microsoft Office,Office Productivity
Lectures -28
Resources -54
Duration -2 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Hello and welcome to the second course of my Excel For Business series. In this Excel for Business - Intermediate course, you will build on the strong foundations you already have (after taking my Excel Essentials For Business course). The course will expand your Excel knowledge to new horizons through practical business examples.
You will discover a whole range of skills and techniques that will become a standard component of your everyday use of Excel. In this course, you will build a solid layer of more advanced skills so you can manage large datasets and create meaningful reports. These fundamental techniques and tools will allow you to add a sophisticated layer of automation and efficiency to your everyday tasks in Excel.
I will be with you every step of the way. Work through each new challenge step by step, and in no time, you will surprise yourself with how far you have come. Working through all the challenges, which are very common in the business environment, will help you relate to the skills and techniques learned each week more easily. You can then apply them to any familiar and new contexts you may come across in your daily tasks.
Thanks again for choosing my course. Let's enjoy, and improve together.
Goals
- You will learn Intermediate Excel skills and knowledge for  Business and Professionals
- You will learn how to link and work with data from multiple worksheets, workbooks with the same and different structures
- In addition, you will learn how to manage, edit, and maintain datasets much more efficiently and productively
- You will also learn how to use more formulas, do calculations and create different reports much more quickly.
Prerequisites
This course requires basic Excel skills and knowledge.
You need to be willing to learn and practice a lot
![Excel for Business Professionals - Intermediate Excel for Business Professionals - Intermediate](https://d3mxt5v3yxgcsr.cloudfront.net/courses/7910/course_7910_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Working with Multiple Worksheets & Workbooks
5 Lectures
-
Working with Multiple Worksheets 06:42 06:42
-
Using 3D formulas 05:16 05:16
-
Linking workbooks 06:54 06:54
-
Using Consolidate tool - consolidate by position 06:08 06:08
-
Using Consolidate tool - consolidate by reference 04:02 04:02
All about Named ranges
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Intermediate Excel functions
9 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
All about tables
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
All about Pivot tables
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![long nguyen](https://www.tutorialspoint.com/assets/profiles/456166/profile/200_224917-1654254777.jpg)
long nguyen
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)
Feedbacks
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)