Skip to main content
00:00/00:00
Lecture 2 of 217

introduction-to-work-smarter-with-excel

Download Course (Free)

Course Content

0 / 217 completed
Section 1: entry-level-get-started-with-excel4 videos

get-help-in-microsoft-excel

2m

save-and-share-a-workbook

5m

create-a-workbook

4m

get-to-know-excel

4m
Section 2: welcome-to-the-course7 videos

introduction-to-work-smarter-with-excel

3mNow Playing

navigating-this-course

5m

introduction-to-work-smarter-with-powerpoint

1m

course-introduction-work-smarter-with-microsoft-word

3m

navigating-this-course

5m

program-introduction-microsoft-365-fundamentals

12m

careers-in-microsoft-365

5m
Section 3: entry-level-get-started-with-data2 videos

work-with-data

5m

work-with-rows-and-columns

4m
Section 4: entry-level-modifying-a-worksheet5 videos

format-text

4m

format-cells

3m

align-cell-content

2m

search-for-and-replace-data

5m

spell-check-a-worksheet

3m
Section 5: entry-level-printing-workbook-content3 videos

refine-the-page-layout-and-apply-print-options

6m

module-summary-getting-started-with-excel

2m

define-the-basic-page-layout-for-a-workbook

7m
Section 6: working-with-formulas-and-functions3 videos

module-introduction-working-with-functions

3m

a-closer-look-at-formulas-and-functions

6m

using-formulas-and-functions

5m
Section 7: apply-range-in-excel2 videos

add-range-names

4m

use-range-names-in-formulas

1m
Section 8: sorting-and-filtering-data1 videos

sort-and-filter-data

6m
Section 9: specialized-functions2 videos

using-specialized-functions

2m

function-categories-and-syntax

7m
Section 10: text-functions3 videos

manage-text-with-functions

4m

join-and-transpose-text-functions

2m

trim-and-case-text-functions

2m
Section 11: logical-functions3 videos

logical-functions-and-operators

2m

using-logical-functions-with-conditions

5m

module-summary-working-with-functions

2m
Section 12: create-and-modify-tables4 videos

module-introduction-organizing-and-visualizing-data

1m

format-tables

5m

create-tables

8m

modifying-tables

9m
Section 13: table-references2 videos

name-tables-and-use-structured-references

7m

database-functions-and-convert-to-range

5m
Section 14: managing-large-workbooks3 videos

format-worksheet-tabs

3m

manage-worksheets

6m

manage-the-view-of-worksheets-and-workbooks

7m
Section 15: visualizing-data-with-basic-charts3 videos

create-charts

5m

modify-and-format-charts

4m

advanced-chart-elements

2m
Section 16: analyzing-data4 videos

create-a-pivottable

7m

summarize-data-in-a-pivottable

7m

module-summary-organizing-and-visualizing-data

3m

filtering-data-using-slicers

3m
Section 17: customize-formula-proofing-and-saving-options2 videos

conditional-formatting

4m

conditional-formatting-rules

6m
Section 18: customize-the-excel-environment3 videos

customize-the-ribbon-and-quick-access-toolbar

2m

customize-formula-options

3m

customize-proofing-and-save-options

3m
Section 19: exporting-and-sourcing-data3 videos

export-data

4m

use-data-sources

7m

module-summary-advanced-excel-features

1m
Section 20: enhancing-workbooks-and-manage-workbook-properties2 videos

customize-workbooks

6m

manage-workbook-properties

4m
Section 21: analyze-and-present-data-with-excel1 videos

project-introduction

3m
Section 22: course-wrap-up3 videos

course-wrap-up-work-smarter-with-microsoft-excel

3m

course-wrap-up-work-smarter-with-microsoft-powerpoint

1m

course-wrap-up-work-smarter-with-microsoft-word

5m
Section 23: entry-level-getting-started-with-powerpoint5 videos

navigate-the-powerpoint-environment

5m

using-the-ribbon

2m

create-and-save-a-powerpoint-presentation

4m

working-with-slides-and-files

2m

use-help

4m
Section 24: entry-level-developing-a-powerpoint-presentation6 videos

select-a-presentation-type

3m

build-a-presentation

4m

lay-out-a-presentation

4m

edit-text

7m

view-and-navigate-a-presentation

6m

module-summary-getting-started-with-powerpoint

1m
Section 25: advanced-text-editing4 videos

module-introduction-advanced-text-editing

2m

format-characters

6m

format-text-boxes

4m

format-paragraphs

7m
Section 26: adding-graphical-elements-to-your-presentation3 videos

insert-shapes

3m

insert-images

12m

insert-wordart

2m
Section 27: adding-smartart-to-a-presentation3 videos

create-smartart

4m

change-the-look-and-feel-of-smartart

2m

modify-smartart

2m
Section 28: modifying-objects-in-your-presentation6 videos

arrange-objects

3m

edit-objects

5m

format-objects

3m

group-objects

1m

animate-objects

3m

module-summary-advanced-text-editing

2m
Section 29: adding-tables-to-your-presentation4 videos

module-introduction-enhancing-the-appearance-of-a-presentation

1m

format-a-table

3m

insert-a-table-from-other-microsoft-office-applications

3m

create-a-table

5m
Section 30: adding-charts-to-your-presentation4 videos

format-a-chart

3m

create-a-chart

3m

manipulate-a-chart

3m

insert-a-chart-from-microsoft-excel

3m
Section 31: add-media-to-a-presentation2 videos

add-audio-to-a-presentation

4m

add-video-to-a-presentation

5m
Section 32: work-with-animations-and-transitions3 videos

customize-animations

4m

timing-groups-and-motion-paths

3m

module-summary-enhancing-the-appearance-of-a-presentation

