If you manage databases using Excel, you will want to attend this course. We will walk you through the steps of working with multiple workbooks and merging them into one easily managed database. If you accumulate databases on a regular basis from your sales team, research or events, you will most likely want to update your master database with information and need to for analysis.

The full-day course will provide you with the knowledge to start using Excel to manage your information more effectively while saving you hours of frustration through learning the most common functions of Excel.

Who should attend?

Marketing, Sales, HR, Accounting - team members who regularly use Excel to manage databases.

Key objectives

• Function usage
• Save time by knowing what Excel can do for you
• Learn some of the ‘advanced’ functionality of Excel, but know that it is not always difficult to manage
• Use Pivot Tables and Charts to summarize and analyse data quickly and efficiently
• Be more confident in using Excel and know things can always be more efficiently done

Outline

• Excel Efficiency and Shortcuts – speed up your operation
• Finding and replacing data
• Auto-fill
• Checking errors with formulas and functions
• Naming cells and naming ranges
• Using names and ‘named’ ranged in calculations
• Formulas and Functions
• Creating
• Editing
• Copying relative and absolute references
• COUNT/MAX/MIN/AVERAGE
• The IF Function
• Errors
• Working with Text
• Text to Columns
• Text manipulation and functions (MID, Left, Right, Len, Trim, Concatenate, Upper, Lower, Proper, etc)
• The Data Menu
• Using filters for large lists
• Sorting Lists
• Group Data
• Advanced Features
• Setting up criteria ranges for filtering
• Lookup functions - V and H
• Tables and Charts
• Simple Tables and Charts
• Pivot Tables and Charts