Search Our Content Library
- Course Library
- /
- Microsoft
- /
- Excel 2019
Learning Path Courses:
-
Excel 2019 Beginners
The material presented in this course helps you gain an understanding of the following topics: Getting Started with Excel Creating Workbooks and Using Templates Entering Data Excel Formula Basics Adjusting a Worksheet Formatting and Aligning a Worksheet Using Cell Styles and Themes Inserting Objects and Graphics Proofing a Worksheet Printing an Excel File Managing Worksheets Navigating and Viewing Excel Files Approximate Duration: 5 hours 30 minutes -
Excel 2019 Intermediate
The material presented in this course helps you gain an understanding of the following topics: Linking Workbooks and Worksheets Working with Range Names Sorting and Filtering Range Data Analyzing and Organizing with Tables Using Conditional Formatting Displaying Data Graphically Understanding PivotTables, PivotCharts, and Slicers Working with Advanced PivotTables and PowerPivot Features Approximate Duration: 4 hours 40 minutes -
Excel 2019 Advanced
The material presented in this course helps you gain an understanding of the following topics: Customizing Excel Analyzing Data with Logical Functions Working with Lookup Functions Using Text Function Working with Date and Time Functions Formula Auditing What-if Analysis Tools Worksheet and Workbook Protection Automating with Macros Working with Form Controls Ensuring Data Integrity Collaborating in Excel Importing and Exporting Data to a Text File Approximate Duration: 3 hours 58 minutes
Like what you see? We’d love to give you a guided tour of the best Pinnacle has to offer.
Book Your DemoTrusted By Leaders
Before You Go
Understanding the Manufacturing & Construction Skills Gap
We went deep into the latest market research and created a resource to give you fresh insight into your recruitment challenges.