Tutorials [udemy] Excel Advanced Data Extraction and Manipulation

[Ronaldo99]

[udemy] Excel Advanced Data Extraction and Manipulation

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


Excel Advanced Series


What you'll learn
Business owner
Working Professional
Students
Secretary

Requirements
Basic understanding of Excel

Spoiler: 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.

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 time 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

Downloadable course notes available

Assessment available

Who this course is for
Students, Business owners, Working Professionals

Spoiler: ScreenShots

Download

File-Upload

You must be registered for see links

You must be registered for see links

UsersDrive

You must be registered for see links

You must be registered for see links

ClicknUpload

You must be registered for see links

You must be registered for see links

UptoBox

You must be registered for see links

You must be registered for see links

​

 

[Nunjapiznes]

@Ronaldo99 , hope you are doing well this Wednesday. Please reup this course. Thank you in advance !

 

[Moonshadowncj]

File Not Found​

The file you were looking for could not be found, sorry for any inconvenience.

Possible causes of this error could be:

• The file expired.
• The file was deleted by its owner.
• The file was deleted by administration because it didn't comply with our Terms of Use.

 

[Jimmy Collaros]

File Not Found​

The file you were looking for could not be found, sorry for any inconvenience.

Possible causes of this error could be:

• The file expired.
• The file was deleted by its owner.
• The file was deleted by administration because it didn't comply with our Terms of Use.

The file will be found in a few hours and it will be updated.
Ronaldo99 is tagged and he will fix it. I KNOW IT. HE WILL DO IT.

 

[Ronaldo99]

@Nunjapiznes , @Moonshadowncj , @Jimmy Collaros
All links have been updated

 

[Nunjapiznes]

Bro-fist coming your way, thanks @Ronaldo99 !

 

[KooMulee]

Thank you @Ronaldo99 for yet another great share.