Course

Microsoft Office 2016 Intermediate Excel: Macros and Advanced Queries

Skillsoft

Updated Mar 11, 2018

Using macros in Excel 2016 lets you save time when performing repetitive tasks. This course covers the options available when you are running macros, and also how to create your own custom macros. You will also learn about advanced functions that allow you to perform calculations using date and time, how to look up data, and how to perform advanced conditional queries.

Related learning

Excel 2013 Part 2: Use Specialized FunctionsInteractive ⋅ 7 mins

VBA for BeginnersCourse ⋅ 240 mins

Analyzing Data in Excel 2016: Apply Intermediate Conditional FormattingInteractive ⋅ 3 mins

Excel 2016 AdvancedInteractive ⋅ 159 mins

Explore more technology skills

IT Software

Web Design and Development

Data & Analytics

Design and Animation

Gaming and Games Development

Devops, Networking and Security

Programming and Web Development

Computer Science and Engineering

Skillsoft GLOBAL

Skillsoft is the global leader in corporate learning, providing the most engaging learner experience and high-quality content. Skillsoft are trusted by the world's leading organizations, including 65 percent of the Fortune 500. Skillsoft's mission is to build beautiful technology and engaging content that drives business impact for today's modern enterprise. Skillsoft provides a comprehensive selection of cloud-based corporate learning content, including courses, videos, books and other resources. Skillsoft's 500,000+ multi-modal courses, videos, authoritative content chapters and micro-learning modules are accessed more than 130 million times every month, in 160 countries and 29 languages. Via the Go1 Content Hub, you can access Skillsoft courses on topics including Business and Management Skills, Leadership Development, Digital Transformation, IT Skills and Certification Training, Productivity and Collaboration Tools and Compliance.