Archive for the 'Other Articles' Category

Top Tips For Applying for Online Jobs

If you have not applied for a job in a while, you may find that the whole business of application for a new position has changed a lot. Whereas, in the past, jobs were applied for by post, over the phone or in person, now the vast majority of applications are done online. CVs, cover letters and references are no longer submitted as paper copies, they are now sent online to the recruiter either by email or on their website.

Before you Apply

To apply for jobs online, you need a number of things:

  • Internet Access – This seems obvious, but reliable internet access is essential. If you don’t have this, then you should be able to get it at a local library or in some of the larger Job Centres
  • A Computer -Again, this seems obvious, but the internet can also be accessed via a wide variety of devices. Phones or tablets could be used, but a PC or laptop is much more suited for job application. Remember you will also need a word processing application of some kind, ideally Microsoft Word.
  • Email Address -Your email address should be a professional one, that is yours to use. This doesn’t mean one related to work, but use an email like rather than
  • Up-to-date CV – Make sure you have an up-to-date CV, with the correct contact details before you start applying. This is possibly the most important thing you need to prepare. For help on getting your CV the best it can be, check this guide. It’s also useful to draft a basic cover letter that you can be customised for each job you apply to.  Not all jobs will require this, but it is useful to have ready for those that do. A good tip is to save your CV with a title containing “CV”, as well as your first name, your last name and the current year.

1. Use Job Search Websites

The vast majority of (although not all) online jobs appear on Job-Search websites. There are a lot of these. These websites allow you to search for jobs using different filters, like position title, salary and location. It is a good idea to register and build a profile on a number of these. You can save searches and get the website to email notifications of any jobs that may be of interest to you. Here is a list of the top ten job websites.

2. Adapt your Application

Although many companies use Job-Search Websites, some don’t and you will need to ensure you apply in the way that they have asked you to.  Company websites are a good source of job listings, and you may be able to apply directly via the company website. Do this, even if you have seen the job elsewhere, as this may give your application an advantage over those coming from Job-Search websites.

Some smaller companies may just require you to email a copy of your CV and covering letter. A good tip is add your full name and the title of the position the subject line of the email.

Sometimes you may be asked to convert your CV into a PDF or other kind of file. You may need to complete and online application form, section by section, like a paper application. Just make sure you follow all instructions and carefully proofread your application before you click the “Submit” button. Follow all the application instructions and double check that you’ve done so, at the end.

3. Keywords

Keywords are very important in online Job application for two reasons:

When you look for jobs online, the most effective way to search is to use job keywords to find the jobs in you are interested in. Create a list of job-search that reflect your job interests, including the location you want to work, type of position, industry, etc.

You should also be aware of the keywords that employers use in their job advertisements. You should use these in your CV and cover letter. In fact, you should adjust your CV for each application, using any keywords the employer uses, if this is possible. Many employers receive far more CVs than they can check through practically, so Applicant Tracking Systems (ATS), or ‘Resume Robots’ can reject up to 75% of CVs before getting to a person. These ATS use key words to identify people with the required skills and qualifications.

4. Don’t Apply if you are not Qualified

Read the job description well before you start and only apply if you meet the requirements. Applying for a job takes time, so you can save time and effort by being selective. If you aren’t qualified, then chances are, your application will be unsuccessful.

5. Check and Double Check

Check that your spelling, grammar and content don’t have errors. Fit your experience to the job you are applying for, be original and be honest. When you have done all this check again before you submit.

6. Keep Track of Your Applications

Check your email account at least once a day for any replies or offers of interview. Don’t forget to check your spam folder as important emails can end up there. If you have had missed calls, make sure you follow these up.

It also helps to keep a written or digital record of the jobs you’ve applied for. This will help you remember who you should follow-up with and what different roles you’ve applied for. Either call or email the employer if you haven’t heard anything, after an appropriate interval.  Unfortunately, not all employees respond or even let you know that you have been unsuccessful. They may even state in the Job Description that if you do not hear from them to assume you were unsuccessful.

