$297beginner

Microsoft 365 Excel: Part 1

Name: Microsoft 365 Excel: Part 1
Price: 297.00 USD
Availability: InStock

A comprehensive beginner's course on Microsoft 365 Excel. You will learn how to navigate the Excel interface, create and save workbooks, work with formulas and functions, format and modify worksheets, configure print settings, manage large workbooks, and customize the Excel environment to suit your workflow. No prior Excel experience is required.

28 lessons6 modules600 minutes

What you'll learn

Identify the basic components of the Excel interface including the ribbon, Name Box, Formula Bar, and worksheet tabs
Create, save, and manage Excel workbooks in various file formats
Use Excel's built-in help and search features to find answers and guidance
Build formulas using mathematical operators, cell references, and the correct order of operations
Apply common functions such as SUM, AVERAGE, MAX, and MIN using AutoSum and the Insert Function dialog box
Manipulate worksheet data using cut, copy, paste, AutoFill, Flash Fill, and drag-and-drop
Insert, delete, resize, hide, and unhide rows and columns
Sort and filter data to organize and refine worksheet displays

Customize General, Language, and Formula Options The **Excel Options dialog box** (opened via **File → Options**) is the central hub for personalizing how Excel looks and behaves. It contains 10 categories. The General Category The General category controls overall appearance and default behaviors: **Show Mini Toolbar on selection** – Toggles the mini toolbar on/off when selecting cells. **Enable Live Preview** – Shows formatting changes before you apply them. **ScreenTip style** – Controls the detail level of command tooltips. **Default font and font size** – Sets the starting font for all new workbooks. **Default view for new sheets** – Chooses the view (Normal, Page Layout, etc.) for new sheets. **Include this many sheets** – Sets the number of worksheets in each new workbook (default: 1). **User name** – The name associated with your copy of Microsoft Office. **Office theme** – Choose between Colorful, Dark Gray, and White themes. The Language Category Set the **display language** (interface buttons and menus) and **authoring/proofing language** (spell check and grammar). If you work in multiple languages, you can add additional editing languages here. The Formulas Category Customize how formulas behave: **Calculation options** – Choose *Automatic* (default), *Automatic Except for Data Tables*, or *Manual*. **Working with formulas** – Set R1C1 reference style, enable/disable Formula AutoComplete. **Error Checking** – Toggle background error checking and change the color

…

Microsoft 365 Excel: Part 1

What you'll learn

Preview a lesson

Curriculum

Lesson 1: Getting Started with Excel

Lesson 2: Working with Data

Lesson 3: Modifying a Worksheet

Lesson 4: Printing Workbook Contents

Lesson 5: Managing Large Workbooks

Lesson 6: Customizing the Excel Environment

Reviews