Microsoft Office Excel 2019 : Basic
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1 student enrolled

Microsoft Office Excel 2019 : Basic

Part1
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1 student enrolled
Last updated 2/2020
English
English [Auto-generated]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 8 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • General overview of Excel2019
  • Modifying and formatting a worksheet
  • Managing and Printing workbooks
  • Customozing the worksheet
Requirements
  • Microsoft Excel 2007 - 2019
  • Computer or laptop with Windows
Description

This course will introduce students to Microsoft Office Excel 2019, and teach students about performing calculations, modifying a worksheet, formatting a worksheet, printing workbooks, managing workbooks, adding borders and colors to worksheets, and basic Excel customization.

This course will teach students about working with functions, working with lists, analyzing data, visualizing data with charts, using PivotTables and PivotCharts, working with graphical objects, and using array formulas.

This course will teach students about working with multiple worksheets and workbooks, sharing and protecting workbooks, automating workbook functionality, using Lookup functions and formula auditing, forecasting data, creating sparklines and mapping data, importing and exporting data, internationalizing workbooks, working with Power Pivot, advanced customization options, and working with forms and controls.

Who this course is for:
  • Absolute beginners who want to learn all about Microsoft Excel
  • Excel users with basic skills but interested in learning new features
  • Business professionals
  • Data analysts for building strong analytical and business intelligence skills
Course content
Expand all 220 lectures 04:21:59
+ Getting Started with Microsoft Office Excel 2019
48 lectures 01:13:52
The General Excel UI
02:52
The Workbook and Worksheet UI Elements
02:22
Excel Window Commands
01:08
The Backstage View
00:51
Mouse Navigation
02:17
Mouse Cursor Icons
01:37
Keyboard Navigation
00:49
The Active Cell
01:49
Basic Data Entry
01:15
Demo - Navigating the Excel User Interface
06:09
Topic B: Use Excel Commands
00:24
The Ribbon
03:45
The Ribbon Tabs
00:19
Tell Me
00:41
ScreenTips and KeyTips
01:09
The Quick Access Toolbar
01:01
The Mini Toolbar and Context Menus
01:06
Demo - Using Excel Commands
03:43
Topic C: Create and Save a Basic Workbook
00:32
The New Tab
00:59
Excel 2019 File Formats
02:37
The Save and Save As Commands
01:02
The Save As Screen
01:28
Compatibility Mode
00:35
The Convert Option
00:34
The Compatibility Checker
00:55
Demo - Creating and Saving a Basic Workbook
04:09
Topic D: Enter Cell Data
00:24
It's Not WYSIWYG
01:13
Data Types
01:35
The Cut, Copy, and Paste Commands
01:21
Drag-and-Drop Cut and Paste
01:01
The Undo and Redo Commands
00:33
The AutoFill Feature
00:54
AutoFill Options
00:56
Flash Fill
01:14
The Clear Command
01:18
Demo - Entering Cell Data
05:02
Topic E: Use Excel Help
00:28
The Help Task Pane
01:08
Demo - Using Excel Help
02:40
Chapter 01 Review
00:42
+ Performing Calculations
35 lectures 42:08
Section Introduction
00:24
Topic A: Create Worksheet Formulas
00:34
Excel Formulas
01:00
The Formula Bar
00:44
A Basic Mathematical Formula
01:48
Elements of Excel Formulas
00:41
The Order of Operations
01:18
Reference Operators
01:23
Intersection Operator Example
00:20
Demo - Creating Worksheet Formulas
05:06
Topic B: Insert Functions
00:33
Functions
01:12
The Function Library Group
01:23
The Insert Function Dialog Box
00:43
The Function Arguments Dialog Box
00:59
Graphical Cell and Range Reference Entry
00:38
The AutoSum Feature
00:57
Other Commonly Used Functions
00:31
Basic Function Syntax
01:45
The Formula AutoComplete Feature
00:44
The Arguments Tooltip
00:33
Demo - Inserting Functions
05:07
Topic C: Reuse Formulas and Functions
00:21
Formulas and the Cut, Copy, and Paste Commands
00:47
The Paste Options
01:14
The Paste Special Dialog Box
00:35
Relative References
01:00
Absolute References
00:57
Mixed References
00:39
AutoFill and Formulas
00:38
Worksheet References
00:42
Excel Errors and Display Issues
01:30
Error Indicators
00:43
Demo - Reusing Formulas and Functions
04:09
Chapter 02 Review
00:30
+ Modifying a Worksheet
21 lectures 25:50
Section Introduction
00:40
Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
00:22
The Insert and Delete Options
01:34
Manual Width and Height Adjustments
00:52
Manual Fit
00:12
The AutoFit Feature
00:39
The Row Height and Column Width Dialog Boxes
00:16
The Hide and Unhide Commands
00:45
Demo - Adjusting Cells, Columns, and Rows
03:55
Topic B: Search for and Replace Data
00:21
The Find Command
01:16
The Replace Command
00:43
The Go To Dialog Box
00:56
The Go To Special Dialog Box
01:57
Demo - Searching for and Replacing Data
05:11
Topic C: Use Proofing and Research Tools
00:33
The Spelling Dialog Box
01:08
The Thesaurus Task Pane
00:32
The Smart Lookup Task Pane
00:43
Demo - Checking the Spelling in a Worksheet
02:37
Chapter 03 Review
00:38
+ Formatting a Worksheet
46 lectures 53:10
Section Introduction
00:59
Topic A: Apply Text Formats
00:32
Fonts
01:09
The Font Group
01:00
Live Preview
00:34
The Format Cells Dialog Box
00:43
The Colors Dialog Box
00:24
Hyperlinks
00:39
The Insert/Edit Hyperlink Dialog Box
00:52
The Format Painter
01:11
Demo - Formatting Text in a Worksheet
05:21
Topic B: Apply Number Formats
00:31
Number Formats
00:58
Number Format Tab
01:10
Custom Number Formats
00:54
Demo - Applying Number Formats
03:16
Topic C: Align Cell Contents
00:34
Alignment Options
00:50
Orientation Options
00:42
The Indent Commands
00:29
The Wrap Text Command
00:55
The Merge & Center Options
00:52
Demo - Aligning Cell Contents
02:36
Topic D: Apply Styles and Themes
00:38
Cell Styles
01:02
Galleries
00:39
The Style Dialog Box
00:32
The Merge Styles Dialog Box
00:35
Themes
00:45
Theme Components
01:18
Guidelines for Using Themes
01:45
Demo - Applying Cell Styles and Themes
05:05
Topic E: Apply Basic Conditional Formatting
00:30
Conditional Formatting
00:49
The Conditional Formatting Dialog Boxes
00:41
Excel 2019 P1 (Course Outline).pdf
00:51
The Top/Bottom Rules
00:22
Data Bars
00:34
Color Scales
00:47
Icon Sets
00:19
Demo - Applying Basic Conditional Formatting
03:01
Topic F: Create and Use Templates
00:39
Templates
01:06
Templates and the Backstage View
00:44
Demo - Creating a Template
02:09
Chapter 04 Review
01:08
+ Printing Workbooks
24 lectures 25:53
Section Introduction
00:54
Topic A: Preview and Print a Workbook
00:22
The Print Tab
00:52
Print Settings
00:57
Page Orientation
00:29
Margins
00:36
Print Preview
00:38
Demo - Configuring and Previewing a Print Job
03:10
Topic B: Set Up the Page Layout
00:22
The Page Setup Dialog Box
01:01
The Print Area
00:33
The Print Titles Command
00:42
Page Breaks
00:34
Workbook Views
00:32
Page Break Preview View
00:30
Demo - Setting Up the Page Layout
03:17
Topic C: Configure Headers and Footers
00:23
Headers and Footers
00:45
Page Layout View
00:33
Contextual Tabs
00:33
The Header & Footer Tools Contextual Tab
00:40
The Header and Footer Dialog Boxes
00:34
Demo - Configuring Headers and Footers
03:28
Chapter 05 Review
03:28
+ Managing Workbooks
25 lectures 27:33
Section Introduction
00:41
Topic A: Manage Worksheets
00:23
Methods of Inserting and Deleting Worksheets
01:00
Tab Formatting Options
00:29
Drag to Reposition Worksheets
00:36
The Move or Copy Dialog Box
00:30
The Hide and Unhide Worksheet Options
01:07
Demo - Managing Worksheets
04:03
Topic B: Manage Workbook and Worksheet Views
00:45
Custom Views
00:39
The Add View Dialog Box
00:33
The Split Command
00:32
The Freeze Panes Options
01:18
The Arrange All Command
00:41
The Arrange Windows Dialog Box
00:57
The View Side by Side Command
00:34
The Switch Windows Command
00:25
The New Window Command
00:23
Demo - Managing Workbook and Worksheet Views
03:43
Topic C: Manage Workbook Properties
00:43
Workbook Properties in the Backstage View
01:00
The Properties Dialog Box
01:29
Custom Workbook Properties
00:57
Demo - Managing Workbook Properties
03:37
Chapter 06 Review
00:28
+ Adding Borders and Colors to Worksheets
9 lectures 04:38
Section Introduction
00:28
Topic A: Add Borders and Colors to Worksheets
00:15
Border Options
00:58
The Borders Drop-Down Menu
00:45
The Border Tab
00:27
Fill Options
00:27
The Fill Tab
00:12
Sheet Backgrounds
00:37
Chapter 07 Review
00:29
+ Basic Excel Customization
9 lectures 05:51
Section Introduction
00:25
Topic A: Customize General Options and the Excel UI
00:07
The Excel Options Dialog Box
01:15
The Customize Ribbon Tab
00:46
The Customize the Ribbon List Hierarchy
00:21
The Quick Access Toolbar Tab
00:25
The Customize Quick Access Toolbar Menu
00:23
Chapter 08 Review
00:34
Course Closure
01:35