Below are the topics I will cover in details that will make you a competent user in Excel:-
Create and manage worksheets and workbooks
Create cells and ranges
Create tables
Apply formulas and functions
Create charts and objects
Pivot Tables
Macros - VBA (Visual Basic Coding)
Other Coding Languages such as SQL & Power BI can also covered on request
I am a Finance Analyst professional with more than 6 years of working experience performing data analysis and financial modelling using Advanced Excel. I have done my bachelors and masters in Accounting & Finance, also hold Microsoft Office Certified in Excel 2013.
PROFILE SUMMARY
• Competent with the usage of Advanced Excel, VBA, PowerBI, SQL
• Leveraging skills in the preparation of monthly accounting reports and effectively managing documents for streamlining systems to facilitate achievement of organizational objectives and ensure profitability of operations
• Rich expertise in Data Analysis, Manipulation, Sorting and Modelling; proficiency in analyzing financial activities using Excel modeling (Vlookup, Pivot Tables, Formulas) including the monthly close process, balance sheet account valuations and reconciliations and expense budgeting and forecasting
CERTIFICATION
• Microsoft Office Specialist Excel 2013, Nov 2017
Perfect! Expert professional help, I needed help with finances on a budget and he knew what to do, I went through 3 people before that and no one could help, I highly recommend Vikrant for this subject and for any excel problems you might have
Good
My time working with Vikrant I’ve learned not only Excel skills but also the logic of problem solving skills. I only knew the names of the functions but didn’t know how to use it or why we use it. Thanks to Vikrant for great teaching, being a mentor and preparing very practical real life business case examples, and sharing the experience with me. I highly recommend Vikrant!
When it comes to data analytics or financial reporting in Excel Vikrant skills are just excellent. He is great data analyst who can understand technical concepts and enjoys picking up new technologies like VBA, SQL and Power BI to its full advantage.
basic computer lessons nearby? Here's a selection of other listings you can check out.
Superprof can also help you with microsoft word lessons.
Not quite what you're after? How about microsoft excel lessons?
at their place | at your place | by webcam | |
1 hour | $40 | $60 | $40 |
5 hours | $120 | $220 | $200 |
10 hours | $600 | $800 | $400 |