This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I'll show you when, why, and how to use Excel Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way.
There are many helpful and time-saving Excel formulas and features. We tend to forget what these are if we don't use them. This Microsoft Excel Essentials Course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.
__________
We'll start by covering everything you need to know to get up and running with Excel Pivot Tables, including:
Raw data structure in Excel
Pivot Table layouts & styles
Design & formatting options
Sorting, filtering,
Calculated fields, items & values
Pivot Charts, slicers & Chart
At the completion of this course, you will have mastered the most popular Excel tools and come out with the confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:
Creating effective spreadsheets
Managing large sets of data
Mastering the use of some of Excel's most popular and highly sought-after functions (SUM, VLOOKUP, IF, AVERAGE)
An Inclusive course to learn Python Advanced made accessible for People with Disabilities by GiftAbled
Integrating disparate enterprise applications within an organization using TIBCO Business Works Container Edition (BWCE)
How to invest successfully at the stock market during recessions, crises and bear markets
Structural Steel Design to SANS 10162
Basics of building API using Nodejs & MongoDB
Securing our income(s) has never been more important! Learn how to get into the right industry and job function.
Sajedul Islam is an accountant, consultant, teacher, and author. He has provided accounting & consulting services to large Fortune 500 companies. Sajid's passion is teaching, and he has 15000+ students enrolled in his online courses.
He helped transform the lives of students taking them from NO accounting experience to helping them find successful work in the accounting industry. His biggest passion is inspiring and helping others achieve their goals.
STUDENT REVIEWS:
- "Simple, straightforward explanations, lots of helpful examples." - Corina
- "The explanation is awesome!" - Belal Ahmed
- "Easy to understand" - Carlos
- "simple." - Joselito F.
- "I love how clear the instructor is, very direct to the point." - Carrie
CALVIN'S BEST SELLING COURSES (search "Calvin Lee" on Udemy to see all courses.)
- Payroll & Bookkeeping
- Bookkeeping in QuickBooks Online & Xero
- Accounts preparation
My academic Credentials are associated with,
Oxford Brookes University (BSc(Hons) in Applied Accounting
MBA - Cardiff Metropolitan University, UK
ACCA- UK ( Member of Association of Chartered Certified Accountants)
ICAEW ( Associated with International Chartered Accountants of England & Whales)PQ
My interest in accounting and academic side has pushed me to work on the education sector and it will be an honour for me if I could utilize my qualifications, skills and experience to educate masses as a whole.
Thanks for reading and looking forward to become your instructor :)
