Microsoft Excel da zero a intermedio

Unlock Microsoft 365 Certified: Fundamentals Certification with Excel Mastery

Boost Productivity with Microsoft Excel: A Comprehensive Course

This course provides invaluable skills to enhance business productivity. Beyond Microsoft Excel video tutorials, the final section focuses on preparing for the official Microsoft 365 Certified: Fundamentals certification exam. The exam fee is minimal, and you'll benefit from 125 articles and 1875 multiple-choice quizzes with detailed explanations for every answer.

Course Outline

• Objectives: Learn to effectively use Excel for both desktop and online work, enabling seamless remote collaboration.
• Resources:
  • 1673-page eBook: In-depth coverage of professional PC usage (ICDL Module 1).
  • 170 PowerPoint Slides: Visually rich, downloadable, and clickable slides with indexes, links to relevant resources (Microsoft Copilot, Support, Blog, Community), and descriptive Word documents.
  • 2470 Excel Quizzes: 15 questions per topic, with scoring, explanations, and correct answers.

Detailed Program

Block A: Excel Fundamentals - Cells and Ranges

1. Managing Cells and Ranges:
   • Selecting cells, rows, and columns.
   • Navigation techniques (dragging, name box, Ctrl+click).
   • Keyboard shortcuts for efficient selection.
2. Inserting, Deleting, and Resizing:
   • Adding, deleting, and adjusting row/column dimensions.
   • Cell size adjustments.
3. Cell Formatting:
   • Formatting options (font, alignment, number, styles).
   • Conditional formatting (based on values, text, duplicates).
   • Data bars, color scales, and icon sets.
   • Borders and gridlines.
4. Cell and Range Naming:
   • Defining names for cells and ranges.
   • Using names in formulas.

Block B: Data Entry in Excel

1. Cell Modes:
   • Ready, Enter, Edit, Pointer modes.
2. Data Input:
   • Numeric data (without characters, formatting, text).
   • Date and time formatting.
   • Percentage input.
   • Dropdown lists and data validation.

Block C: Formulas and Functions in Excel

1. Formula Creation & Operations:
   • Arithmetic operators, order of operations.
   • Entering formulas, referencing cells and ranges.
   • Calculations across multiple sheets and files.
   • Formula auditing (error checking, tracing, evaluation).
2. Essential Excel Functions:
   • Logical: SE, ALTR, VERO, FALSO, NON, E, O, PIÙ, LET, ARRAY, SCAN, PER, PIERGA, SWITCH, XOR.
   • Text: CONCAT, TESTO, SINISTRA, DESTRA, STRINGA, RICERCA, TROVA, UNISCI, MAIUSC, MINUSC, IDENTICO, CODICE, VALORE, ESTRAI.
   • Date & Time: DATA, ORA, OGGI, ANNO, MESE, GIORNO, DATA.VALORE, ORA.VALORE, DATA.ORA.
   • Math: SOMMA, MEDIA, MAX, MIN, CONT.NUMERI, CONT.VALORI, CONT.SE, SOMMA.SE, MEDIA.SE, MAX.SE, MIN.SE, CONTA.SE, MEDIA.PIU, SOMMA.PIU, PRODOTTO, QUOZIENTE, POTENZA, RADICE, ARCOCOSENO, ARCOSENO, ARCTANGENTE.
   • Lookup & Reference: CERCA.VERT, INDICE, CONFRONTA, INDICE.E, CONFRONTA.E, DEVI, INDICE.R, CONFRONTA.R.
   • Math & Trig: ARCOCOSENO, ARCOSENO, ARCTANGENTE, COS, SIN, TAN, ATAN, COS, SIN, TAN, ATAN, RADICE, POTENZA, LOG, EXP.
   • Statistical: DEV.ST, VAR.ST, `