IIMD IRISH INSTITUTE FOR MANAGEMENT DEVELOPMENT
  • HOME
    • About IIMD Business School
  • Business
    • Code of Conduct
    • Customer Loyalty
    • Building a Successful Team
    • Business Ethics
    • Business Etiquette and Professionalism
    • Coaching Performance
    • Communicating Organizational Change
    • Conducting Feedback
    • Data Warehousing
    • Day-to-Day Leading
    • Defining Leadership
    • Effective Meetings
    • Email Essentials
    • Employee Engagement
    • Finding Work-Life Balance
    • Leadership Communication
    • Leading an Organization
    • Leveraging Technology
    • Management Essentials
    • Managing Change
    • Managers And Leaders
    • Memory Improvement
    • Powerful Presentations
    • The Procedures of Successful Managers
    • Setting Organizational Goals
    • Strategic Brand Management
    • Strategic Sales for Account Managers
    • Quality Awareness
  • Personal
    • Administrative Assistant
    • The Art of Team Building
    • Project Management
    • Time Management
    • Retail Management
    • The Art of Negotiation
    • Interpersonal Communication
    • Public Speaking
    • Conflict Management
    • The Art of Motivation
    • Business Plan Writing
    • Operating a Business
    • Small Business Management
    • Sales Management
    • Customer Service
    • Marketing Principles
    • Marketing Strategies
    • HR Management
    • Strategic Staffing
  • Computer
    • Microsoft Office 2016 >
      • Microsoft Excel 2016 Introduction
      • Microsoft Excel 2016 Advanced
      • Microsoft Word 2016 Introduction
      • Microsoft Word 2016 Advanced
      • Microsoft PowerPoint 2016 Introduction
      • Microsoft PowerPoint 2016 Advanced
      • Microsoft Outlook 2016 Introduction
      • Microsoft Outlook 2016 Advanced
      • Microsoft Project 2016 Introduction
      • Microsoft Project 2016 Advanced
      • Microsoft Visio 2016 Introduction
      • Microsoft Visio 2016 Advanced
    • Microsoft Office 2013 >
      • Microsoft Excel 2013 Introduction
      • Microsoft Excel 2013 Advanced
      • Microsoft Word 2013 Introduction
      • Microsoft Word 2013 Advanced
      • Microsoft PowerPoint 2013 Introduction
      • Microsoft PowerPoint 2013 Advanced
      • Microsoft Outlook 2013 Introduction >
        • Microsoft Outlook 2013 Advanced
      • Microsoft Access 2013 Introduction >
        • Microsoft Access 2013 Advanced
      • Microsoft Project 2013 Introduction >
        • Microsoft Project 2013 Advanced
      • Microsoft Visio 2013 Introduction >
        • Microsoft Visio 2013 Advanced
    • Microsoft Office 2010 >
      • Microsoft Excel 2010 Introduction
      • Microsoft Excel 2010 New Features
      • Microsoft Excel 2010 Advanced
      • Microsoft Word 2010 Introduction
      • Microsoft Word 2010 New Features
      • Microsoft Word 2010 Advanced
      • Microsoft PowerPoint 2010 Introduction
      • Microsoft PowerPoint 2010 New Features
      • Microsoft PowerPoint 2010 Advanced
      • Microsoft Outlook 2010 Introduction
      • Microsoft Outlook 2010 New Features
      • Microsoft Outlook 2010 Advanced
      • Microsoft Access 2010 Introduction
      • Microsoft Access 2010 New Features
      • Microsoft Access 2010 Advanced
    • Adobe Creative Cloud >
      • Adobe CC Introduction
      • Photoshop CC Introduction
      • Photoshop CC Advanced
      • Illustrator CC Introduction
      • Illustrator CC Advanced
      • InDesign CC Introduction
      • InDesign CC Advanced
      • Dreamweaver CC Introduction
  • Banking
    • Corporate Governance
    • Risk Management: Identifying Risks
    • Cash Management
    • Investments
    • Treasury Risk Management
    • Treasury Department Fundamentals
    • Signature Verification and Forgery
  • Blog
  • Contact
  • Login

Microsoft Excel 2016 Advanced 

Microsoft Excel is the go-to software for data management. By making the user more effective and efficient, Excel sets the standard for spreadsheet software. 

In our Microsoft Excel 2016 Advanced course, you will learn data management and advanced techniques of working with data. 

This course will help you to take the complexity out of formulas by learning to work with power functions, analyze data to make better business decisions by learning to use pivot tables, sort and filter data while identifying trends with advanced data management features, and save time and work more efficiently by utilizing macros. 

​
Enhance your data management strategy while improving success and effectiveness with our course in Microsoft Excel 2016 Advanced. ​
Picture
Microsoft Excel 2016 Advanced Course
BUY NOW €49+ VAT @23%(€61) - ACCESS FOR 365 DAYS
Course Outline 
1. Working with Functions
  • Overview
  • Using Statistical Functions
  • Calculating Loan Payments
  • Calculating Present Value
  • Calculating Loan Payoff
  • Calculating Interest Rate
  • Calculating Principle & Interest
  • Work with Logical Functions
  • Work with Text Functions
  • Work with Ranges
  • Using Date and Time Functions
  • Controlling Automatic Calculations 
  • Copying Formula Values
2. IF, VLOOKUP, and Power Functions
  • Overview
  • Testing Conditions with IF
  • Using IF functions with relational operators
  • Using the IFS function
  • Using VLOOKUP
  • Getting approximate table data with VLOOKUP
  • Getting exact table data with VLOOKUP
  • Using INDEX/MATCH functions
  • Using the COUNTIF family of functions
