Tutorialspoint

Excel Advanced - Data Extraction and Manipulation Course

Data Extraction and Manipulation

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.
Show More

Curriculum

  • Introduction
    17:49
    Preview
  • Part 1
    01:23:49
  • Part 2
    02:09:45
  • Part 3
    02:07:37
  • Part 4
    01:37:19
Feedbacks
5.0
Course Rating
100%
0%
0%
0%
0%

    Feedbacks (2)

  • Tataji K
    Tataji K

    It's Very Good and Simple to Learning.

  • vinay kumar
    vinay kumar

Excel Advanced - Data Extraction and Manipulation Course
This Course Includes
  • 7.5 hours
  • 5 Lectures
  • 1 Resources
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

sample certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate

Talk to us

1800-202-0515