Curso Microsoft excel básico (Ver. 2019).

Excel is an indispensable tool for a wide range of activities, especially in finance, but its applications extend far beyond. It's excellent for organization and tracking information, such as sales lists, invoicing activities, and more. Excel empowers you to perform statistical analysis and scientific calculations on large datasets.

This course is designed for beginners, providing a comprehensive introduction to the Excel interface and the fundamental skills needed to start building powerful spreadsheets.

Course Outline:

Module 0: Excel Fundamentals & Office Suite

• Office 365 vs. Office 2019: Understand the key differences between these popular Microsoft Office versions.
• New Features: Explore the latest additions to Excel, Word, and PowerPoint, including SVG file insertion, linked notes and comments, and the new search bar.
• Downloadable Files: Access helpful resources like "Dar un paseo" (Getting Started) and an introduction to formulas.
• Basic Operations:
  • Insert or delete cells, rows, and columns with ease.
  • Select and manipulate cell content effectively.
  • Freeze panes to keep rows and columns visible while scrolling.
  • Show/hide rows and columns for focused data management.
  • Split text into multiple columns.
  • Create sequential date lists.
  • Create formulas for calculations.
  • Utilize VLOOKUP for efficient data retrieval.
• Excel Basics - Part 1: Introduction
  • Understanding the Interface: Learn about cells, ranges, columns, rows, active cell, name box, formula bar, and the ribbon.
  • Essential Functions: Save, AutoRecover, and change language.
  • Defined Names: Utilize defined names for easier formula creation.
  • Paste Special: Master paste special options for flexible data transfer.
  • Data Management: Insert blank rows, copy ranges, delete/add rows/columns quickly.
  • Undo/Redo: Efficiently manage changes with undo and redo functions.
  • Working with Worksheets & Windows: Optimize your workspace.
  • Sorting & Filtering: Use the Sort & Filter groups to organize data.
  • Find & Select: Quickly locate and select specific data.
  • Data Tools: Explore the Data Tools group for data manipulation.
  • Cell Formatting: Enhance data presentation with various cell formats.
  • Keyboard Shortcuts: Boost your productivity with essential keyboard shortcuts.
  • Shapes & Images: Add visual elements to your spreadsheets.
  • Autofill: Quickly populate data series.
  • Comments & Links: Add notes and create hyperlinks.
  • References: Understand cell referencing.
  • Conditional Formatting: Highlight data based on specific criteria.
  • Tables & Ranges: Organize data using tables and ranges.
  • Print Views: Customize your spreadsheet layout for printing.
  • Charts: Visualize data with various chart types.
  • Forms: Create user-friendly data entry forms.
• Practical Examples:
  • Update Dropdowns: Keep your data lists current.
  • Calculate IVA (VAT): Implement VAT calculations.
  • Calculate Percentages: Perform percentage calculations.
  • Delete Blank Rows: Clean up your data.
  • Insert Page Numbers: Add page numbers to your documents.
  • Interleave Blank Rows: Improve readability.
  • Numbered Lists: Create professional numbered lists.
  • Improve Charts: Enhance chart aesthetics and clarity.
  • Hide Sheets: Organize your workbook.
  • Alphabetical Sorting: Sort data alphabetically.
  • Remove Leading Zeros: Format numbers correctly.
  • Highlight Alternating Rows: Improve data visibility.

Lifetime Support Included!