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

Training Doyens posted events
yesterday
Adam Fleaming posted a blog post

Having a [baby] is exorbitant and befuddling, notwithstanding for a wellbeing approach master

It is hard to believe that it has been just over since five months since our second son, Lukas, was born on Feb. 3. His mother, Hollyanne, is doing well, which is something to be thankful for, given the excessive maternal mortality rates in the U.S. Lukas is also healthy and growing, albeit sleeping little at night. What is unbelievable…See More
Thursday
Tytti posted a blog post

Safety Sign Colors and International Standards

Colors make a difference to our environment. They help us analyze the surroundings and distinguish between objects. We recognize plants as green and the sky as blue, whereas a frog, for example, can be either green or blue. Deviant colors, in this case blue, warns us about poisonousness. If we detect unusual colors in our food, for example, we associate them with rottenness, which then activates a warning in our mind “Don’t eat!” Colors cause diverse feelings and opinions, and even distinct…See More
Thursday
Mark Nilson posted events
Thursday

Forum

5 TECHNOLOGY-BASED LONE WORKER SAFETY SOLUTIONS

ABOUT 75% OF EMPLOYEES IN NORTH AMERICA ARE MOBILE WORKERS. ADVANCES IN COMMUNICATIONS TECHNOLOGY MEANS THESE WORKERS CAN WORK ANYWHERE AT ANY TIME. THESE NEW TECHNOLOGIES ALSO MEAN THESE MOBILE…Continue

Tags: Solutions, People, IoT, Monitoring, Remote

Started by Jen McDade May 31.

Road Safety Solutions 14 Replies

The Road Safety Signs ,Barriers,Humps,Hazard Markers and Visual Warnings are some of the important marks to be observed. Signs such as "keep left",stop, "give way" should not be casually treated.…Continue

Tags: safety, gear, wear, Equipment, &

Started by Enna Henry. Last reply by Jen McDade May 31.

Remote Monitoring

Get "Safe Assets and Sound Productivity" Through Remote Monitoring.Visit:…Continue

Tags: Solutions, People, IoT, Monitoring, Remote

Started by Jen McDade May 23.

Python Condition Objects Tutorial in 2018 1 Reply

If you have knowledge of other programming languages, then you would know the importance of conditional statements. Conditional statements are required for taking decisions. Whenever we operate the…Continue

Tags: course, certification, training, languages, programming

Started by Elena Lauren. Last reply by Jim Chesters May 15.

Power BI Visualization Types

Visualizations in Power BI displays the visual insights from a data. In power bi service a visual can be pinned from reports to create dashboards. Visuals are used in reports.List of visualizations…Continue

Tags: COURSE, TRAINING, BI, POWER

Started by Azharuddin May 15.

Badge

Loading…

© 2018   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service