7. Keep Applying

It may take some time and quite a few applications before you secure your new job. The important thing is to keep trying and keep on applying.

Good luck!


Cyber Security Month

October is Cyber security awareness month, an annual global initiative to raise awareness on the issues around cyber security and promote good cyber security practices for both individuals and organisations. Cyber Security Awareness month started in the U.S.A and then in 2013, The European Union Agency for Network and Information Security (ENISA) started the European Cyber Security Month (ECSM).

This is so important because governments, the financial sector and all other organisations now collect, process, and store incredible amounts of data on their computers and other devices. Every day thousands of networks are compromised and data stolen. Much of that data can be sensitive information, such as intellectual property, financial data, or personal information. This is not only embarrassing and costly, but because of the General Data Protection Regulation (GDPR) which says that companies must safeguard their data, it means that organisations can be fined for allowing data breaches to happen.

What is Cyber Security?

Cyber security is a wide area and can apply to anything from business to mobile computing. It covers all aspects of defending networks, computers, servers, mobile devices and electronic systems from malicious attacks. There are a number of areas that need to be considered when looking at Cyber Security:

Network security is simply the process of protecting the network from unwanted users, attacks and intrusions.

Application security focuses on keeping software and devices free of threats, which could lead to data breaches or attacks on a system. Applications should be constantly updated and tested. Good software will have regular security updates.

Disaster recovery is the plans an organisation has to responds to a cyber-security incident or other event that causes the loss of operations or data and how it will return to the same operating capacity as before the event.

End-user education: The weakest link in any good Cyber Security are the users of the system. A virus can be introduced into a very secure system by an individual failing to follow good security practices. Teaching good habits such as regular password changing and using 2-factor authentication, the deletion of suspicious email attachments, not plugging in unidentified USB drives, etc. is important to maintain the security of any organization.

Operational security includes all processes for handling and protecting data. The permissions users have to access a network and how and where data may be stored or shared are part of this. It means that you must manage each user’s security identity controlling exactly what they can and can’t do.

Database and infrastructure security:  It’s a fact that most data is stored in some sort of database and that everything is stored (ultimately) on physical equipment. All of this needs to be properly secured.

Cloud security means that organisations have to think of data stored in an online environment and Mobile security, which can be mobile phones and/or tablets involve all of the other issues of Cyber Security, with the added problem that this equipment is taken and used in remote locations.

Types of Cyber Threats

Cyber security threats can be placed into three broad categories:

  1. Cybercrime which is groups or individuals targeting companies or systems, usually for financial gain, or to cause disruption.
  2. A Cyber-attack often involves information theft and this may be politically motivated.
  3. Cyberterrorism is intended to disrupt or bring down electronic systems to cause panic or fear. Cyber-attacks and digital spying are now considered the top threat to national security, eclipsing even conventional terrorism.

In 2020 the number of UK data breaches were considerable:

  • 43% of businesses identified cyber security breaches or attacks in the last year
  • Up to 88% of UK companies have suffered breaches in the last 12 months.
  • One in every 3,722 emails in the UK is a phishing attempt
  • One small business in the UK is successfully hacked every 19 seconds

The UK government has set out its Minimum Cyber Security Standards for Cyber Security. You can learn more about Cyber Security Month here

The 10 Best Places to Visit in the UK

Travel rules and restrictions have caused many of us to chose a staycation this year. The UK is full of places to holiday, places for a short stay, or places for a day-trip. It also has a massively wide breadth of location types, encompassing historic urban centres, scenic landscapes, incredible coastlines, stunning national parks and awesome scenery.

Whatever you are planning, the UK has something for you. With that in mind, here are our top ten suggestions:

1. The Lake District

