Nuevo Curso de Excel - Capítulo 0, Introducción para principiantes 🎓 Dostin Hurtado

Introduction to Excel Course

Overview of the Course

• Dostin Hurtado introduces the course, assuring that by its end, participants will confidently use Excel.

• This is Chapter Zero, serving as an introduction to basic functionalities in Excel. Those already familiar with Excel are encouraged to skip to Chapter 1.

Opening Excel

• To check if Excel is installed, users should click on "Start" and search for "Excel."

• An alternative method involves using the keyboard shortcut: press the Start key + R, type "Excel," and hit Enter.

Accessing Online Versions

• Users can access a free online version of Excel through OneDrive, similar to Google Drive.

• The online version closely resembles the installed application; however, some features may differ slightly.

Using Different Platforms

Choosing Between Microsoft and Google Sheets

• For those interested in Google Sheets, it’s recommended to take a separate course focused on that platform.

• The course will primarily focus on Microsoft Excel but can be followed from any device—desktop or mobile.

Starting with a Blank Workbook

• Upon opening Excel, users may see options for new workbooks or templates; however, creating a blank workbook is often preferred for customization.

Understanding Basic Functions

Debunking Myths About Excel

• Many perceive Excel as complicated; however, it is user-friendly once understood.

• Key components include columns (labeled with letters), rows (numbered), and cells (identified by their coordinates).

Inputting Data into Cells

• Users can enter data directly into cells by selecting them or using the formula bar.

• It’s important to save documents regularly; otherwise, unsaved changes will be lost permanently.

Understanding Save and Save As in Excel

Key Concepts of Saving Documents

• The difference between "Save" and "Save As": "Save" updates the existing document, while "Save As" creates a new document if one does not already exist.

• To create a new workbook, click on "Examine," which opens the "Save As" window. Users should select a folder to save their work, such as creating an "Excel" folder on the desktop.

• Deleting content: Use the Delete key for removing selected cells or ranges; Backspace is effective for deleting single cells. Control + Z can undo deletions.

Saving Changes in Existing Documents

• After making changes, users can save by selecting "File" and then clicking on "Save." This action saves all modifications made to the document.

• If changes are made before closing, Excel prompts whether to save those changes. Choosing “Don’t Save” will discard any recent edits.

Managing Multiple Versions of Documents

• Using “Save As” allows users to create multiple versions of documents (e.g., my book vs. my book 2), facilitating better organization and version control.

• Understanding that “Save” only updates existing files while “Save As” generates new files is crucial for efficient file management.

Online vs Desktop Functionality

• Online versions of Excel offer automatic saving features, allowing real-time updates (e.g., typing automatically saves in OneDrive).

• While desktop versions require manual saving, they also provide an autosave option that typically works with online storage solutions like OneDrive.

Course Continuation Reminder