3. Data Analysis Tools
  • Overview
  • Using Goal Seek
  • Using Solver
  • Using Scenario Manager
  • Using data tables
​

4. Data Management Features
  • Overview
  • Sorting data
  • Using filters
  • Splitting data into multiple columns
  • Using Flash Fill
  • Removing duplicate records
  • Using validation tools


5. Working with Lists
  • Overview
  • Query Data with Database Functions
  • Outline and Subtotal Data
  6. ​Pivot Tables
  • Overview
  • Creating PivotTables
  • Manipulating PivotTable data
  • Grouping by date and time
  • Grouping by other factors
  • Using slicers to clarify and manipulate fields
  • Using Pivot Charts

7. Introduction to Macros
  • Overview
  • Understanding and creating Macros
  • Running and editing a macro

8. Security and Sharing
  • Overview
  • Unlocking cells and protecting worksheets
  • Protecting workbooks
  • Assigning passwords to workbooks
  • Sharing workbooks
  • Tracking changes
Conclusion
JOIN NOW FOR IMMEDIATE ACCESS FOR €49+VAT@23%(€61)

Course Certification
Picture
​We award every participant who successfully completes our course final exam a Certificate of Completion, acknowledging their participation and completion in one of our courses.
 After completely viewing the course, a Certification Test becomes available to ensure the user’s proficiency in the subject. To successfully complete the test you must score 80% or higher (we allow multiple attempts). Once successfully completed you may save or print your certificate at no extra cost.

Powered by Create your own unique website with customizable templates.
  • HOME
    • About IIMD Business School
  • Business
    • Code of Conduct
    • Customer Loyalty
    • Building a Successful Team
    • Business Ethics
    • Business Etiquette and Professionalism
    • Coaching Performance
    • Communicating Organizational Change
    • Conducting Feedback
    • Data Warehousing
    • Day-to-Day Leading
    • Defining Leadership
    • Effective Meetings
    • Email Essentials
    • Employee Engagement
    • Finding Work-Life Balance
    • Leadership Communication
    • Leading an Organization
    • Leveraging Technology
    • Management Essentials
    • Managing Change
    • Managers And Leaders
    • Memory Improvement
    • Powerful Presentations
    • The Procedures of Successful Managers
    • Setting Organizational Goals
    • Strategic Brand Management
    • Strategic Sales for Account Managers
    • Quality Awareness
  • Personal
    • Administrative Assistant
    • The Art of Team Building
    • Project Management
    • Time Management
    • Retail Management
    • The Art of Negotiation
    • Interpersonal Communication
    • Public Speaking
    • Conflict Management
    • The Art of Motivation
    • Business Plan Writing
    • Operating a Business
    • Small Business Management
    • Sales Management
    • Customer Service
    • Marketing Principles
    • Marketing Strategies
    • HR Management
    • Strategic Staffing
  • Computer
    • Microsoft Office 2016 >
      • Microsoft Excel 2016 Introduction
      • Microsoft Excel 2016 Advanced
      • Microsoft Word 2016 Introduction
      • Microsoft Word 2016 Advanced
      • Microsoft PowerPoint 2016 Introduction
      • Microsoft PowerPoint 2016 Advanced
      • Microsoft Outlook 2016 Introduction
      • Microsoft Outlook 2016 Advanced
      • Microsoft Project 2016 Introduction
      • Microsoft Project 2016 Advanced
      • Microsoft Visio 2016 Introduction
      • Microsoft Visio 2016 Advanced
    • Microsoft Office 2013 >
      • Microsoft Excel 2013 Introduction
      • Microsoft Excel 2013 Advanced
      • Microsoft Word 2013 Introduction
      • Microsoft Word 2013 Advanced
      • Microsoft PowerPoint 2013 Introduction
      • Microsoft PowerPoint 2013 Advanced
      • Microsoft Outlook 2013 Introduction >
        • Microsoft Outlook 2013 Advanced
      • Microsoft Access 2013 Introduction >
        • Microsoft Access 2013 Advanced
      • Microsoft Project 2013 Introduction >
        • Microsoft Project 2013 Advanced
      • Microsoft Visio 2013 Introduction >
        • Microsoft Visio 2013 Advanced
    • Microsoft Office 2010 >
      • Microsoft Excel 2010 Introduction
      • Microsoft Excel 2010 New Features
      • Microsoft Excel 2010 Advanced
      • Microsoft Word 2010 Introduction
      • Microsoft Word 2010 New Features
      • Microsoft Word 2010 Advanced
      • Microsoft PowerPoint 2010 Introduction
      • Microsoft PowerPoint 2010 New Features
      • Microsoft PowerPoint 2010 Advanced
      • Microsoft Outlook 2010 Introduction
      • Microsoft Outlook 2010 New Features
      • Microsoft Outlook 2010 Advanced
      • Microsoft Access 2010 Introduction
      • Microsoft Access 2010 New Features
      • Microsoft Access 2010 Advanced
    • Adobe Creative Cloud >
      • Adobe CC Introduction
      • Photoshop CC Introduction
      • Photoshop CC Advanced
      • Illustrator CC Introduction
      • Illustrator CC Advanced
      • InDesign CC Introduction
      • InDesign CC Advanced
      • Dreamweaver CC Introduction
  • Banking
    • Corporate Governance
    • Risk Management: Identifying Risks
    • Cash Management
    • Investments
    • Treasury Risk Management
    • Treasury Department Fundamentals
    • Signature Verification and Forgery
  • Blog
  • Contact
  • Login