Events
Organizers
Venues
Add Event
Subscribe
Subscribe
Sign In
Hotels
Car Rental
Tours & Transport
Event Tickets
Practical Excel – Effectively Handling Duplicate Data 2018
16 Nov 2018
Webinar
Home
Practical Excel – Effectively Handling Duplicate Data 2018
Description
Topics
Creating an in-cell list by way of Excel’s Data Validation feature
Learning the mouse trick that lets you quickly make a copy of an existing worksheet
Seeing how to quickly duplicate a group of two or more worksheets
Identifying duplicates in a list using Conditional Formatting
Using Conditional Formatting to color-code your data, identify duplicates, and apply icons
Using the COUNTIF function to determine the number of times an item appears on a list
Using the SUMIFS function to sum values based on multiple criteria
Understanding why numeric data may appear in a pivot table more than once and how to correct the problem
Filtering list entries based on colors that you apply manually or with Conditional Formatting
Using the Reapply command to refresh a list as you correct duplicates
Using a wildcard character with SUMIF to summarize data based on a partial match
Improving the integrity of spreadsheets with Excel’s VLOOKUP function
Who should Attend
CPA’s
Accountants
Controllers
CFO’s
Income Tax Preparers
Excel Users
Financial Consultants
Enrolled Agents
Auditors
IT Professionals
Bookkeepers
Human Resource Personnel
Government Personnel
Marketers
Every Practitioner who wish to learn how to create error-free Excel spreadsheets
Past Events
Practical Excel – Effectively Handling Duplicate Data 2018 - 16 Nov 2018, Webinar
(79686)
Important
Please, check "Practical Excel – Effectively Handling Duplicate Data" official website for possible changes, before making any traveling arrangements
Event Categories
Business:
Finance, Human Resources (HR), Marketing & Sales
Education:
Training
Technology:
Software & Applications
Other Events with Similar Categories
Business Conferences
Education Conferences
Technology Conferences
Marketing & Sales Conferences
Human Resources (HR) Conferences
Training Conferences
Finance Conferences
Software & Applications Conferences
Mathematics Education Conferences
Philosophy of Education Conferences
Teacher Conferences
Learn Conferences
Coach Conferences
Business Ethics Conferences
Education Reforms Conferences
Educational Conferences
Media Education Conferences
Novel Technologies Conferences
School Organization Conferences
Business Intelligence Conferences
Education Research Conferences
Gifted Education Conferences
Inclusive Education Conferences
Media Education Research Conferences
Moral Education Conferences
Special Education Conferences
Entrepreneurship Conferences
Healthcare Education Conferences
International Business Conferences
Science and Technology Conferences
Adult Education Conferences
Business Engineering Conferences
Creative Education Conferences
Education Systems Conferences
History of Education Conferences
Pedagogy Conferences
Branding Conferences
Public Relations Conferences
Affiliate Management Conferences
PR Conferences
Public Affairs Conferences
Advertising Conferences
Corporate Learning Conferences
Signage Design Conferences
Hr Conferences
Human Resources Conferences
Workforce Management Conferences
Sell Conferences
Personnel Conferences
Signage Conferences
Team Building Activities Conferences
Workforce Conferences
Employee Engagement Conferences
Staff Conferences
Career Conferences
Teams Conferences
Occupational Stress Conferences
Employee Conferences
Teaching Conferences
Careers Conferences
Coaching Conferences
Hiring Conferences
Instruction Conferences
Hire Conferences
Guidance Conferences
Bank Conferences
Learning Conferences
Money Conferences
Financial Conferences
Accounts Conferences
Investment Conferences
Credit Conferences
Assets Conferences
Debit Conferences
Money Market Conferences
Fund Conferences
Accounting Conferences
Stock Conferences
Payment Conferences
Hedge Conferences
Stock Market Conferences
Monetary Conferences
Hedge Fund Conferences
Cash Conferences
Funds Conferences
Merger Conferences
Mergers Conferences
Acquisition Conferences
Mergers and Acquisitions Conferences
Capital Conferences
Pricing Conferences
Price Conferences
Forex Conferences
Profit Conferences
Profitability Conferences
Sap Conferences
Billing Conferences
Oracle Conferences
Revenue Conferences
Sales Enablement Conferences
Incentives Conferences
Fintech Conferences
Software Conferences
Applications Conferences
Apps Conferences
Saas Conferences
Instructional Conferences
Capital Markets Conferences
Employee Happiness Conferences
Financial Engineering Conferences
Formal Methods Conferences
Management Accounting Conferences
Other Events with Similar Location or Organizer
Virtual (Online) Events
Events by Webinar Compliance
Featured Conferences & Exhibitions
AI World Congress 2024
Biotechnology for the Non-Biotechnologist
International Conference of Leadership Business and Managment (ICLBM)
International Conference on Trends and Innovations in Management, Engineering, Sciences and Humanities (ICTIMESH 2024)
International Crop Science Conference & Exhibition
74th New Orleans Academy of Ophthalmology (NOAO) Annual Symposium 2025
ConveyUX
INTED2025 - The 19th International Technology, Education and Development Conference
EnviroTech Athens 2025
35th Annual Art and Science of Health Promotion Conference
The Learning Ideas Conference 2025
Primary Care Hawaii Conference - Caring for the Active and Athletic Patient
Articles / News / Press releases
Anticorruption thematic in the fourth Nigerian republic and public finance management
The Hybrid Work Model
Imparting information and education through education conferences
Technology conferences - a useful tool
Aspects of business development through a business conference or exhibition
Business conference and trade shows as an efficient tool
Search for Events
Search
Clear