Companies Home Search Profile
TrainingHub TrainingHub

Cert Prep: Excel Associate - Microsoft Office Specialist for Microsoft 365 Apps

Focused View

Jennifer McBee

4:01:57

0 View
  • 01 - Prove your Excel skills with a MOS certification.mp4
    00:53
  • 02 - Who should take this course.mp4
    01:10
  • 03 - About the exercise files.mp4
    00:36
  • 04 - About the challenges.mp4
    00:38
  • 01 - Different kinds of Microsoft Office Specialist certifications.mp4
    02:52
  • 02 - Prepare for the test and review learning objectives.mp4
    05:59
  • 01 - Import TXT data into a new or existing workbook.mp4
    04:35
  • 02 - Import data from online sources.mp4
    04:45
  • 03 - Search for data within a workbook.mp4
    04:56
  • 04 - Navigate to named cells, ranges, or workbook elements.mp4
    06:14
  • 05 - Insert and remove hyperlinks.mp4
    03:26
  • 06 - Format worksheets and workbooks.mp4
    04:26
  • 07 - Customize headers and footers.mp4
    04:03
  • 08 - Manage the Quick Access Toolbar.mp4
    04:17
  • 09 - Display and modify worksheets in different views.mp4
    06:01
  • 10 - Modify built-in workbook properties.mp4
    02:33
  • 11 - Inspect and export workbooks.mp4
    05:54
  • 12 - Configure print settings.mp4
    05:54
  • 13 - Manage comments and notes.mp4
    04:52
  • 14 - Challenge Manage worksheets and workbooks.mp4
    02:30
  • 15 - Solution Manage worksheets and workbooks.mp4
    09:41
  • 01 - Paste data using special paste options.mp4
    05:28
  • 02 - Fill cells by using AutoFill.mp4
    04:20
  • 03 - Insert and delete columns, rows, and cells.mp4
    03:26
  • 04 - Format cells and ranges.mp4
    05:28
  • 05 - Generate random and sequential data using Functions.mp4
    04:55
  • 06 - Apply styles to cells and ranges.mp4
    07:49
  • 07 - Define and reference named ranges.mp4
    03:39
  • 08 - Insert sparklines.mp4
    03:28
  • 09 - Summarize data visually with built-in conditional formatting.mp4
    03:24
  • 10 - Challenge Manage data, cells, and ranges.mp4
    00:32
  • 11 - Solution Manage data, cells, and ranges.mp4
    04:46
  • 01 - Create and format tables.mp4
    05:23
  • 02 - Modify tables.mp4
    03:31
  • 03 - Filter and sort table data.mp4
    03:50
  • 04 - Challenge Manage tables and table data.mp4
    00:32
  • 05 - Solution Manage tables and table data.mp4
    03:18
  • 01 - Insert relative, absolute, and mixed references.mp4
    06:03
  • 02 - Use structured references in formulas.mp4
    04:56
  • 03 - Using the AVERAGE(), MAX(), MIN(), and SUM() functions.mp4
    02:32
  • 04 - Count cells using the COUNT(), COUNTA(), and COUNTBLANK() functions.mp4
    02:51
  • 05 - Perform conditional operations using the IF() function.mp4
    04:18
  • 06 - Sort data and return unique values using the SORT() and UNIQUE() functions.mp4
    05:05
  • 07 - Format text using the RIGHT(), LEFT(), and MID() functions.mp4
    03:56
  • 08 - Format text using UPPER(), LOWER(), and LEN() functions.mp4
    02:05
  • 09 - Format text using the CONCAT() and TEXTJOIN() functions.mp4
    03:53
  • 10 - Challenge Perform operations using formulas and functions.mp4
    00:34
  • 11 - Solution Perform operations using formulas and functions.mp4
    05:21
  • 01 - Create and modify charts.mp4
    05:31
  • 02 - Add and modify chart elements.mp4
    04:24
  • 03 - Format charts.mp4
    04:30
  • 04 - Challenge Manage charts.mp4
    00:32
  • 05 - Solution Manage charts.mp4
    04:17
  • 01 - Challenge Full-length practice exam.mp4
    00:52
  • 02 - Solution Full-length practice exam.mp4
    30:13

    • Description

    If you want to earn the Excel Associate – Microsoft Office Specialist certification for Microsoft 365 Apps, this course can help you prepare. Certified MOS Master Instructor Jennifer McBee goes over the benefits of earning a MOS certification, then gives you an overview of the exam. Jennifer steps through more than a dozen useful techniques to manage worksheets and workbooks. She shows you ways to manage data cells and ranges, as well as tables and table data. Jennifer explains how to perform a variety of operations using formulas and functions, such as using structured references in formulas, counting cells, performing conditional operations, and much more. After covering how to create and modify charts, add and modify chart elements, and format charts, she finishes up with a full-length practice exam to help you get ready to take the exam. Plus, Jennifer gives you practical, hands-on challenges and strategies to solve the challenges, for each chapter in the course!

    More details

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category

    Excel

    Jennifer McBee
    Jennifer McBee
    Instructor's Courses
    Linkedin Learning
    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.
    • language english
    • Training sessions 55
    • duration 4:01:57
    • English subtitles has
    • Release Date 2024/09/20

    Courses related to Excel

    Excel: Dashboards for Beginners
    Linkedin LearningExcel: Dashboards for Beginners
    45:55
    01/05/2023
    Master Microsoft Excel Functions and beyond
    SkillShareMaster Microsoft Excel Functions and beyond
    1:23:06
    02/20/2024
    QuickBooks Pro, QuickBooks Online, and Excel 5-Course Bundle
    Udemy Simon Sez IT
    Simon Sez IT
    QuickBooks Pro, QuickBooks Online, and Excel 5-Course Bundle
    30:12:22
    11/30/2022