It's Very Good and Simple to Learning.
Excel Advanced - Data Extraction and Manipulation Course
Data Extraction and Manipulation
Excel,Office Productivity,Microsoft
Lectures -5
Resources -1
Duration -7.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
As a student, working professional, business owner etc., you will use excel on a daily basis to compile working papers and perform calculations. Are you aware of the functions available to increase your productivity?
When you understand Excel at a more advanced level, you will have the ability to use its more sophisticated tools, which will allow you to complete your tasks and analyze your data more quickly. It will also allow you to keep team members up-to-date on data, which can streamline the workflow process.
You can create powerful reports, by making use of ODBC, Microsoft Query and various excel techniques. This session focuses on creating reports in excel using ODBC for Pastel and using excel techniques to edit and work with the data.
Goals
- Setting up the ODBC Drivers
- Importing data from Pastel
- Creating queries using the Query wizard
- Moving around in large worksheets by using the hot keys
- Formatting data
- Sorting and filtering a database
- Using advanced filter
- Using the IF/AND functions
- The COUNTIF function
- VLOOKUP function
- Date and time functions
- Tables and graphs
- Create a pivot table
- Protection in excel
Prerequisites
- Basic to Intermediate understanding of Excel.
![Excel Advanced - Data Extraction and Manipulation Course Excel Advanced - Data Extraction and Manipulation Course](https://d3mxt5v3yxgcsr.cloudfront.net/courses/10639/course_10639_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Excel Advanced Data Extraction and Manipulation Course
5 Lectures
-
Introduction 17:49 17:49
-
Part 1 01:23:49 01:23:49
-
Part 2 02:09:45 02:09:45
-
Part 3 02:07:37 02:07:37
-
Part 4 01:37:19 01:37:19
Instructor Details
![Bizfacility](https://www.tutorialspoint.com/assets/profiles/462550/profile/200_2022012-1653031696.png)
Bizfacility
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)