The Lake District is one of the most popular places to visit in the U.K. It is the UK’s most popular national park and a UNESCO World Heritage Site since 2017. Try climbing Scafell Pike, the highest mountain in England. There is everything from lake cruises to mountain walks, hiking, photography, outdoor adventures and cosy pubs with home-cooked food. Or take a narrow-gauge steam train ride from Ravensglass deep into the Eskdale valley.

2. Brighton

Brighton isn’t an ordinary seaside town and there is always something new, each time you visit. Soak up its oddball, alternative character by exploring the warren of streets known as the Lanes; sprinkled with vegan cafes, espresso bars, chaotic pubs, record stores and bric-a-brac shops. Don’t forget the Royal Pavilion, a 19th-century party palace built by the Prince Regent. You can still have fish and chips on the pier, and the Seven Sisters cliffs are nearby too.

3. Bath

In a nation full of great cities, Bath is one of the most visually spectacular, full of buildings built with honey-coloured Bath stone. Of course, there are the Roman Baths, but there is also the Jane Austen Centre, and the Bath Assembly Rooms, Georgian ballrooms which were the setting for scenes for two of Austin’s novels (Persuasion and Northanger Abbey). Don’t miss The Circus, and the famous Royal Crescent.  It’s also a beautiful place to visit in winter because (if running) the Christmas markets are fantastic!

4. York

York may be the only city to rival Bath as the prettiest city in England, although visually, the two couldn’t be more different. Seeing York Minster is obviously a must. A landmark of York which has a giant east-facing window that had the largest expanse of stained glass anywhere in the world, before the modern era. Walk the almost complete 13th-century walls in a magnificent circuit. There is also The Shambles, filled with picturesque cobbled streets, cafes, and restaurants, and supposedly the inspiration for Harry Potter’s Diagon Alley. The Jorvik Viking Centre is well worth a visit. It’s the only place in the world where you can go on a fun-fair ride that is also a history lecture. The whole place feels like an old Viking City. And lastly, if you can get in, you must, must, must have afternoon tea at Betty’s Tea Rooms.

5. Stonehenge

Stonehenge is the only surviving lintelled stone circle in the world, at around 5000 years old. Stonehenge has an impressive visitor and has been a legally protected Scheduled Ancient Monument since 1882.The site and its surroundings were added to UNESCO’s list of World Heritage Sites in 1986. You may have seen it many times in photographs and TV, but only seeing it “in the stone” will give you a real appreciation of this monumental monument.

6. London

Without a doubt, the world’s greatest city. You could live there for many years and only scratch the surface of what the mother of all metropolis’s has to offer. There are the obvious attractions of the Tower of London, Westminster Abbey, Big Ben and museums such as British Museum, Natural History Museum and the Science Museum, art galleries, including Tate Modern, Tate Britain and the National Gallery, all of which are free to visit. But London keeps giving. Try the incredible Museum of London or Royal Observatory Greenwich. And for a hidden, hardly seen by Tourists, spectacular gem, visit the Inns of Court, in the heart of London, a stone’s throw from major attractions.

7. Cambridge

Full of incredible architecture that will make you go ‘ooohhh’ every time you turn a corner. And you can also have a punt along the Cam.

8. Devon

The only English county so good it has two coastlines. There are an amazing mix of places from cities like Exeter and Plymouth, the English Riviera of Torbay, Dartmoor and the quieter north coast where you’ll find places like Barnstaple.

9. The Cotswolds

A region spread over six English counties and a designated Area of Outstanding beauty. Here is all that was perceived as traditionally and quintessentially English; a tangle of quaint villages of rose-clad cottages, village greens with pubs serving fine ales, and views of lush green hills. There are many long-distance trails including the Cotswold Way, perfect for walking, cycling and horse-riding.

10. Cheddar Gorge

Visit for the Gorge itself, the incredible caves and the sight of large truckles of cheddar aging slowly, in the darkness. Stay for the scenery, caving, climbing and more!

Things You Didn’t Know Microsoft Teams Could Do

Over the last year, Teams has gone from a relatively obscure part of the MS Office suite to being one of its most used. The number of users has almost doubled in that time, increasing from 75 million users in April 2020 to 145 million in April 2021. And it’s still a relative newcomer, only being launched in 2016. If you still aren’t familiar with it, here is all you need to know:

Good shared workspace software should make collaboration easier. Microsoft Teams unifies chat, voice, video and file sharing and is designed to be used by any work group, large or small, whether they are local or remote. It’s also designed to help increase worker productivity by providing a unified suite of tools. The good news is that, for those organisations that already have Microsoft 365 and Office 365 it’s included totally free.

Although it only appeared a few years ago, Microsoft has constantly updated Teams since its initial launch. New features were added throughout 2020 and into 2021:


As with most collaboration apps, Teams has a chat function that offers both one-on-one and group chats. Teams’ chat includes text formatting, emojis and priority flagging. Files can be shared directly through chat sessions.


Teams’ main strength is in the ability to collaborate through different channels. Channels can be either Standard, public and open to everyone who wants to join, or Private and focused on specific topics or activities.  Channels tend to have a specific work project or topic, and can be thought of as group chat rooms, suited to the fast-paced conversations impossible on email.

All team members should be able to view and add to different conversations in the General channel. The @ function can be used to invite other members to different conversations.


Teams has Online video calling, which can be done to anyone within the company or business or clients outside the business. Teams offers videoconferencing for up to 250 users per session.

Online meetings in Teams can include anyone outside or inside a business. This feature also includes a note-taking app, file uploading, and in-meeting chat messaging. Teams also allows desktop sharing for technical assistance and real-time collaboration on documents.

Video meetings can be scheduled on a channel’s calendar, or users can create them on the fly.


Teams actually offers outbound calling directly from the client. This allows mobile users with no current internet access to connect to a meeting. In fact, Teams can replace a business’s existing phone system using Microsoft 365 Business Voice, but this does require the purchase of an additional licence.

SharePoint Document Storage

Every team who uses Microsoft Teams will have a site in SharePoint Online, containing a default document library folder. Any files shared in conversations will also automatically save to this folder.

Integration with Microsoft Office

As you would expect, Teams is tightly integrated with the rest of Microsoft 365. Word, Excel, PowerPoint and other files can be created and managed within channels. Calendaring connects right into Outlook.

Other Features

  • Teams provides all of the security features of the broader Microsoft 365 suite including two-factor authentication and encryption in transit and at rest in the cloud.
  • Teams offers greater data visibility because all conversations within Teams are persistent. Files and conversations in Teams channels are all saved in the Microsoft 365 cloud, making that data available to Microsoft Graph.
  • Teams supports Training sessions as Trainers can send automated alerts to every student in the session. Teams now also supports virtual breakout rooms. These are essential if trainees are being asked to work on group assignments.

If you want to find out more about the capabilities of Teams and how you can use them, please contact us today about the Training that we have for MS Teams at Infero.

Data Analysis and Visualization with Microsoft Excel

Oil companies once ruled the globe, because they had control of an immense, untapped valuable asset – oil. It was so valuable that it was known as ‘Black Gold’. Now Data is the ‘New Oil’: the black gold of the 21st century. All businesses have lots of Data, but, in itself, Data is merely facts and figures. Just as oil needs to be refined and processed to be useful, Data needs to be analysed.

Data analysis is the process of inspecting, cleansing and transforming Data, so that it can be structured and presented as useful information, informing conclusions, and supporting decision-making. Data is, in fact, fundamentally changing the world we live in and analysing Data to find is now a key skill in many job roles.

Excel is designed specifically for Data analysis. It can connect to a wide range of Data sources, clean and transform Data automatically, and create incredible visualizations to show trends, and create reports. Infero’s new 3-day Data Analysis and Visualization with Microsoft Excel course covers all of Excel’s extensive Data analysis capabilities.

Data Analysis and Visualization with Microsoft Excel

