Microsoft Excel Basics for Beginners - Learn Excel Fundamental Skills for Business and Work Smarter | Luis Carlos | Skillshare

Microsoft Excel Basics for Beginners - Learn Excel Fundamental Skills for Business and Work Smarter

Luis Carlos, Engineer, Web Developer and Instructor

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
28 Lessons (2h 1m)
    • 1. Trailer

      1:30
    • 2. Introduction to Microsoft Excel - What you will learn

      1:56
    • 3. Excel interface overview

      4:25
    • 4. Excel ribbon - How works and how to customize

      3:50
    • 5. How use and edit Quick access toolbar

      1:38
    • 6. Excel Workbooks - Create, Open and Save files

      5:18
    • 7. Working with Worksheets - Add, delete and change name

      2:44
    • 8. Automatic data with autofill - save time using this tool

      5:25
    • 9. Rows and columns - Add and delete

      4:07
    • 10. Hide & Unhide Rows/Colums and Worksheets

      4:20
    • 11. Change row and column size

      3:29
    • 12. Wrap, shrink and merge text

      4:05
    • 13. Practical exercise using Font tools

      3:27
    • 14. Format painter tool - Another powerfull tool to save time

      2:46
    • 15. Format Numbers Tool - Date and Time Format

      5:00
    • 16. Identify and Remove Duplicates Values

      4:10
    • 17. Sort and Filter Tools

      14:28
    • 18. Cell references to link data - Relative, absolute and mixed

      8:09
    • 19. Excel Formulas - How to create a formula using math operators

      4:43
    • 20. Use Functions in Excel - Syntax used to create functions

      4:07
    • 21. Add Numbers with Sum Function

      2:34
    • 22. Average Function for cells ranges average calculation

      1:35
    • 23. How to use Statistical Functions Min and Max

      2:00
    • 24. Count and CountIf Functions

      5:31
    • 25. Exercise with Logical Functions IF, OR and AND for single and multiple conditions

      7:10
    • 26. Conditional Addition with Sumif and Sumifs

      3:54
    • 27. Extract Data using Vlookup Reference Function

      6:08
    • 28. Hlookup Function to Extract Data

      2:43

About This Class

8f74216c

Hello, my name is Luis Carlos and I will be the instructor in this class of Microsoft Excel.

This class is made for beginners, being divided into different sections.

In the first part you will learn the interface excel and how it is divided. The ribbon customization and quick access toolbar will be another important point that allows to adapt the working environment to the needs of the user.

In a second part we will learn how to create and open excel files, add, delete and change the name of worksheets and in a third part of the course we learn to insert data manually and automatically and work with cell and text formatting tools.

The last part will be dedicated to formulas and functions that will be an important step to work the data automatically in the worksheet.

To follow all the lessons, is available a file exercises.xlsx in the  project section that can be used by the students to make all exercises made in the videos.

This class is compatible with the latest versions of Microsoft Excel (2007 / 2010 / 2013 / 2016)

List of main topics:

  • Excel interface
  • Customizing the Excel Quick Access Toolbar
  • Understanding the Structure of an Excel Workbook(anatomy)
  • Customize ribbon and quick access toolbar
  • Create, Save and open an Excel Document
  • Add, rename, delete worksheet
  • Enter text manually and automatically with autofill tool
  • Format data
  • Wrap, shrink and merge text
  • Format painter tool
  • Format numbers - Change format to date and time 
  • Cell references - relative, absolute and mixed
  • Create formulas using logical operators
  • Functions  syntax - Learn and apply the main used functions

28

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Luis Carlos

Engineer, Web Developer and Instructor

Currently, I am an exciting Engineer and Trainer , who loves to learn and share knowledge and new experiences.

As Trainer participated in many projects directed to student in the areas of math, computer science, new technologies and web development . Several years of training helped me developed many skills that contribute to the personal development of each people.

You can follow some of my articles in my website where i share some tutorials in the area of new technol...

See full profile

Report class