Data Analysis using Excel

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Microsoft Excel is one of the most powerful and popular data analysis desktop application on the market today.

Topics to be covered in Workshop

Introduction about MS Excel & Basics of MS Excel

• Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
• Templates; Creating, Opening, and Saving a Workbook
• Excel Options
• Quick Access Toolbar
• Date Formats
• Formatting Cells; Editing and Deleting Data
• Inserting, Deleting, Hiding and Adjusting Rows and Columns
• Wrap Text and Alignment
• Merging Cells; Applying Themes and Styles
• Borders
• Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets
• Saving Workbooks; PDF and CSV Formats

Advanced Excel

• Overview of Arrays, Formulas and Functions
• Multiple Workbooks and Windows; Comparing Workbooks
• Chart Types; Chart Recommendation
• Selecting Data, Positioning and Printing Charts
• Sorting
• Filtering
• Tables
• VLOOKUP
• Text Function
• Date and Time Functions
• Logical Functions
• Financial Analysis Case Study - Part 

Data Analysis using Excel

• Overview of Data Analysis using Excel
• Foundational Concept of Data Analysis
• Visualize Data
• Customizing Charts & Graph in Excel
• VLOOKUP for Data Analysis
• Dashboard Creation

Duration: The duration of this workshop will be two consecutive days, with eight hour session each day in a total of sixteen hours properly divided into theory and hands on sessions.

Certification Policy:

• Certificate of Participant for all the workshop participants.
• At the end of this workshop, a small competition will be organized among the participating students and winners will be awarded with a 'Certificate of Excellence'.
• Certificate of Coordination for the coordinators of the campus workshops.

Eligibility: There are no prerequisites. Anyone interested, can join this workshop.