Delivery Method – Instructor-led, group-paced, online or classroom-delivery learning model with structured hands-on activities.

Target Students – Business professionals who want to learn how to perform advanced Data and statistical analysis with Microsoft Excel using PivotTables; be able to use tools such as Power Pivot and the Data Analysis ToolPak to analyse Data, and learn how to visualize Data in charts and dashboards in Excel.

Prerequisites – Before taking this course, students are recommended to have taken the Microsoft Excel Introduction course, or have equivalent knowledge:

Course Objectives

Upon successful completion of this course, students will be able to analyse and visualize Data using Microsoft Excel and associated tools. You will:

  • Perform Data analysis fundamentals.
  • Visualize Data with Excel.
  • Analyse Data with formulas and functions.
  • Analyse Data with PivotTables.
  • Present visual insights with dashboards in Excel.
  • Create geospatial visualization with Excel.
  • Perform statistical analysis.
  • Get and transform Data.
  • Model and analyse Data with Power Pivot.
  • Present insights with reports.

Course Content


Lesson 1: Data Analysis Fundamentals

Topic A: Introduction to Data Science

Topic B: Create and Modify Tables

Topic C: Sort and Filter Data

Lesson 2: Visualizing Data with Excel

Topic A: Visualize Data with Charts

Topic B: Modify and Format Charts

Lesson 3: Analysing Data with Formulas and Functions

Topic A: Analyse Data with Formulas and Named Ranges

Topic B: Analyse Data with Functions

Lesson 4: Analysing Data with PivotTables

Topic A: Create a PivotTable

Topic B: Analyse PivotTable Data

Lesson 5: Presenting Visual Insights with Dashboards in Excel

Topic A: Visualize Data with PivotCharts

Topic B: Filter Data Using Slicers and Timelines

Topic C: Create a Dashboard in Excel


Lesson 6: Automating Data Analysis

Topic A: Implement Data Validation, Forms, and Controls

Topic B: Adding Form Controls to a Worksheet

Topic C: Create Conditional Visualizations with Lookup Functions

Lesson 7: Creating Geospatial Visualizations with Excel

Topic A: Create Map Charts in Excel

Topic B: Customize Map Charts in Excel

Lesson 8: Performing Statistical Analysis

Topic A: Visualize Trendlines and Sparklines with Excel

Topic B: Analyse Data with the Data Analysis ToolPak

Topic C: Apply Best Practices in Chart Design


Lesson 9: Getting and Transforming Data

Topic A: Connect to Data with Queries

Topic B: Clean and Combine Data

Topic C: Shape and Transform Data

Lesson 10: Modelling Data with Power Pivot

Topic A: Install Power Pivot in Excel

Topic B: Create Data Models with Power Pivot

Topic C: Create Power Pivots

Lesson 11: Analysing Data with Power Pivot

Topic A: Data Analysis Expressions (DAX)

Topic B: Perform Advanced Data Analysis and Visualization with DAX

Topic C: Creating a Key Performance Indicator (KPI)

Topic D: Working with Dates and Times in PowerPivot

Lesson 12: Presenting Insights with Reports

Topic A: Plan a Report

Topic B: Create a Report

4 Events for September

It’s September and autumn is almost here. The schools have gone back, and the holiday season is over. If you think that it’s now just the long wait until Christmas, you would be wrong.  There are still some great events going on across the UK. Here are four of them that you are happening during the month of September.

The 2021 Blackpool Illuminations

Everyone had heard of the Blackpool Illuminations, but you may not have seen them. They are definitely a spectacle that everyone should see at least once and have millions of visitors every year (in normal years). Known to many as the greatest free light show on earth, they have been on of Blackpool’s attraction since 1879 and have even been described as ‘Artificial Sunshine’.