2m
Section 33: preparing-to-deliver-your-presentation6 videos

module-introduction-preparing-to-deliver-a-presentation

2m

apply-transitions

5m

review-compatibility-and-accessibility

5m

deliver-your-presentation

3m

review-your-presentation

7m

print-your-presentation

3m
Section 34: collaborate-on-a-presentation4 videos

add-comments-to-a-presentation

6m

review-a-presentation

5m

manage-a-presentation

4m

store-and-share-presentations-on-the-web

7m
Section 35: customizing-design-templates4 videos

create-and-manage-sections

6m

add-headers-and-footers

2m

modify-slide-masters-and-slide-layouts

8m

modify-the-notes-master-and-the-handout-master

4m
Section 36: customizing-a-slide-show6 videos

set-up-a-slide-show

5m

create-a-custom-slide-show

3m

add-hyperlinks-and-action-buttons

2m

module-summary-preparing-to-deliver-a-presentation

1m

annotate-a-presentation

4m

record-a-presentation

3m
Section 37: entry-level-get-started-with-microsoft-3656 videos

microsoft-365-subscriptions

3m

about-microsoft-365

4m

microsoft-365-faqs

7m

finding-help-and-changing-settings

4m

navigating-your-account

6m

using-desktop-office-apps

3m
Section 38: entry-level-office-365-applications5 videos

introduction-to-word

4m

introduction-to-excel

2m

introduction-to-powerpoint

2m

introduction-to-outlook

2m

optional-introduction-to-access-publisher-and-onenote

3m
Section 39: entry-level-office-365-services2 videos

introduction-to-onedrive

2m

optional-introduction-to-microsoft-teams

4m
Section 40: entry-level-get-started-with-onedrive2 videos

collaborate-using-onedrive

5m

add-and-organize-files-in-onedrive

4m
Section 41: entry-level-get-started-with-delve3 videos

access-items-with-delve

4m

share-with-delve

3m

module-summary-getting-started-with-microsoft-word

2m
Section 42: entry-level-getting-started-with-word4 videos

create-a-word-document

6m

module-introduction-getting-started-with-word

1m

create-a-document-using-a-template

6m

identify-the-components-of-the-word-interface

11m
Section 43: entry-level-use-document-views-and-help2 videos

help-features

8m

use-document-views

14m
Section 44: entry-level-editing-a-document3 videos

navigate-and-select-text

12m

modify-text

11m

find-and-replace-text

10m
Section 45: entry-level-proofing-a-document3 videos

module-summary-getting-started-with-microsoft-365

1m

check-spelling-and-grammar

13m

other-proofing-tools

14m
Section 46: formatting-text4 videos

module-introduction-working-with-text-tables-and-lists

1m

align-text-using-tabs

5m

display-text-as-list-items

3m

apply-character-formatting

7m
Section 47: formatting-text-and-paragraphs4 videos

control-paragraph-layout

8m

apply-borders-and-shading

4m

manage-formatting

5m

apply-styles

5m
Section 48: adding-tables4 videos

insert-a-table

6m

modify-a-table

6m

format-a-table

4m

convert-text-to-a-table

4m
Section 49: working-with-tables-and-cell-layout2 videos

control-cell-layout

3m

sort-table-data

3m
Section 50: managing-lists4 videos

sort-a-list

4m

renumber-a-list

2m

module-summary-working-with-text-tables-and-lists

1m

customize-a-list

6m
Section 51: adding-graphics4 videos

module-introduction-working-with-graphics

2m

insert-symbols-and-special-characters

7m

add-images-to-a-document

6m

resize-an-image

5m
Section 52: using-images-in-a-document3 videos

adjust-image-appearance

5m

integrate-pictures-and-text

3m

insert-and-format-screenshots

2m
Section 53: using-shapes-in-documents2 videos

draw-shapes

5m

modify-shapes

3m
Section 54: text-boxes-and-pull-quotes2 videos

create-text-boxes-and-pull-quotes

3m

format-text-boxes-and-pull-quotes

3m
Section 55: word-art-and-complex-illustrations3 videos

add-wordart-and-other-text-effects

4m

create-complex-illustrations-with-smartart

5m

module-summary-working-with-graphics

2m
Section 56: using-accessibility-features3 videos

module-introduction-finalizing-a-document

1m

check-accessibility

3m

using-accessibility-features

2m
Section 57: set-save-options3 videos

manage-additional-file-types

4m

file-formats-and-compatibility

4m

autosave-and-autorecover

2m
Section 58: controlling-page-appearance3 videos

apply-a-page-border-and-color

3m

add-a-watermark

3m

control-page-layout

4m
Section 59: controlling-text-flow4 videos

control-paragraph-flow

3m

insert-section-breaks

4m

insert-columns

2m

link-text-boxes-to-control-text-flow

3m
Section 60: add-captions-and-references-to-a-document3 videos

add-captions

4m

add-bookmarks

3m

add-cross-references

2m
Section 61: add-hyperlinks-footnotes-and-endnotes-to-a-document2 videos

add-hyperlinks

4m

insert-footnotes-and-endnotes

2m
Section 62: add-citations-a-bibliography-and-a-table-of-contents4 videos

insert-a-bibliography

2m

add-citations

4m

insert-a-table-of-contents

3m

module-summary-finalizing-a-document

2m
Section 63: modify-user-information-and-share-a-document3 videos

module-introduction-collaborating-on-documents

1m

share-a-document

7m

modify-user-information

4m
Section 64: work-with-comments-and-compare-changes2 videos

compare-document-changes

6m

work-with-comments

7m
Section 65: review-a-document-and-implement-changes3 videos

review-a-document

7m

module-summary-collaborating-on-documents

1m

merge-document-changes

7m