Excel Advanced Data Extraction and Manipulation

[LeeAndro]

Published 08/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English + srt | Duration: 5 lectures (7h 36m) | Size: 4 GB

Business owner
Working Professional
Students
Secretary

Basic understanding of Excel

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.

This course is focused on the various excel techniques available to increase our current excel skills level to an advance skills level.

Course Content

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 functions

Tables and graphs

Create a pivot table

Protection in excel

All Included

Certificate of training

SAIT, SAICA, SAIBA, ACCA, IACSA, IRBA Accredited - 12 verifiable CPD hours

able course notes available

Assessment available

Students, Business owners, Working Professionals

HomePage:

https://anonymz.com/https://www.udemy.com/course/excel-advanced-data-extraction-and-manipulation/

DOWNLOAD

https://1dl.net/jzjk930081e9/9bEajeix__ExcelAdvan.part1.rar.html
https://1dl.net/afvbrj7jmca3/9bEajeix__ExcelAdvan.part2.rar.html
https://1dl.net/0haul8l3pdbt/9bEajeix__ExcelAdvan.part3.rar.html
https://1dl.net/dmsljczoi9dv/9bEajeix__ExcelAdvan.part4.rar.html