Mô tả

Microsoft Excel and Word Course BUNDLE!

This course was designed to get you up and running with Microsoft Excel AND Microsoft Word as fast as possible. The course covers all the essentials that make up 80% of the day to day work in Excel and Word. Each lesson is carefully crafted to let you easily practice along and build your Excel and Word skills quickly.

This Microsoft Excel and Word course is up to date with all the latest features and enhancements. However it works great with 2019, 2013 and 2010 versions as well.

Enroll now to get over 13 hours and over 100 lessons of professional training!

Comfortable pace and easy English. Great for ESL.

Enroll now to go from a beginner in Excel and  Word to an Intermediate user ready to tackle most day to day work in Excel and  Word. Microsoft Excel is  the most popular spreadsheet program in the world and Microsoft Word is the most popular word processor. I will be your guide using my 15 years experience as an instructional designer to quickly bring you up to speed on Word saving you months and even years of frustration. 

Stop struggling through your daily tasks at work or wishing you had the skills to advance.  Now you can quickly and easily go from beginner to intermediate step-by-step with clear video lessons and easy to use practice files designed just for this course.

When you have finished this course you will be able to perform the most popular  Word functions and features and have the confidence to take on new challenges, responsibilities and opportunities.  

Here are a few of the highly sought after skills you will acquire in Excel

  • Create attractive and effective spreadsheets

  • Sort and format large sets of data

  • Create and format tables quickly

  • Master useful functions like SUM, VLOOKUP, IF, AVERAGE,  and many others

  • Create dynamic Pivot Tables and Pivot Charts

  • Automate your tasks with Macros

  • Secure workbooks and worksheets

  • Use conditional formatting to highlight data

Here are a few of the highly sought after skills you will acquire in Word:

  • Create Headers and Footers and numbered pages

  • Create and control columns

  • Insert illustrations, pictures, charts, icons, shapes, Smartart, and 3D graphics

  • Create tables to organize text

  • Create standardized and consistent styling

  • Create numbered and bulleted lists

  • Print and collaborate online


    Enroll now and take the next step in making a real difference in your career and income potential. You are only a few clicks away from your new future!

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

EXCEL: Format your data to look very professional

EXCEL: Easily separate and combine data

EXCEL: Create shapes like banners and arrows

EXCEL: Create and run macros to automate work

EXCEL: Use powerful functions and create custom formulas the easy way

EXCEL: Format your data to look very professional

EXCEL: Easily learn VLOOKUP

WORD: Learn the MS Word interface

WORD: Working with styles for professional looking documents

WORD: Create Headers and Footers and numbered pages

WORD: Create and control columns

WORD: Insert illustrations, pictures, charts, icons, shapes, Smartart, and 3D graphics

WORD: Create tables to organize text

WORD: Create standardized and consistent styling

WORD: Create numbered and bulleted lists

WORD: Print and collaborate online

Yêu cầu

  • Microsoft Word and Excel 2013, 2016 or 2019 installed on your computer. Word 2019 required for 3D models.
  • No prior Microsoft Word or Excel Knowledge needed

Nội dung khoá học

27 sections

Getting Familiar with Excel

11 lectures
Using the exercise files
00:23
Introduction to Excel
03:14
Using the menu system
11:00
The quick access toolbar
04:15
Workbooks and worksheets
05:55
The Formula Bar
02:41
The Status Bar
03:54
Using the Navigation tools
07:37
Using shortcuts and the Mini Toolbar
03:25
Using the Help features
03:09
Getting familiar with Excel Quiz
1 question

Data Entry in Excel

6 lectures
Exploring data entry and editing techniques
06:39
Entering Data with Auto Fill
06:07
Working with dates and time.
06:14
Using Redo and Undo
02:35
Adding Comments
02:52
Entering Data in Excel
1 question

Creating Formulas and Functions

8 lectures
Creating your first Formulas and Functions
12:47
Copying a formula into an adjacent cell
03:29
Calculating year to date totals
02:56
Creating a percent change formula
03:43
Working with absolute and relative references
10:54
Autosum and Auto Average
08:18
Other popular Excel functions
12:01
Creating Formulas and Functions
1 question

