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

Related products

 
Required 'Candidate' login to applying this job. Click here to logout And try again
 
 

Answers

 

Account Activation

Before you can login, you must activate your account with the code sent to your email address. If you did not receive this email, please check your junk/spam folder. Click here to resend the activation email. If you entered an incorrect email address, you will need to re-register with the correct email address.