Excel Database & Lists Training Course

Our Excel Database Training Course is designed for users whom primarily use Excel to manipulate and extracts of data from servers. The Excel Database training course will focus only on using Excel List Management tools. If you wish to add other content from any of our other Excel Training Courses, that's no problem. All of our Excel trainers are experienced and qualified to take your Excel Database training course into any direction as required. Please contact us if you wish to tailor your Excel Database Course

This is a 1 day training course and our standard rates apply.

Excel List Manipulation
  • Sorting
  • Auto and Advanced Filters
  • SubTotals
  • Pivot Tables
  • Using Excel Lists
  • Using Text to Columns
  • Using Data Form
Excel Database Functions
  • Lookup Functions including H and V Lookup, Match, Index
  • Database Functions - DSum,DAverage, DMax etc
  • Offset Functions
  • Transpose
Importing Text and CSV Files
  • Importing and Exporting of Text Files
Connecting to External Data Sources
  • Connecting to Access Databases
  • Connecting using ODBC Connections
XML Lists
  • Importing XML Lists
  • Reading XML Lists

 

 

Microsoft Training Courses

Adobe Courses

Mac Training Courses

Google Docs Courses

Evening Courses More Excel Courses

What can I expect?

Training Course FormatsFormats / Locations

Course BookingHow to book your course

Course Cost Explained

All our courses are charged at a flat rate per day.

NO NEED FOR UPFRONT PAYMENT!

Tips & Tricks

Get usefull tips and tricks with your favourite RSS Feed

 

Let us contact you. Simply select the button below and a member of our team will contact you back.

 


www Mouse