Microsoft Office - Excel: Mastering Intermediate 365

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

Description

Become proficient in using the world’s most popular software tool for organizing and analyzing data. When you master Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course builds on your existing Excel knowledge and teaches you how to manage data, charts, and tables, and how to use powerful tools such as Pivot Tables, Pivot Charts, Slicers, Timelines, and more.    This is our most requested training course! As you learn to use Excel effectively, you will start to see how powerful it is in managing small or large datasets. If you are comfortable with the basics of Excel, let our Microsoft Certified Trainer Kathy Jones walk you through more advanced topics that will take your spreadsheets to the next level and help you to be more efficient in analyzing your data. Topics covered include: Working with named ranges; Inserting functions; Using advanced sorting and filtering techniques; Inserting Tables; Applying advanced Conditional Formatting; Inserting charts and graphics; Applying advanced charting tools; Working with Pivot Tables, Pivot Charts, Slicers, and Timelines; Over five hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

Objectives

  • Create and use named ranges
  • Insert functions into spreadsheets including: Date and Time functions, Logical functions, Text functions, Math functions, Database functions, Subtotals, and nested functions
  • Sort and filter column data
  • Create and modify tables, and apply advanced Conditional Formatting
  • Create and modify charts and graphics
  • Apply advanced charting tools
  • Create a Pivot Table to group and summarize data
  • Apply advanced Pivot Table features, create a Pivot Chart, and filter data using Slicers and Timelines

Certificate

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

Learning Credits

CEU
5.25

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: Mastering Intermediate 365
{{ vm.helper.t('courses.scorm') }}
2.
Microsoft Office - Excel: Mastering Intermediate 365 Survey
{{ vm.helper.t('courses.survey') }}
Currently no reviews submitted

Shopping Cart

Your cart is empty