Formatting Data and Text

9 lectures
Using Fonts and Styles
14:22
Adjusting columns and rows
05:16
Align and merge
04:28
Creating Borders
08:15
Numeric and special formatting
12:52
28. Conditional Formatting
12:50
Creating Tables
17:50
Inserting Shapes
24:00
Adjusting Columns and Rows
1 question

Layout Features

5 lectures
Add and delete columns and rows
06:45
Hide and un-hide rows and columns
04:38
Moving, copying, and inserting data
09:58
Find and replace
07:17
Inserting data
1 question

Preparing Worksheets for Printing

3 lectures
Page break preview
04:54
Page layout view
15:38
Page setup
06:42

Creating Charts

5 lectures
Creating charts from data
07:40
Chart types
11:21
Formatting charts and chart element
07:16
Inserting sparkline
08:14
Creating Charts
1 question

View Options

4 lectures
Freezing and unfreezing panes
04:59
Splitting screens
03:57
Outlining
05:26
View Options
1 question

Viewing multiple workbooks and worksheets

4 lectures
Working with multiple worksheets and workbooks
09:21
Working with sheets
06:37
Linking worksheets and workbooks with formulas
16:34
View Multiple Worksheets
1 question

If Functions and VLookup

5 lectures
If Functions and VLookup
06:00
49. Lookup Approximate
06:03
Lookup Exact with function assistance
05:47
IF family of functions
06:10
Lookup Exact
1 question

Security Features

2 lectures
Securing workbooks and hiding tabs
14:27
Securing workbooks
05:21

Managing Data

8 lectures
Sorting Data
08:05
Insert Subtotals
09:01
Using Filters
07:12
Splitting text
05:35
Splitting and combining with Flash Fill
07:17
Deleting duplicates
05:03
Data validation tools
12:41
Data Validation
1 question

Analyzing Data

3 lectures
Using Goal Seek
10:08
Using Solver
08:05
Using Scenario Manager
09:15

Pivot Tables and Charts

6 lectures
Creating Data Tables
07:04
Creating Pivot Tables
09:49
Manipulating Pivot Tables
09:08
Group by Date
05:24
Pivot Table Slicers
07:16
Pivot Charts
08:59

Macro Basics

1 lectures
Macro Basics
20:50

Advanced Tips and Shortcuts

4 lectures
Finding Formulas
08:37
Auditing Cells
08:37
Using Row References
04:24
Using Column References
08:37

Introduction to Word

2 lectures
The Power of Word 2019
01:08
What you will need for the course
01:29

Getting Started

4 lectures
Open, Close, and Read Word documents
14:30
Saving New Documents
08:41
Getting Help
03:26
Getting Started
1 question

Edit your document

4 lectures
Insert new text
12:03
Cut, Copy and Paste to rearrange text
09:32
Find and Replace Text
06:29
Edit your document
1 question

Formatting Text

3 lectures
Change text formatting
04:39
Change the case of text
03:05
Change Format with styles
08:38

Adjusting Paragraphs

5 lectures
Changing paragraph alignment
13:05
Keeping paragraphs together
05:31
Working with columns
12:19
Organizing with tables
10:52
Adjusting Paragraphs
1 question

Formatting the page

3 lectures
Change the page layout
06:29
Creating headers and footers
07:33
Using Sections to organize and control Headers
05:44

Creating Lists

4 lectures
Creating Bulleted Lists
05:50
Creating Numbered Lists
02:36
Formatting Lists
11:02
Creating lists
1 question

Add Illustrations to your documents

6 lectures
Adding Icons
04:50
Adding Shapes
04:28
Creating SmartArt
06:19
Inserting Charts
06:45
Inserting Screenshots
04:57
Inserting pictures and 3D Models
19:36

Proofing your document

4 lectures
Changing the proofing options
04:08
Spell and Grammar checking
03:19
Using the Thesaurus
02:54
Proofing
1 question

Print and Collaboration

2 lectures
Printing documents
04:40
Collaborating
06:43

Finishing the course

1 lectures
Conclusion
00:39

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