Monthly Archives: October 2019

Excel Maps

The following two videos explain how to use the Excel maps feature and the 3D Maps feature powered by Microsoft Bing.

Both these topics are cover on the Excel courses provide either online at http://www.itseasytraining or classroom based onsite or in our Gateshead training room.

Details and course outline for Microsoft Excel training courses can be found by clicking here.

Excel Maps

The first video explains how to create a map based on geographical data. The example uses data from four European country. The tutor mentions how to change the layout, colour and style of the map. The Map feature is part of the Charts group and complements it very well.

3D Maps

When you use the 3D map feature you need an Internet connection for it to work. You also require geographical data so that the tool can plot the map. You create a series of tours, these tour will play along a timeline if you have date related data selected as shown in the video. If you are happy with the end product you have the option to save the tour as a video and then email or share it with colleagues. There are possibilities to create more complex tours by adding extra layers with additional animations.

Access courses

Microsoft Access courses are delivered in two formats, classroom based and online based.  If you wish to complete an online course check out http://www.itseasytraining.co.uk . Classroom based course details can be found here.

You can assess your knowledge levels by completing the Excel document here Check Skill Level Once you have completed the document email to info@itseasy.co.uk You can book courses via email or by calling 01670 732139.

Prices and location can be found here General information about IT’s Easy Training and delivery methods can be found here

Update Queries

This video explains how to create an update query and how to qualify the query with a filtered field. The tutorial mentions that an update query does not display the result of the query, as is the case with a basic select query. An update query carries out the request and changes the data in the underlying table. It is very important that users understand that an update query can be dangerous if clicked and ran without understanding what will happen. Each time the query runs the data may be changed.

The example shown uses the parameter query feature to demonstrate the best way to create a flexible query. The parameter query uses the small square bracket symbols displayed on the keyboard to provide space for a data entry prompt. [Enter the city] for example.

Calculations in a query

The video explains how to create a calculation at query level. The example shown is a simple divide and multiplication calculation. This information is covered on the intermediate and advanced Access courses. Details can be found here.