Master Excel with Practical real world scenarios
What you'll learn
- Introduction to Excel
- How to manage spreadsheets, Formulas & Functions
- Charts & Graphs
- Practical scenarios to explain pivot table, power query, forms and many other concepts
Requirements
- No prior experience in Excel is required
Description
This Course will teach you Microsoft Excel using practical real world situations and scenarios. The skill set acquired here will be directly applicable in your job or projects. This is a beginner level course but has plenty of material for experienced people to learn including pivot tables, power query, Gantt charts, expense trackers, data entry forms, VLOOKUP, time value of money, NPV and many more concepts.
The first five sections are for learning Excel Foundations. You will learn about working in Excel and following every lesson will prove extremely beneficial for you, if you are new to MS Excel.
The 6th and the largest sections is filled with many case studies, where you will see MS Excel's power used in actual situations. This section also includes some much needed and less known tips as well. Some of the Topics are given below:
Data Validation
Flashfill
Gantt Chart in Excel from scratch
How to make Monthly expense tracker for Family
Making data entry forms without coding
Power Query Intro and use on actual data
Using the NPV function to understand the time value of money
Using Vlookup in serial fashion to compare two lists
These lectures and real world cases are intended to bring you at par with an intermediate user of Excel. However, polishing any skill requires practice. You can call it “sharpening the saw” as Stephen covey puts it. The best way to learn Excel is to get your hands dirty and apply all these concepts by hand. Only then you will learn something that will stay with you for life.
Who this course is for:
- Beginners in Excel
Instructor
![Athar Shah](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 8 Reviews
- 1,009 Students
- 1 Course
I have over 13 years of diverse experience in Entrepreneurship, Account Management, Project Management, Marketing, Segments, Business development and R&D. I have worked on different projects including launching of GPON Fiber To The Home (FTTH) at Karachi DHA, Multiple dark fiber deployment projects and Leased media projects. I have conducted focus groups, one to one expert interviews, segmentation, pricing of B2C as well as B2B wholesale products, customer loyalty programs and marketing plans. I am a team player and have been involved in cross functional coordination and giving directions while acting as project manager for different projects throughout my career.
As Senior Manager PMO, I was responsible for Multi-million $ projects. I was responsible for the whole project life cycle including deployment, risk identification, closing and handing over to operations.
As Manager Business Development - Carrier Services & Wholesale, I was required to plan and execute overall business development and sales strategies to maintain and grow PTCL business for the inter-operator and wholesale segment. Portfolio of PKR 4.9 Billion.
I am a good communicator in person as well as on phone and email, which has helped me in relationship management with key personnel of the customers. This has also enabled me to successfully sell PTCL products to my accounts. I have been able to generate more than 535 Million PKR for PTCL in 2017/18 by selling 677 KM of dark fiber to a Jazz while I was its account Manager. I developed the dark fiber business with Jazz from scratch. In case of IPBW, I have been able to Upsell more than US $ 200,000 per month to different Accounts.
I am always involved in problem solving. I am a self-driven and naturally curious person who does not get overwhelmed easily. I love talking to people because you learn from every conversation. I have clarity on what needs to be done and I put all energy in getting it done.
I have attained MBA from the most prestigious Business Institute of Pakistan, Lahore University of Management Sciences (LUMS). I also have an Engineering degree from the highly respected Ghulam Ishaq Khan Institute (GIKI).