Excel 2021 Essential Training (Office 2021/LTSC)

Focused View

Jess Stratton

1:51:25

290 View

01.01-analyze_data_with_maximum_efficiency_in_excel.mp4

00:55

01.02-understanding_office_versions.mp4

01:29

02.01-navigate_excel_and_the_ribbon.mp4

04:12

02.02-create_open_and_save_a_file.mp4

02:38

02.03-enter_text_in_a_workbook.mp4

03:34

03.01-format_text_in_excel.mp4

02:54

03.02-autofill_and_edit_text.mp4

04:35

03.03-copying_and_deleting_cell_data.mp4

04:23

03.04-change_borders_and_background_colors.mp4

04:42

03.05-merge_cells.mp4

01:18

03.06-find_and_replace_text_and_values.mp4

04:21

03.07-work_with_cell_data_types.mp4

03:46

04.01-rename_insert_and_delete_a_sheet.mp4

02:23

04.02-move_and_group_sheets.mp4

02:53

05.01-adjust_column_and_row_height_and_width.mp4

05:04

05.02-delete_and_hide_rows_and_columns.mp4

03:36

05.03-insert_multiple_rows_and_columns.mp4

02:15

05.04-move_and_rearrange_rows_and_columns.mp4

03:07

05.05-freeze_columns_and_rows.mp4

03:54

06.01-build_a_formula_and_reference_cells.mp4

03:52

06.02-copy_formulas_and_use_autosum.mp4

03:29

06.03-create_a_formula_with_xlookup.mp4

04:18

06.04-split_text_into_two_columns.mp4

03:06

07.01-sort_data_in_excel.mp4

04:38

07.02-filter_data_with_a_drop-down_list.mp4

03:41

07.03-create_a_pivottable_to_group_and_summarize_data.mp4

05:27

07.04-use_conditional_formatting_to_see_trends.mp4

03:45

07.05-create_and_work_with_charts.mp4

05:12

08.01-print_a_workbook_or_sheet.mp4

05:28

08.02-share_a_workbook_or_sheet.mp4

02:01

08.03-protect_your_file_from_unwanted_changes.mp4

03:56

09.01-take_excel_further.mp4

00:33

Ex_Files_Excel_2021_EssT_upd.zip

Description

Excel, the popular spreadsheet program from Microsoft, is an essential tool for many professional roles. In this course, Jess Stratton shows you the ins and outs of the 2021 release. Jess begins with how to navigate Excel and how to create, open, and save a file. Next, she shows you how to enter, format, autofill, and edit text, as well as how to copy and delete cell data, merge cells, and more. Jess explains how to work with sheets, then dives into the myriad adjustments and customizations you can apply to rows and columns. Formulas are at the heart of Excel’s ability to perform text or number calculations, so Jess concludes by walking you through formulas and functions, including AutoSum and the very useful XLOOKUP.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Jess Stratton

Instructor's Courses

I am an instructor with LinkedIn Learning - With over 300 hours of instructional content on Lynda.com, my courses are specialized for businesses, home office, social media, and personal use focusing on Google Apps, Microsoft Office, home tech, and productivity/mobile apps. My writings have been in computer textbooks, and I have several published articles in industry magazines and major websites including Lifehacker.org. I'm a frequent speaker at large industry conferences about productivity, web, and Lotus Notes/Domino. I used to own and operate a successful brick-and-mortar boutique style computer learning facility in downtown shopping district. I LOVE my job. I get to help people be the very best at their own jobs.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.