Tips and Tools for Managing Excel Lists and Databases

OVERVIEW

Learning functions and formulas is only the beginning of becoming an Excel expert. Knowing the art of data management is an important part of using Excel to its full potential. This includes everything from understanding how to set up worksheets to managing data entry and maintaining good maintenance practices. 

With this webinar, you will learn how to manage databases in Excel. Discover the tools that will make large amounts of data appear more manageable and easier to sort through and analyze. Understand which functions work best with large tables and how to use simple macros to automate repetitive tasks. Become a master of working with databases in Excel.

WHY SHOULD YOU ATTEND?

Microsoft Excel has become the de facto spreadsheet application for business. But do you ever feel like you're drowning in data and can't make heads or tails of it? This class will help you learn how to manage databases in Excel, and get the most out of them.

For 90-minutes, Excel expert Cathy Horwitz will lead you through a full array of powerful and easy-to-use database commands and methods critical to effectively working with Excel databases. In this webinar, you will learn how to improve your Excel database skills so that you can better summarize info-making better, more-informed business decisions.

LEARNING OBJECTIVES

You’ll learn how to cleverly use standard Excel functions that could save you hours through to days of manual work.

• Easy-to-use methods to build and manage your database
• Import a database from outside of Excel
• Techniques to sort and filter data in order to identify business trends
• Tips and tricks to validate your data and guarantee accuracy
• Turn the database into a PivotTable to analyse the data

AREAS COVERED

• Creating a Database in Excel
• Setting up a database or list in Excel, Navigating your database, and Data Validation.
• Data import and clean-up tools
• Sorting, Multi-level sorting, Auto-Filter, Advanced Filters.
• Summarizing Data – Subtotal Lists, Using Functions to summarize data.
• Using Data Analysis – Pivot Tables

WHO WILL BENEFIT?

Anyone in companies that use computer systems - 

• Business Owners, 
• CEO's / CFO's / CTO's
• Managers, Accountants, CPA's
• Cost Accountants / Managerial Accountants
• IT Professionals, Auditors
• Human Resource Personnel
• Bookkeepers, Marketers
• Mergers & Acquisitions Specialists 
• Controllers, Investment Analysts
• Financial Consultants, Financial Analysts
• Risk Managers, Strategic Planners
• Business Analysts, Forecasting & Planning Personnel
• Capital Expenditure Planners
• Anybody with large amounts of data
• Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive