Description
Overview
Join this webinar to learn how to set up data in correct format and to use key features to best manage and present your data.
Tables are a powerful Excel functionality to streamline many data management functions.
Think of a table as a defined set of rows and columns in a spreadsheet.
You can have multiple tables on the same sheet.
You might think that your data in an Excel spreadsheet is already in a table simply because it’s in rows and columns. However, your data isn’t in a true “table” unless you’ve used the specific Excel data table feature.
If PivotTables, and functions like VLOOKUP, SUMIF, etc. have challenged you with errors, then you may need to correct your data structure and format.
Why should you attend ?
- Work smarter, faster and more effectively
- Boost profit, efficiency, and productivity
- Improve job satisfaction, team performance, and professionalism
- Gain strong competitive advantage at peer and business level
- Achieve more in less time with higher quality results.
- Strengthen your resume and case for increased salary
- Understand the latest and most relevant MS Office functions available
Areas Covered in the Session
- Setup data correctly and effectively
- Sort data by columns
- Sort data by row
- Custom filter for text, numbers, and dates
- Save a filter for re-use
- Subtotal data
- Learn the benefits of tables
- Create and modify tables
- Learn how tables are named and why
- Add and delete data in a table
- Use tables to filter multiple lists on a worksheet
- Calculate filtered data in a table
- Keyboard shortcuts – Excel, general & web browser
- NOTE: Topic sequence may be subject to slight variation
Who will benefit
- Private
- Public and Academic Sector Staff
- Managers & Executives or
- Anyone seeking to maximize their investment in Microsoft Office Applications.
- Account Executive
- Accountant
- Auditor
- Bookkeeper
- Business Owner
- Chief Executive
- Controller
- CPA
- Cybersecurity staff
- Database Administrator (DBA)
- Educator
- Trainer
- Engineer
- Financial Analyst
- Human Resource Personnel
- IT Professional
- Manager
- Marketer
- New recruit
- Project Manager
- Social Media Specialist
- Staff at all levels
- Supervisor
Instructor Profile
Ray Evans, professional and relaxed style reflects his thorough understanding of adult learning principles and is demonstrated through his diverse range of classroom, seminar, workshop and online delivery services and instructional materials.
With Microsoft Certifications in Excel and Word, he has mastered over 2500 topics to advanced level in Microsoft Excel, Access, Outlook, Project, PowerPoint, Word, Visio, and Publisher.
Ray has qualifications in Frontline Management, Accounting, Training, and Assessment and is certified in Six Sigma business improvement methodology.
