Microsoft EXCEL Training Level 2 in pdf

Introduction

This course will give you the skills to perform simple data analysis in Excel. You will learn how to use formulas, conditional formatting, filtering and sorting and many more data analysis features to help you in your work. This course will increase your competence in day-to-day data analysis making you more efficient and productive.

Topics Include

• Use workbooks as templates for other workbooks.
• Manipulate worksheet data.
• Use intermediate data management tools such as filters and advanced filters.
• Summarize data that meets specific conditions.
• Link to data in other worksheets and workbooks.
• Locate and use some of the more complex Excel functions.
• Create and modify charts.