Back in its full glory, after COVID-19, the annual Illuminations display is to be extended by two months this year, to provide an invaluable boost to the resort’s tourism season. The BIG Switch On event is back on Friday 3 September, with the incredible light show going on all the way through to Sunday 3 January 2022. A bigger and brighter Christmas this is also promised with themed events, shows and attractions.

DATES: Friday 3 September – Monday 3 January 2022

Take the Scilly Sea Swim Challenge

This is not for the faint hearted, but you can just be a spectator, or you can test yourself by taking the challenge of swimming and walking between all of Scilly’s main islands in just one day.

The event starts from Bar on the north side of St Mary’s, at sunrise, when those taking part dive into the sea to begin the Scilly Swim Challenge. Over the course of a single day, swimmers cross between all six of the main islands that make up the Isles of Scilly. It should be emphasised that the event is non-competitive. The point is to challenge yourself, not the others taking part. There is a total distance of approximately 15km (or just over 9 miles) of swimming to be done. Add that to the low temperatures of the September seas, and you need to be fit and prepared for this event. There is, however, another event offering the same challenge, which takes place over two days.

Dates:  The One Day Scilly Swim Challenge takes place on 10 September, while the Two-Day Challenge takes place between 7-8 September. Tickets for both are available from the website.

The Ludlow Food Festival

Add passionate local chefs and food producers, with thousands of food lovers and you get the perfect recipe for Ludlow Food Festival.

Normally held every September in the grounds of Ludlow Castle, Ludlow Food Festival claims to be the “Original Food Festival for Food and Drink Lovers” It showcases the very best local food and drink producers from Shropshire and the Marches. Inside the Castle walls, the festival includes demonstrations and talks, and it is possible to take part in workshops and masterclasses. If that sounds far too much like hard work, you can just spend time sampling the wares of the 180-plus exhibitors and stock up on tasty stuff to take home.  You’ll also find of related ‘foody’ events and activities taking place across Ludlow’s historic town centre.

Dates: 10th, 11th & 12th September 2021

Gloucester History Festival

You can Celebrate over 2,000 years of Gloucester’s history, with family activities, parades, re-enactments, talks and tours at the Gloucester History Festival. The Blackfriars Talks series features eminent historians and authors covering subjects of local and national interest.

Part of the festival includes one of the largest Heritage Open Days in the country, when the city celebrates its wealth of history, marvellous architecture and culture by offering free access to properties that are usually closed to the public.

Dates:  7-22 September

What is PowerPivot?

PowerPivot is an Excel add-in which allows you to take large volumes of data from various sources (all at the same time, if that’s what you need to do) and create relationships between the information in a ‘data-model’. Once there, you are able to perform information analysis and share insights. Even better PowerPivot allows you to make changes and adjustments quickly and easily.

Importing Data from Different Sources

While Excel, on its own, can manage data from a variety of sources, including SQL Server, and Microsoft Access, and even data from the web, it is difficult to create relationships between the data from such sources. However, Power Pivot was designed precisely to do this. Data from anywhere, essentially, can be imported, and relationships can be created.

Fast Data Analysis

In some cases, analysis of large sets of data, or data taken from different sources, can take several days. With Power Pivot, the same data might be analysed in hours. The real power of PowerPivot, however, is the fact that data can be easily moved, changed, and adjusted. This ability to adjust on the fly and to be able to immediately ask new questions and react to changes in a business is absolutely invaluable in the age of Big Data.

Output Data Anywhere

Power Pivot can be used to create visual data that can be outputted to Excel worksheets or to PivotTables and PivotCharts. Data on Worksheets can then be used to create a dashboard, so that the analysis that has been performed can be easily viewed and shared, and even interacted with if the worksheet is put together correctly.

