This 60-minute seminar will discuss all aspects of filtering from the basics to advanced filtering, as well as the new dynamic array FILTER function. It will also discuss all aspects of Sorting, from the basics to advanced Sorting techniques, as well as the new dynamic array SORT and SORTBY functions.
Course Objectives:
To give the user the ability to use the sorting and filtering features thoroughly.
Course Outline:
Using Microsoft Excel, we will go through the basics of filtering data and what that means. We will look at features not covered by the filter command, by using the advanced filter feature which we cover in detail. Then we will look at the FILTER builtin function and its various features. We will similarly go through the SORT feature, as well as the SORT builtin function.
What You Get:
• Training Materials
• Live Q&A Session with our Expert
• Participation Certificate
• Access to Signup Community (Optional)
• Reward Points
Who Will Benefit:
• Business Owners
• CEO's / CFO's / CTO's
• Managers
• Accountants
• CPA's
• Financial Consultants
• IT Professionals
• Auditors
• Human Resource Personnel
• Bookkeepers
• Marketers
• Anybody with large amounts of Data
• Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive
Filtering Techniques for Microsoft Excel Data
Get Instant Access 90 Minutes View Program |
Managing Excel Data Through the Use of Sorting, Filtering, Subtotaling and Using Conditional Formats
Get Instant Access 90 Minutes View Program |
Lookup Function Essentials in Microsoft Excel
Get Instant Access 60 Minutes View Program |
Mastering Microsoft Excel® Macros and VBA
Get Instant Access 60 Minutes View Program |
2 Hours Virtual Seminar on Microsoft Excel Functions
Get Instant Access 120 Minutes View Program |
Get Instant Access On-Demand Access
Preparing for the ICE Storm: What to Do During I 9 Audits and ICE Raids
Janette S. Levey
Human Resources
Get Instant Access On-Demand Access
OSHA Inspections and Investigations-How to Manage Them
Irwin Dobrushin
Environment Health and Safety | OSHA
Get Instant Access On-Demand Access
29 CFR 1904: OSHA's New Injury Recordkeeping E-Submission Rule
Occupational Safety and Health Administration
Get Instant Access On-Demand Access
Working with Excel Databases: Sort, Filter, Subtotal and More
Cathy Horwitz
Cross Industry | Skill Enhancement
Get Instant Access On-Demand Access
Writing Audit Reports
Jonnie T. Keith CIA, CFE, CGAP, CICA
Governance, Risk and Compliance
Get Instant Access On-Demand Access
BSA Reporting Requirements
Banking and Financial Services Industry
Get Instant Access On-Demand Access
Human Factors-Usability Based on ISO 62366
Medical Device | Diagnostic | Pharmaceutical | Biologics fields
Get Instant Access On-Demand Access
Chat GPT for Project Managers
Charles H. Paul
All FDA Regulated Industry