Excel – Beginner to Advanced in 4 Hours
Excel – Beginner to Advanced in 4 Hours, available at $39.99, has an average rating of 4.15, with 27 lectures, based on 149 reviews, and has 3619 subscribers.
You will learn about Microsoft Excel Excel Basics Advanced Functions Arrays Pivot Tables Charts and Graphs This course is ideal for individuals who are Beginner Excel Users It is particularly useful for Beginner Excel Users.
Enroll now: Excel – Beginner to Advanced in 4 Hours
Summary
Title: Excel – Beginner to Advanced in 4 Hours
Price: $39.99
Average Rating: 4.15
Number of Lectures: 27
Number of Published Lectures: 27
Number of Curriculum Items: 27
Number of Published Curriculum Objects: 27
Original Price: $39.99
Quality Status: approved
Status: Live
What You Will Learn
- Microsoft Excel
- Excel Basics
- Advanced Functions
- Arrays
- Pivot Tables
- Charts and Graphs
Who Should Attend
- Beginner Excel Users
Target Audiences
- Beginner Excel Users
This course will cover everything from Excel fundamentals to advanced tools and functions. Whether you’re just learning to navigate Excel or are already using it regularly but don’t quite have a grasp on all of its tools, this course will teach you so many things that will make your job easier and beef up your resume. For a complete breakdown of the course, check out the curriculum.
Course Curriculum
Chapter 1: Excel Basics
Lecture 1: Understanding the Excel Interface
Lecture 2: Cell and Formula Fundamentals
Lecture 3: Basic Arithmetic Formulas & Relative vs Absolute References
Lecture 4: Copy, Pasting, and Using Autofill
Chapter 2: Data Fundamentals
Lecture 1: Data 101
Lecture 2: Relational Data & Primary/Foreign Keys
Chapter 3: Formatting and Validating Data
Lecture 1: Formatting Cells
Lecture 2: Conditional Formatting
Lecture 3: Data Validation
Chapter 4: Cleaning Data
Lecture 1: Intro to Cleaning Data
Lecture 2: Text to Columns Feature
Lecture 3: Filtering Data
Lecture 4: Concatenation 101
Lecture 5: Left(), Right(), Mid(), Find(), and Len() Functions
Lecture 6: Substitute() and Replace() Functions
Lecture 7: Upper(), Lower(), and Proper() Functions
Lecture 8: Putting it all Together
Chapter 5: Advanced Functions
Lecture 1: Intro to Advanced Functions
Lecture 2: Vlookup() Functions
Lecture 3: Index() and Match() Functions
Lecture 4: If(), And(), & Or() Functions
Lecture 5: Iferror() Functions
Lecture 6: Sumif(), Countif(), Averageif(), Maxif(), & Minif() Functions
Lecture 7: Array Formulas
Chapter 6: Pivot Tables & Data Visualization
Lecture 1: Small() and Large() Functions
Lecture 2: Pivot Tables
Lecture 3: Graphs and Charts
Instructors
-
Adrian Pumariega
CPA with 13+ Years Experience in Excel
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 1 votes
- 3 stars: 10 votes
- 4 stars: 56 votes
- 5 stars: 82 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Projeciler İçin Pratik 2 Boyutlu Autocad Eğitimi
- 나만의 메타버스(Metaverse) 로블록스 [건축과 인테리어]
- Formation complète Photoshop CC2019 à CC2023
- Photoshop 2020 Manipülasyon ve Retouch Dersleri
- Plaxis 2D İnşaat (Geoteknik) Mühendisliği Modelleme Programı
- Sıfırdan Autodesk Eagle ile Elektronik Kart Tasarımı
- Mobil UI/UX Tasarım Kursu
- 3ds Max 2019 – 08 recursos fundamentais antes de iniciar.
- Adobe İllustrator 2021 | Sıfırdan Başla Uzman Ol!
- Sweet Home 3D le cours complet
- 【Illustrator入門コース】初心者から始めるフラットデザイン作成講座
- Maya必須カメラ&ライト習得コースMaya Required Camera & Light Acquisition
- İleri Seviye Adobe Photoshop İpuçları
- İŞ AKIŞINIZI FUSİON 360'A AKTARMANIZ İÇİN 40 NEDEN
- Midjourney : L'essentiel pour sublimer vos images
- 【センス不要】絵を描けない83.7%のデザイナーが覚えるべき簡単なイラスト手法を解説!(重宝される)
- Adobe Character Animator | تعلم تحريك الشخصيات
- BAŞTAN SONA AUTOCAD 2020 EĞİTİM SETİ
- Photoshop CC: Warstwy, Maski i Tryby Mieszania
- Фотошоп 2020/2021 с нуля. Практика Photoshop.