It’s Still Excel But with More Capabilities. Power Pivot is still PivotTables.  It’s still formulas, but it adds many new capabilities to Excel:

  • Import and manipulate hundreds of millions of rows of data. (Excel has a limit of just over a million rows.) It has a virtually limitless data capacity
  • Import data from multiple sources into one single source workbook
  • PowerPoints manipulates and analyses data without slowing down your computer. It has fast calculations, even with multiple, massive, and linked tables.
  • Visualize the data with PivotCharts and Power BI.
  • It includes a 100+ new functions (ex: COUNTROWS, SWITCH, TOPN) which join old favourites like SUM, IF, etc.
  • All functions now work in pivots, and they auto-adjust as pivots change size & shape.
  • PowerPivot also has automatic refresh and built-in web reach.

PowerPivot is free as an add-in and available in Excel 2019, 2016, 2013, and 2010, as well as in Excel in Microsoft 365. It just needs to be enabled to take full advantage of its functionality. Microsoft has instructions on how to do this here. And you can find information on PowerPivot in different versions of Office here.

Once you have Power Pivot, it can be used to do an almost limitless number of incredibly useful tasks. PowerPivot is also part of Infero’s new Data Analysis and Visualisation with Microsoft Excel Course. Contact us to learn more about it.

What is Get & Transform (Power Query) in Excel?

Get & Transform (formerly known as Power Query) is perhaps the biggest hidden secret in Excel and the tool that can save you hours and hours of boring and repetitive work. To analyse data in Excel, in many cases you must first import it. This can be done manually or use VBA, but manually importing data into Excel is slow, tedious and error-prone and VBA requires some programming knowledge.

Get & Transform allows the automation of the process of importing data, but it requires no coding knowledge and tends to result in better performance. But it doesn’t only import data; Excel Get & Transform is an advanced ETL tool.  ETL is an acronym for Extract, Transform and Load.

