Menu
×
×

Sign Up

Your Profile will be reviewed by Admin
TODAY :
EVENT DATE
Dec 2016
MoTuWeThFrSaSu
   1234
567891011
12131415161718
19202122232425
262728293031 

Venue

Google Map

Excel - Managing Lists and Databases

Online Event
0 0

Overview

Overview:

If you think that Excel is all about working with numbers then think again. More and more people are turning to Excel managing lists & databases, 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 be seriously checked and cleaned - duplicate entries, non-printing characters, extra spaces and capitalisation inconsistencies are all-too-often present in downloaded and imported data. In this Excel training webinar, you'll learn how to deal with and fix all these issues.

Why Should You Attend:

You'll also 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 summarising with Excel Pivot Tables.

Areas Covered in this Webinar:

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

Learning Objectives:

The benefits of Tables
Summarising a list with Pivot Tables and Excel SubTotal Reports
Cleaning up imported/ downloaded data
Advanced Excel features like importing and linking to non-Excel data
Manage lists in Excel
Excel sorting and filtering

Who Will Benefit:

CFO/Controllers
Investment Analysts / Financial Analysts / Business Analysts
Forecasting & Planning Personnel
Mergers & Acquisitions Specialists
Risk Managers
Strategic Planners / Capital Expenditure Planners
Cost Accountants / Managerial Accountants
Any User of Excel who wants to learn how to create form-driven applications and spreadsheets

Speaker Profile:

Mike Thomas has worked in the IT training business since 1989. His expertise and experience covers creating and delivering training courses, writing training materials and recording and editing video-based tutorials.

He is a subject matter expert in a range of Microsoft technologies and has also worked extensively with Mac OSX and Mac-related software since 2006, however, his passion is for all-things-Excel.

For more detail please click on this below link:

http://bit.ly/2frACAt

Email: referrals@complianceglobal.us
Toll Free: +1-844-746-4244
Tel: +1-516-900-5515

Fax: +1-516-900-5510

RELATED EVENTS +

MORE events +

Display Makers +