- Introduction
- Logical tests
- IF Statements
- VLOOKUP
- INDEX and MATCH
- S is for Super Power (summing with conditions attached)
- Efficiency with Tables
- Explaining Pivot tables in 10 minuites
- Introducing Dynamic Arrays
- Pivot table alternative using Dynamic Arrays (UNIQUE SORT AND TRANSPOSE)
- The FILTER function
- XLOOKUP
- Conclusion
What you'll learn
- You will learn the most essential Excel Skills for Accounting and Financial Professionals - Skills that will enhance you career
- Logical tests and IF statements
- VLOOKUP, INDEX & MATCH and XLOOKUP
- Sum with conditions (SUMIF SUMIFS)
- Tables for efficiency
- Pivot tables
- Dynamic Arrays
Description
Are you an Accountant or an aspiring Accountant? Do you work in Finance? Do you want to ensure you are equipped with the core fundamental Excel skills that every accountant or financial professional should have? well if so this course has been designed for you.
Excel is the tool of choice for most accountants, and having great Excel Skills can make a massive difference in your career prospects. However many are lacking the core fundamental skills Excel required to use the tool efficiently.
This course has been designed and developed by an accountant and focuses on the core Excel skills needed in the industry. Some of these skills are at a basic level, however, some of them are at an advanced level. Each of the topics covered in this course is a core skill for the job and knowing some of the newer features of Excel 365 will put you ahead of the curve.
This course is a short course and a basic knowledge of Excel is required. In this course, you will find workbooks to download so you can practice along and you will also find some activities to complete.
The topics covered in this course are
Logical tests and IF statements.
Lookup Formulas
Summing with criteria
Working with tables
Pivot tables
Dynamic arrays
Other Courses
Family Child Day Care Home and In-Home Provider Orientation
Understanding your role and responsibilities as a family home provider
Reskin an iOS App
Learn the complete process of reskinning a Personality Quiz source code for iOS using XCode, from start to finish.
10 Steps to an AwesomeSauce You! (Step 10)
This section is about showing up in the world in the ways that work for you and having the experiences you want.
Stream Crossing Design (NY NRCS Standard 578)
A guide to designing at-grade, culvert and bridge crossings for animals and agricultural vehicles in NY.
WordPress Backup And Restore Fundamentals
Complete video guide on how to backup and restore your WordPress blog.
SAT Math, GRE Math, and GMAT Math: Grad School, MS, MBA Path
Basic Math Foundation Skills for SAT Math, GRE Math, or GMAT Quant | Experienced Tutor with Amazing Student Testimonials
About the instructors
- 4.44 Calificación
- 153061 Estudiantes
- 14 Cursos
Paula Guilfoyle CPA
CPA Accountant, & Life Long Learner
With over 25 years of expertise in Accountancy, Business Management, and Operations, I, Paula, am a seasoned CPA (Certified Public Accountant) dedicated to empowering learners with practical skills and knowledge. As a former Microsoft MVP (Most Valuable Professional) in Excel for two consecutive years (2020 & 2021), I've been recognized for my commitment to excellence in spreadsheet solutions and financial analysis.
Having immersed myself in the Web3 landscape since 2016, I've become a leading voice in simplifying complex concepts, making Web3 and Blockchain technology accessible to all. And so, my journey took an exciting turn in 202 when I embraced the transformative potential of Web3, Blockchain, and Digital Assets and pivoted my training to focus on web.
Founder of A Block of Crypto: As the founder of A Block of Crypto, I am passionate about demystifying the world of cryptocurrency and blockchain. Through engaging courses and interactive online meetups, I strive to make Web3 and blockchain technology as intuitive as ABC. My mission is not just to educate but to onboard and retain users in the rapidly evolving Web3 ecosystem.
What I Offer:
Comprehensive Courses: Dive deep into the fundamentals of Web3, Blockchain, and Crypto with my meticulously crafted courses designed for beginners and seasoned professionals alike.
Interactive Online Meetups: Join our vibrant community and participate in regular online meetups where you can network with like-minded individuals, ask questions, and stay updated on the latest developments in the world of Web3.
Web3 Support: Whether you're navigating your first crypto project or exploring decentralized finance (DeFi) protocols, I'm here to provide guidance and support every step of the way.
Let's Connect: Embark on your journey into the exciting world of Web3 and Blockchain with me. Follow me on Udemy to stay updated on upcoming courses, events, and exclusive learning opportunities. Together, let's unlock the full potential of decentralized technology and shape the future of finance and beyond.
Student feedback
Course Rating
Reviews
The instructor explains things very thoroughly and the why.
Great knowledge
Great! So Far!