Excel Advanced Data Extraction and Manipulation
Learn advanced Excel techniques to increase your productivity and analyze data quickly. Create powerful reports using ODBC and Microsoft Query. This course is suitable for students, business owners, and working professionals. SAIT, SAICA, SAIBA, ACCA, IACSA, IRBA accredited with 12 CPD hours. Downloadable course notes and assessment available.
What you’ll learn
- Business owner
- Working Professional
- Students
- Secretary
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
User Reviews
Be the first to review “Excel Advanced Data Extraction and Manipulation”
You must be logged in to post a review.
There are no reviews yet.