team@referralroom.in; thereferralroom@gmail.com

Excel: Beginner To Advance

Excel: Beginner To Advance

3000

Excel is the most important and widely used tool for recording, analyzing and  interpreting data. From small businesses to large multi-nationals like Google, all use  Excel. It is therefore particularly important to know not only the basics of Excel but also  to learn the intricacies of it. You will not only learn how to do basic calculations in Excel  but also how to automate these calculations and make the day to day work more  efficient.

Our faculty Ms. Shivangee Agarwal is a visiting mentor in St. Xavier’s College, Kolkata.  She has an experience of mentoring more than 500 students. She conducts has also  conducted Excel workshops for AIESEC, St. Xavier’s College, Kolkata and many more.  Get a head start in Excel with real-life data analysis and manipulation.

Category:

Description

Excel is the most important and widely used tool for recording, analyzing and  interpreting data. From small businesses to large multi-nationals like Google, all use  Excel. It is therefore particularly important to know not only the basics of Excel but also  to learn the intricacies of it. You will not only learn how to do basic calculations in Excel  but also how to automate these calculations and make the day to day work more  efficient.

Topics to cover- 

• Introduction to Excel interface.

• Basic Features and Tools

• Entering and Editing Texts and formulas

• Basic Excel functions (logical, mathematical, and statistical)

• Modifying an Excel worksheet

• Formatting data in Excel

• Printing of an excel sheet

• Advanced Features of Excel

• Advanced Functions of Excel

• Importing and Exporting data.

• What-If Analysis

• Data validation and manipulation in Excel (Handling Errors & Duplicates)

• Financial Functions in Excel

• Matrix Functions

• Date, Time, and Text Functions

• 100+ Shortcuts of Excel

• Creating a presentable report.

• Creating different charts in Excel

• Sparklines and Candlestick charts

• Pivot Tables and Slicers

• Data Analysis Toolpak and Solver

• Linear Regression in Excel

• Simulations