Excel 2013: Intermediate

Move beyond the basics and add to your spreadsheet skills by learning how to use the intermediate features and functions in Excel 2013. In this course, you will learn how to work with text, logical and lookup functions, in addition to learning how to use range names to simplify and improve the readability of your formulas. You’ll learn how to create tables and charts, as well as more advanced PivotTables and PivotCharts, to organize and analyze your data. Navigate through your worksheets and workbooks more effectively by creating links, using conditional formatting and outlining subtotals and groups. The course also covers how to work with Flash Fill and date and time functions to save time and effort.
This course is the second part in a 3-part series on Excel 2013. To take your skills to the next level, watch the next course in the series, Excel 2013 Advanced.
This course aligns with the CAP Body of Knowledge and should be approved for 4 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.