It allows you to:

  • Extract: Most data that is analysed in Excel is imported from an external data source. Extract means moving this data from the external data source into the Get & Transform tool. This can include Excel files, Text or CSV files, Databases such as Microsoft SQL Server, Microsoft Access and Microsoft Exchange, Facebook and even web pages.
  • Transform: Extracted data often is often in a form that isn’t easily analysed. There may be unwanted columns, bad formatting or corrupted data. Get & Transform has a vast array of features that enable you to clean your data before loading to Excel table. The extracted data can be transformed in almost unlimited ways:
    • Removing columns
    • Filtering the data
    • Grouping the data,
    • Pivoting/unpivoting the data
    • Splitting up text
    • Extracting keywords from text
    • Add rows from another table
    • Remove Duplicate Records
    • Split a Column the Number of Chars
    • Duplicate Columns
    • Use First Row as Headers
    • Remove Columns
    • Remove Duplicates
    • Fill Down Values
    • Create Index Columns
    • Remove Rows With Errors
    • Group Rows and Get Counts
    • Reverse Rows
    • Transpose
    • Replace Values
    • Split First & Last Name
    • Consolidate Excel Workbooks or Worksheets
    • Load: The transformed data from the Get & Transform tool is loaded into an Excel table or into an Excel Pivot Table, where it can be analysed and shared.

    Whatever you have done, the whole transformation of the data process can then be saved as a Query. Perhaps the greatest and most time-saving feature of Get & Transform is that it allows you to set up a query once and then reuse it with a simple refresh. Get & Transform is very easy to use and pick up, more so than other Excel tools like formulas or VBA. And no coding knowledge is required. Get & Transform records all your transformations step by step. You can even go back and amend any of the steps individually.

    Get & Transform is part of Infero’s new Data Analysis and Visualisation with Microsoft Excel Course. Contact us to learn more about it. The applications for your own work in Excel could be endless.

    National Picnic Month

    As July is National Picnic Month, it encourages you to get out and about  and celebrate the warm summer days outdoors while enjoying some great food.

    Throughout the history of civilization, there has always been something special about leaving  your home and eating a meal outdoors. We know there’s a beautiful world out there waiting for us to come and visit it, and when summer comes around, we all can’t wait to go out  and spend time outside.

    Picnics have been used for many things throughout the centuries, from a simple family gathering spent enjoying the outdoors, to a peaceful protest in the  famous Pan-European Picnic, which was a peace demonstration held on the Austrian-Hungarian border near Sopron, Hungary on 19 August 1989.

    Picnic Month celebrates the history of this activity and the way it has been used to bring families, countries, and all humanity together.

    Picnic month is exceptionally easy to celebrate! All you need to do is just  to get outside and enjoy all the wonderful sights together with delicious food, which tastes much better outdoors.

    Get your family and friends together at a nearby park and bring your favourite foods that can be eaten cold for a traditional picnic or bring a small grill and cook some delicious food on the spot.

    Get the Children Involved

    As summer arrives, a lot of parents may feel a little uneasy and not sure  how to keep their kids entertained.

    A picnic is a perfectly easy, and  no fuss  activity to add some excitement  to the long summer days.

    Whether you are a parent, carer or teacher, picnics are an ideal opportunity for learning and development. Simple tasks, such as buttering a slice of bread, or wrapping food and cutting up food can benefit children and contribute to their growth and further their skills

    Positive Impact on Mental Health and Wellbeing

    Science proved that nature and spending time outside has a positive effect on mental health and wellbeing. Nature has a calming influence and provides a longing and much-needed escape from the everyday pressures. 

    Planning a picnic and having something to look forward to also has a fantastic impact on mental health. The social interaction which is a part of picnics has also a positive influence on mental health and wellbeing as humans tend to  thrive on positive, real communications with others.

    In 2021, picnics are still a much-loved and popular pastime which provide a welcome relief from the everyday routine.

    Microsoft Excel: Dashboards Course

    Excel dashboards are one-page (or rather one worksheet) summaries that contains important information which allows managers to track key KPIs, metrics and other data points in one visual, central place. They may be used in almost any industry, for almost any purpose. It is possible to have a Dashboard to track finances, for marketing or to show the progress of a key project.

    Dashboards are made up of tables, charts, gauges and other visualisations. Able to display a high-level view of an organisation, a good dashboard will aid in making business decisions and can also provide a portal to keep everyone up to date, giving a real time view of current status or performance.

    If you want to be able to extract useful, actionable organisational information from your raw data, and present it in a visually compelling format that will enable key trends to be seen and decisions to be made, then Infero Training’s Microsoft Excel: Dashboards Course will help you do this. 

    Creating an Excel Dashboard is a multi-step process and our course takes you through all of these in an easy-to-follow manner. As well as all of the technical aspects, the course covers the key things you need to keep in mind when creating a dashboard and how you need to be clear about the objectives of the dashboard, before you even start using Excel.

    The course also looks at simple Excel dashboard design rules, such as the simple use of colours, easily read, clean design and other considerations.

    Excel Dashboard design should be:

    • Understandable with no confusion over what each of the metrics mean.
    • Interactive so that the Dashboard can be changed for different areas of an organisation, or to answer different questions.
    • Clearly labelled, with all of the charts and tables on the dashboard displaying a clear message.
    • Organised into a symmetrical grid that aligns sections into blocks of data.

    Course Content

    Lesson 1: Data Analysis Fundamentals

    Topic A: Introduction to Data Science

    Topic B: Create and Modify Tables

    Topic C: Sort and Filter Data

    Lesson 2: Visualizing Data with Excel

    Topic A: Visualize Data with Charts

    Topic B: Modify and Format Charts

    Lesson 3: Analysing Data with Formulas and Functions

    Topic A: Analyse Data with Formulas and Named Ranges

    Topic B: Analyse Data with Functions

    Lesson 4: Analysing Data with PivotTables

    Topic A: Create a PivotTable

    Topic B: Analyse PivotTable Data

    Lesson 5: Presenting Visual Insights with Dashboards in Excel

    Topic A: Visualize Data with PivotCharts

    Topic B: Filter Data Using Slicers and Timelines

    Topic C: Create a Dashboard in Excel

    To learn more about this course, contact us today.