This is part 2 of a 2 part course to help staff prepare for ECDL Module 5. The course covers: what a database is in terms of tables, records and fields; how to specify fields with data types and field property settings; how to set a field as a primary key, switch between view modes […]
This is part 1 of a 2 part course to help staff prepare for ECDL Module 5. The course covers: what a database is in terms of tables, records and fields; how to specify fields with data types and field property settings; how to set a field as a primary key, switch between view modes […]
“Power Query and Power Pivot aka Get and Transform are the best thing to happen to Excel in 20 years”. Bill Jelen, Excel MVP How long would it take you to combine data from 15 workbooks into a single data set? A few minutes, an hour? If you’re using Get & Transform (previously known as […]
