Course Overview

Interface and Navigation - Learn Excel 365 guides you through essential Excel interface elements, focused on seamlessly enhancing your navigation and editing skills within worksheets. This course introduces various mouse cursor functionalities such as selecting cells precisely and adjusting columns easily. You will explore the effective use of the Backstage View, a central hub for managing your workbooks, saving, printing, and sharing files efficiently. This course also covers methods for saving files in various formats, such as CSV and PDF, utilizing OneDrive for cloud collaboration, and leveraging email and PDF sharing capabilities.

By completing this training, you will gain practical skills that improve your productivity in Excel. You will learn to navigate complex datasets using features such as the split screen tool for simultaneous viewing of different spreadsheet sections. In addition, discover how to effectively print large documents by adjusting page layout and print preview settings, including scaling and orientation changes. The proficiency of these tools helps you manage documents effectively, from viewing large data to sharing files and collaborating in real-time. With this knowledge, you’ll gain the skills to handle file management tasks efficiently, improving workflow and keeping data well-organized.

Learning Objectives:

In this course, you will learn how to:

• Utilize various Excel mouse cursors for efficient navigation and editing.
• Explore the Backstage view for file management and customization.
• Save Excel files in multiple formats (XLSX, CSV, PDF) for diverse needs.
• Efficiently open Excel files using various methods and keyboard shortcuts.
• Manage large datasets using Excel's split-screen tool for improved analysis.
• Effectively print large Excel documents by adjusting page layout settings.
• Use Excel's 'New Window' feature for simultaneous document viewing.
• Create and manage custom views to filter and print specific datasets.