Microsoft Office - Excel: In 30 Minutes: (Intermediate 7 of 11) Analyzing Data with Tables and Formatting

Content
2 modules
Difficulty
Intermediate
Rating
Course Length
32 mins
Instructor
Pantry of Knowledge

Description

Learn to create and modify tables and apply advanced Conditional Formatting to a spreadsheet in Excel 2019 or Excel 365—all in under 30 minutes! When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. Our Excel in 30 Minutes series can help you get started. By the end of this course, you will be able to create and modify tables, and apply advanced Conditional Formatting to a spreadsheet. This course is one of eleven 30-minute courses. Take the full series and you will have completed our Bigger Brains Mastering Excel 2019: Intermediate course.

Objectives

  • Create and modify a new table from a dataset
  • Apply Table Styles to modify table formatting
  • Add formulas to a table using standard functions and the Total Row
  • Add formulas to a table using standard functions and the Total Row
  • Customize conditional formatting using the Rules Manager
  • Determine which cells to format based on formulas

Certificate

By completing/passing this course, you will attain the certificate POK Microsoft Skills Certificate

Learning Credits

CEU
0.5

Badges

{{ badge.name }}

{{ vm.helper.t('lup.gamification.value') }}

{{ badge.points }} {{ vm.helper.t('lup.gamification.points') }}

{{ vm.helper.t('lup.gamification.achieved_for_selected_score_and_over')}}

{{ vm.percentage_badges[vm.selected_badge].greater_than_or_equal }}%

{{ badge.name }}

{{ vm.helper.t('lup.gamification.value')}}

{{ badge.points }} {{ vm.helper.t('lup.gamification.points') }}

{{ vm.helper.t('lup.gamification.achieved') }}

{{ vm.helper.t('lup.gamification.learning_awards.on_course_completion') }}
1.
Microsoft Office - Excel: In 30 Minutes: (Intermediate 7 of 11) Analyzing Data with Tables and Formatting
{{ vm.helper.t('courses.scorm') }}
2.
Microsoft Office - Excel: In 30 Minutes: (Intermediate 7 of 11) Analyzing Data with Tables and Formatting Survey
{{ vm.helper.t('courses.survey') }}
Currently no reviews submitted

Shopping Cart

Your cart is empty