Learn Microsoft Excel : Advanced Tactics for Workplace
What you'll learn
- Sorting and Filtering
- Vlook Up in Details
- Pivot Table with examples
- If Function
- Find and Replace
- Remove Duplicates
- Password on Excel file
- Data Validation
- Goal Seek
Requirements
- Microsoft Excel 2010-2019 or Office 365 (ideally for PC/Windows)
- Mac users are welcome, but note that the Pivot Table interface varies across platforms
- Basic experience with Excel functionality (charts & formulas a plus!)
Description
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)
Who this course is for:
- Students will little knowledge about Microsoft excel
Instructor
- 4.2 Instructor Rating
- 232 Reviews
- 5,129 Students
- 8 Courses
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 :)