Mô tả

Hi guys,

Introducing the Excel essentials for business course (Excel foundation course), the perfect starting point for anyone looking to build a strong foundation in Microsoft Excel. This comprehensive course covers all the basics of Excel and is suitable for both beginners and those with limited experience. Whether you're looking to improve your spreadsheet skills for personal or professional use, this course has everything you need to get started.

In this course, you'll learn how to navigate the Excel interface, create and format spreadsheets, and perform essential calculations using functions and formulas. You'll also learn how to use basic formatting tools, create charts and graphs, and work with tables and pivot tables. By the end of the course, you'll be able to create and manipulate spreadsheets with ease and confidence.

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 in real-world scenarios, such as tracking expenses, analyzing data, and creating budgets. Whether you're looking to advance your career, start a new hobby, or just improve your everyday life, the Excel Foundation 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 Foundation course today and start achieving your goals!

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

You will learn to build a solid understanding of the Basics and Essentials of Microsoft Excel

You will learn to master Essentials Excel knowledge and skills for business

You will learn the most commonly used Excel options, functions, calculations shortcuts, and formatting tools

You will also learn to maintain large sets of Excel data

Yêu cầu

  • Microsoft Excel 2016 is preferable but other versions are OK
  • Willing to learn and practice a lot

Nội dung khoá học

4 sections

Excel user interface and key foundational features

12 lectures
Take charge of Excel
06:37
Take charge of Excel - quiz
3 questions
Navigating and selecting in Excel
05:49
Navigating and Selecting - Quiz
4 questions
Use and change view options in Excel
05:24
View options - quiz
3 questions
Data Entry, Editing and Deleting data in Excel
06:16
Using Fill Handle in Excel
05:21
Quiz on Fill Handle
4 questions
All about Copy, Cut and Paste Options in Excel
05:01
Essential shortcuts in Excel
03:11
Practice challenge for section 1
00:10

Basic formulas, basic functions and cell references

14 lectures
Simple Excel formulas
03:36
Quiz on basic formulas
3 questions
Using Formulas in Business context
04:08
Quiz on using Formulas in Context
3 questions
Basic Excel Functions - Sum and Autosum
03:50
Quiz on Sum and Autosum
3 questions
Basic Excel Functions - Average, Max, and Min
04:29
Quiz on Average, Max, and Min functions
3 questions
Absolute cell references
03:42
Quiz on Absolute cell reference
3 questions
Calculations across sheets
04:53
Quiz on calculations across sheets
3 questions
Excel options
05:46
Practice challenges for section 2
00:28

Tools to make better - looking worksheets

13 lectures
Formatting tools - Font group
03:35
Quiz on formatting tools
3 questions
How to use different kinds of borders
04:02
Quiz on how to use borders
3 questions
How to use vertical and horizontal alignment tools
04:05
Quiz on alignment tools
3 questions
How to copy and clear formatting quickly
03:53
Number Formatting
05:12
Quiz on Number formatting
3 questions
Basic Chart types
04:51
Quiz on basic charts
4 questions
Keyboard shortcuts and some tips
01:01
Practice challenge for section 3
00:08

Working and managing data

7 lectures
Managing rows and columns
04:20
Find and replace data
03:16
Filtering tools
06:34
Sorting data
03:46
Conditional formatting
06:42
Terminology and useful keyboard shortcuts
01:36
Practice challenge for Section 4
00:18

Đá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.