What artificial intelligence brings to excel that makes your life easier

Learning objectives

After completing this course, the learner should be able to:

• Use Flash Fill proficiently to clean and prepare data

• Leverage the Excel Ideas feature to quickly start asking their data questions

• Demonstrate how Flash Fill works

• Discuss various ways to employ Flash Fill to make data preparation faster and easier

• Demonstrate how Excel Ideas work

• Discuss various ways to employ Ideas to quickly extract answer from data

• Discuss how to think critically about the answers Ideas provide

Get access to hundreds of courses like this with a CPE subscription
Matt Pickard

Instructor bio

Matt Pickard, Ph.D. earned a B.S. in Computer Science, an MBA from Brigham Young University and a Ph.D. in Management Information Systems from the University of Arizona. Before moving to Illinois to be a Professor of Accounting Data and Analytics at Northern Illinois University, he worked at the University of New Mexico, where he taught accounting information systems and developed the accounting data and analytics curriculum.
He has provided data and analytics training for a variety of organizations, including the City of Santa Fe, Sandia National Labs, the Information Systems Audit and Control Association (ISACA) Albuquerque Chapter and the Illinois Society of Association Executives. His MIS Ph.D. had a heavy data mining and analytics emphasis and was the start of his love for data and analytics. He finds data fascinating and is both overwhelmed and exhilarated to be living in this information age. He and his wife, Laura, are the parents of four beautiful girls. He enjoys woodworking and nature.

National Registry of CPE Sponsors

A Becker Professional Education is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

Becker Professional Education Sponsor I.D. Numbers NASBA: 107294, New York: 002087, New Jersey: 20CE00226700, Texas: 009580, Ohio: CPE.186, Illinois 158.002405, Pennsylvania: PX177823

Now Leaving Becker.com

You are leaving the Becker.com website. Once you click “continue,” you will be brought to a third-party website. Please be aware, the privacy policy may differ on the third-party website. Adtalem Global Education is not responsible for the security, contents and accuracy of any information provided on the third-party website. Note that the website may still be a third-party website even the format is similar to the Becker.com website.