Corso di Microsoft 365 Excel Desktop Completo

Master Microsoft 365 Excel Desktop: A Comprehensive Guide for All Skill Levels

Unlock the power of Microsoft 365 Excel Desktop with this step-by-step course! Designed for learners of all levels, this program follows a progressive learning path, building your skills from fundamental concepts to advanced techniques. Learn to confidently manage and analyze data using Excel.

Course Overview:

This course covers everything you need to know to master Excel, including:

Module 1: Excel Fundamentals & Getting Started

• Introduction to Microsoft 365: Learn about Microsoft 365, installation, free usage, and subscription creation.
• Navigating Microsoft 365: Explore both the Desktop and Web versions of Excel.
• Understanding the Excel Interface: Master the worksheet, including the ribbon, workbook, sheet dimensions, cells, active cell, formula bar, name box, and cell types (text, numbers).
• Cell Formatting: Learn about cell size, standard width/height, character count, and cell addressing (single cells, ranges, adjacent ranges, non-adjacent ranges).

Module 2: Creating & Managing Workbooks

• Workbook Basics: Learn how to create, save, and open Excel workbooks.
• Saving & Closing: Master saving workbooks with different options (Save, Save As) and closing workbooks.

Module 3: Working with Tables

• Creating Tables: Learn to create and format tables within Excel.
• Data Entry: Efficiently input text, numbers, and decimal values into cells.
• Text Handling: Manage text overflow, wrap text, and adjust orientation.
• Column & Row Manipulation: Resize columns and rows to fit your data.
• Table Formatting: Apply borders, merge and center cells, and use "Block Selection" to keep key columns and rows visible.

Module 4: Selecting & Manipulating Data

• Selecting Ranges: Master selecting adjacent and non-adjacent cells using both the mouse and keyboard shortcuts.

Module 5: Table Enhancements

• Table Formatting: Apply borders, merge cells, and utilize "Block Selection" for enhanced table management.

Module 6: Data Formatting & Styling

• Customizing Tables: Apply different font styles, number formats, and alignment options.

Module 7: Essential Formulas

• Understanding Formulas: Learn the components of a formula: equals sign (=), parentheses, operators, and semicolons (;).
• Creating Formulas: Build formulas using the mouse and keyboard shortcuts.
• Mathematical Functions: Explore fundamental functions like SUM, MAX, MIN, AVERAGE, MEDIAN, COUNT, ABS, ROUND, and more.

Module 8: Trigonometric & Logical Functions

• Trigonometric Functions: Utilize functions like PI, SIN, COS, TAN, and their inverses.
• Logical Functions: Master functions like IF, AND, OR, and SUMIF/COUNTIF for conditional calculations.

Module 9: Text & Date Functions

• Text Functions: Extract, concatenate, and manipulate text using functions like LEFT, RIGHT, CONCATENATE, LEN, UPPER, LOWER, and more.
• Date Functions: Work with dates using functions like DATE, DAY, MONTH, and YEAR.

Module 10: Financial Functions

• Financial Functions: Calculate interest rates and loan payments using functions like RATE.

Module 11: Percentage & Statistical Functions

• Percentage Functions: Calculate percentage ranges and variations.

Module 12: Advanced Formula Techniques

• Building Complex Formulas: Combine mathematical functions, operators, and cell references to create powerful calculations.
• AutoFill: Quickly fill columns and rows with automatic data.

Module 13: Visual Enhancements

• Cell Color & Styles: Apply fill colors and cell styles for visual appeal and data highlighting.
• Charts: Create various chart types to visualize your data.
• Images & Shapes: Insert images and shapes to enhance your spreadsheets.

Module 14: Data Management & Analysis

• Data Sorting & Filtering: Sort and filter data to quickly find specific information.
• Hyperlinks: Insert hyperlinks to connect to websites and other files.
• Comments & Text Boxes: Add comments and text boxes to provide context and notes.
• Text Splitting: Split text into multiple columns based on delimiters.
• Removing Duplicates: Identify and remove duplicate entries.
• **Print Area