Making Your Excel Spreadsheet Much Easier to Use with Tables
Roman’s 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. He also recently added Office 365, SharePoint Online, OneDrive, Outlook Web Application, and Office Online to his online courses portfolio. Roman has qualifications in Frontline Management, Accounting, Training, and Assessment and is certified in Six Sigma business improvement methodology.
Having trained over 15,000 students and authored a wide range of complex reports, training, and procedural documentation, Roman has demonstrated a strong ability in written communication, change management, and knowledge transfer.
A table is a powerful feature to group your data together in Excel. Think of a table as a specific 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.
- Set up a usable database
- 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
Course Level - Intermediate
Who Should Attend
- Business Owners
- Financial Consultants
- IT Professionals
- Human Resource Personnel
- Anybody with large amounts of data
- Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive
Why Should You Attend
Have you struggled to use PivotTables, and functions like VLOOKUP, SUMIF, etc.? The struggle is for one reason; your data is in the wrong format. Join this webinar to learn how to set up data in the perfect format and to learn tools to best utilize that data.