Mô tả

Hi guys,

Welcome to my Excel for business - Intermediate course, designed for those who have a basic understanding of Excel and are ready to take their skills to the next level. This comprehensive course will help you master the advanced features of Microsoft Excel, allowing you to work with data more efficiently and effectively. Whether you're looking to improve your productivity at work or simply want to expand your knowledge, this course has everything you need to succeed.

In this course, you'll learn how to use more advanced functions and formulas, create and use templates, and automate your spreadsheet tasks with macros. You'll also learn how to perform data analysis, create and format professional-looking charts and graphs, and work with large amounts of data. By the end of the course, you'll have a solid understanding of how to use Excel in a variety of real-world scenarios.

This course is designed to be hands-on and interactive, with plenty of opportunities for you to practice what you've learned. The lessons are broken down into bite-sized segments, so you can learn at your own pace and revisit key concepts as needed. You'll also have access to quizzes and practice exercises to help reinforce your understanding of the material.

With a focus on practical applications, you'll learn how to use Excel to solve real-world problems, such as analyzing sales data, creating project schedules, and tracking performance metrics. Whether you're looking to advance your career, start a new hobby, or just improve your everyday life, the Excel Intermediate course will provide you with the skills and knowledge you need to succeed.

So if you're ready to take your Excel skills to the next level, enroll in this comprehensive Excel Intermediate course today and start achieving your goals!

Bạn sẽ học được gì

You will learn Intermediate Excel skills and knowledge for Business and Professionals

You will learn how to link and work with data from multiple worksheets, workbooks with the same and different structures

In addition, you will learn how to manage, edit, and maintain datasets much more efficiently and productively

You will also learn how to use more formulas, do calculations and create different reports much more quickly.

Yêu cầu

  • This course requires basic Excel skills and knowledge.
  • You need to be willing to learn and practice a lot

Nội dung khoá học

5 sections

Working with Multiple Worksheets & Workbooks

6 lectures
Working with Multiple Worksheets
06:42
Using 3D formulas
05:16
Linking workbooks
06:55
Using Consolidate tool - consolidate by position
06:08
Using Consolidate tool - consolidate by reference
04:02
Section 1 challenge
01:02

All about Named ranges

5 lectures
Introducing Named ranges
05:29
Different ways to create named ranges
04:47
Managing named ranges
04:05
Using named ranges in formulas and calculations
05:34
Section 2 - challenge
00:06

Intermediate Excel functions

11 lectures
Text functions 1 - CONCAT, UPPER, LOWER, PROPER
06:33
Text function 2 - LEFT, RIGHT, MID
03:25
Text function 3 - FIND
04:03
Some date functions - NOW, TODAY, YEARFRAC
03:29
Some COUNT functions
03:52
Counting with criteria - COUNTIFS
04:24
Adding with criteria + Mixed cell references
05:42
Using sparklines to show trends
04:06
Advanced charting
04:49
Section 3 - challenge 1
00:07
Section 3 - challenge 2
00:07

All about tables

6 lectures
Creating and formatting tables
04:50
Working with tables
04:34
Sorting and filtering in tables + The total row
05:38
Automation with tables
04:47
Converting to range and subtotal tool
04:11
Section 4 - challenge
00:06

All about Pivot tables

6 lectures
Creating and Modifying a Pivot Table
05:11
Value field settings
05:31
Group, sort, and filter tools in Pivot table
05:13
Reporting filter pages
05:57
Pivot charts
05:09
Section 5 - challenge
00:06

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.