Excel 2013: Advanced

Round out your skills and knowledge of Excel 2013. This course shows you how to use advanced functions, analysis tools, protection features, time-saving macros, and much more. First, you’ll learn how to use complex functions, including lookup, logical, and text functions. Enhance the security of worksheets and workbooks using encryption and other protection features. Get more use out of your PivotTables and PivotCharts by filtering, enabling add-ins, and applying conditional formatting. The course also covers how to automate tasks by creating and running macros, validating data to ensure data integrity, collaborating effectively, and importing and exporting data to a text file.

The course includes step-by-step instructions and engaging videos to help you advanced your Excel 2013 skills.
This course aligns with the CAP Body of Knowledge and should be approved for 2.75 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.