Online Safety Community

Excel - Managing Lists and Databases

Event Details

Excel - Managing Lists and Databases

Time: February 21, 2018 from 1pm to 2:30pm
Location: Training Doyens 26468 E Walker Dr
City/Town: Aurora
Website or Map: http://bit.ly/2EV7Bc8
Phone: +1-720-996-1616
Event Type: webinar, :, banking, and, financial, service
Organized By: Training Doyens
Latest Activity: Jan 19

Export to Outlook or iCal (.ics)

Event Description

OVERVIEW

If you think that Excel is all about working with numbers then think again. More and more people are turning to Excel to help them to manage list-based and tabular data.

In many cases they receive, download or import data from elsewhere and before that data can be used within their business and treated as a credible source of information, it needs to be seriously checked and cleaned - duplicate entries, non-printing characters, extra spaces and capitalization inconsistencies are all-too-often present in downloaded and imported data. In this session, you'll learn how to deal with and fix all these issues.

WHY SHOULD YOU ATTEND

If you import, download or simply manage list-based or tabular-based data in Excel and you want to learn some best practice techniques for working with this type of data, this advanced excel training is for you.

AREAS COVERED

  • Sorting a column or row of items into order
  • Sorting a list of date-based items into order
  • Filtering a list to display only certain items
  • Saving a filter for re-use
  • The benefits of Tables
  • Summarizing a list with Pivot Tables and Subtotals
  • Cleaning up imported/downloaded data
  • Importing and linking to non-Excel data

LEARNING OBJECTIVES

In this session, you'll learn about managing list and tabular based data in terms of sorting (into different orders), applying and saving filters (that let you display only certain items) and summarizing with Pivot Tables.

WHO WILL BENEFIT

There's nothing particularly advanced about the features covered in this session so even if all you've ever done is opened an existing Excel workbook and looked at the data, if you want to know how to manage lists in Excel, then this webinar is for you.

The training will be delivered using Excel 2016 for Windows although much of the functionality is available in earlier versions of Excel

SPEAKER

Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012, he founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a variety of Excel topics.

Mr. Thomas is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.

For more details of this webinar click on this link:

 http://bit.ly/2EV7Bc8

 

You may also refer to these related links also :

 https://www.trainingdoyens.com/product/50007-best-way-to-learn-excel-quickly

https://www.trainingdoyens.com/product/50011-webinar-in-effective-auditing-observations

https://www.trainingdoyens.com/product/50070-enterprise-risk-management-framework

 

Comment Wall

Comment

RSVP for Excel - Managing Lists and Databases to add comments!

Join Online Safety Community

Attending (1)

Take our poll!

Take our poll!

Latest Activity

nicolewells posted a discussion

Security Storage SAN Performance

Hello All,Have a question regarding SAN performance specifically EMC VNX SAN. I have a significant number of processes spread over number of blade servers running concurrently. The number of processes is typically around 200. Each process loads 2 small files from storage, one 3KB one 30KB. There are millions (20) of files to be processed. The processes are running on Windows Server on VMWare. The way this was originally…See More
8 hours ago
Rebecca Lewis posted a discussion

What safety signs should I acquire for my shop’s construction?

Hello everyone! The construction of my new flower shop will start next month, and it’s a big project for me. Since the shop’s location is near the main road, I want to make sure that everyone is safe during the work. I can’t afford any accident like people getting injured. So I’m thinking of purchasing construction health and safety signs from a supplier that my friend recommended.…See More
yesterday
Rebecca Lewis joined Safety Community's group
Thumbnail

Construction

For those working in Carpentry, Drywall, Electric, General Labor, HVAC, Landscaping, Masonry and Plumbing.
yesterday
Adam Fleaming posted a blog post

FMEA in medical devices can work better when mated with ISO 14971

Failure Mode and Effects Analysis (FMEA) is a core aspect of risk management and risk analysis in medical devices. FMEA is essentially about analyzing the reasons for which a problem arises and the effects it has on the system. In the field of medical devices, it is absolutely critical to understand the failure mode and effects because the consequences of not doing this can be disastrous and many times, even…See More
yesterday

Forum

Security Storage SAN Performance

Hello All,Have a question regarding SAN performance specifically EMC VNX SAN. I have a significant number of processes…Continue

Tags: san, vmware, emc

Started by nicolewells 8 hours ago.

What safety signs should I acquire for my shop’s construction?

Hello everyone! The construction of my new flower shop will start next month, and it’s a big project for me. Since the shop’s location is near the main road, I want to make sure that everyone is safe…Continue

Started by Rebecca Lewis yesterday.

Gig Economy

The career world has rapidly changed and these days, long-term careers and people working in just one job are slowly but steadily becoming a thing of the past. In fact, according to research, in the…Continue

Tags: field, engineer, IT, freelance, economy

Started by Mohd Azher on Wednesday.

How to Repair MySQL InnoDB Table That Has Issues?

When trying to run: delete IdentityRequest *I get an error of sailpoint.tools.GeneralException: null index column for collection: sailpoint.object.IdentityRequest.itemsDoing a select * from…Continue

Tags: course, sailpointonline, sailpoint

Started by Soujanya Naganuri on Tuesday.

Occupational Health and Safety 7 Replies

Health and safety are important aspects of an organisation’s smooth and effective functioning.  Did you know that workplace health & safety injuries cost Australian businesses over $60 billion…Continue

Tags: Safety, and, Health, Occupational

Started by WHS Solutions. Last reply by Tony Ferraro on Sunday.

Badge

Loading…

© 2018   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service