– IF and Related Functions MODULE 2: Analyzing Data using Excel Power functions and Statistical functions.Excel built-in functions with categories.– Conditional formatting using color scales – Changing cell values in different formats Formatting Cells, Freezing & Conditional Formatting.Exploring Window and playing with cells.Some tricks and keyboard shortcuts will be shown while doing data analysis. This module takes you through hands-on operations on some basic but extremely useful and common functions used everywhere. Webinar Course Outline MODULE 1: Basic Functions of MS-ExcelĮxcel is a tool which is widely used for data management and analysis using its powerful in-built functions. The objective is to familiarize the participants with the fundamentals of how to manage, transform and analyze data using the various functions in Excel. This course provides participants with the knowledge and skills to work with and analyze data and work with business cases using Microsoft Excel. Microsoft Excel is a very widely used tool with many organizations and departments and being able to produce a quick analysis is an asset.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |