Introduction to Microsoft Excel for Beginners (Office 365)

Focused View

E Learning Platform

7:29:25

25 View

1. Introduction to Microsoft Excel

1. Introduction.mp4

03:41

2. How to Use this Course.mp4

02:29

3. What is Microsoft Excel.mp4

02:03

4.1 Buying Microsoft 365 Personal Subscription.pdf

4. Buying Microsoft 365 Personal Subscription.mp4

03:44

2. Setting Up One Drive Application on Windows OS

1. Introduction to OneDrive Application.html

2. OneDrive Cloud with Microsoft.mp4

01:22

3. Downloading OneDrive Application on Windows.mp4

01:11

4. Setting Up OneDrive Application on Windows.mp4

03:15

5. Accessing Your OneDrive Cloud Online.mp4

02:23

6. Creating a Blank Excel Workbook on Cloud.mp4

01:28

7. Accessing OneDrive Folder Locally on Windows.mp4

02:10

3. Getting Familiar with the Excel Interface

1. Launching Microsoft Excel on Windows OS.mp4

03:16

2. Reviewing the Sign in Option and Account Section in Excel.mp4

03:50

3. Revewing the Excel Backstage.mp4

03:07

4. Creating a Blank Workbook with Microsoft Excel.mp4

02:50

5. What is a Workbook.mp4

01:46

6. General Review of the Excel Interface.mp4

01:22

4. Microsoft Excel Quick Access Toolbar

1. Reviewing the Quick Access Toolbar in Excel.mp4

01:22

2. Reviewing the Default Quick Access Toolbar Icons in Excel.mp4

02:28

3. Undo and Redo Command in Quick Access Toolbar.mp4

02:35

4. Adding Commonly Used Commands on the Quick Access Toolbar.mp4

02:35

5. Customizing the Quick Access Toolbar.mp4

02:09

6. Rearranging the Command Icons in the Quick Access Toolbar.mp4

01:33

7. Placing the Quick Access Toolbar Below the Ribbon Bar.mp4

02:35

8. Removing Commands from Quick Access Toolbar.mp4

01:36

9. Export Customized Quick Access Toolbar in Excel.mp4

01:25

10. Resetting the Quick Access Toolbar in Excel.mp4

01:58

11. Import Customized Quick Access Toolbar in Excel.mp4

01:49

5. Microsoft Excel Ribbon Menu Bar

1.1 Introduction to Microsoft Excel Ribbon Menu System.pdf

1. Introduction to Microsoft Excel Ribbon Menu System.mp4

03:33

2. Excel Ribbon Menu System.html

3.1 Activating the Key Tip Letters in the Ribbon Menu Bar.pdf

3. Activating the Excel Key Tip Letters in the Ribbon Menu Bar.mp4

01:59

4. Activating the Excel Key Tip Letters in the Ribbon Menu Bar.html

5.1 Showing and Hiding the Ribbon Bar in Excel.pdf

5. Showing and Hiding the Ribbon Bar in Excel.mp4

03:09

6. Showing and Hiding the Ribbon Bar in Excel.html

7. Adding More Commands into Existing Tabs in Excel.mp4

02:00

8. Adding New Tabs, Groups and Commands into Excels Ribbon Bar.mp4

04:19

9. Rearranging Group and Tabs in Excel Ribbon Bar.mp4

01:50

10. Hiding the Menu Tabs in Excel Ribbon Bar.mp4

01:32

11. Hiding Custom Command Labels in Excel Ribbon Bar.mp4

02:01

12. Removing Custom Group and Tabs in Excel Ribbon Bar.mp4

01:41

13. Adding Ribbon Group Menu Commands to Quick Access Toolbar.mp4

01:34

14. Export Customized Ribbon Menu Bar in Excel.mp4

01:24

15. Reseting the Excel Ribbon Bar back to Default Layout.mp4

02:14

16. Import Customized Ribbon Menu Bar in Excel.mp4

01:13

17. A Brief Review of the Help Menu in Excel.mp4

01:44

6. Saving Microsoft Excel Workbooks

1. Saving a Microsoft Excel Workbook Locally on Windows Computers.mp4

02:22

2. Accessing Excel Workbook File Location and Local Path.mp4

03:35

3. Changing the Save As Option Default Location.mp4

02:25

4. Opening Excel Saved Workbooks on Windows OS.mp4

01:56

5. Opening a Copy of a Workbook in Excel.html

6. Adding More Description Properties to Excel Workbooks.mp4

02:48

7. Saving Excel Workbooks to OneDrive Cloud on Windows.mp4

02:11

8. Removing the Recent Workbooks from the Home Page.mp4

01:47

9. Removing Excel Workbooks from Windows OS.mp4

01:07

10. Saving the Workbook as a PDF File.mp4

02:03

7. Zooming and View Options in Microsoft Excel

1.1 Roommate Assignments and Bills.xlsx

1.2 Using the Mouse and Keyboard in Excel to Zoom.pdf

1. Using the Mouse and Keyboard in Excel to Zoom.mp4

01:43

2. Zooming in Excel with Mouse and Keyboard.html

3.1 Personal Monthly Budget.xlsx

3.2 Using the Zoom Slider in Excel Status Bar.pdf

3. Using the Zoom Slider in Excel Status Bar.mp4

01:24

4. Using the Zoom Slider to Zoom In or Out.html

5.1 Using the Zoom Dialog Box in Excel.pdf

5.2 Wedding Timeline Planner.xlsx

5. Using the Zoom Dialog Box in Excel.mp4

01:39

6.1 Inventory List.xlsx

6.2 Using the Zoom to Selection Feature in Excel.pdf

6. Using the Zoom to Selection Feature in Excel.mp4

02:02

7. Using the Zoom Option in Excel.html

8.1 Overview of the Different View options in Excel.pdf

8.2 PhoneBook.xlsx

8. Overview of the Different View options in Excel.mp4

02:08

9. Overview of the Different View options in Excel.html

8. Reviweing the Cells in Excel Worksheet

1. A Basic Review of Excel Worksheet.mp4

02:32

2. Basic Review of Working with Cells in Excel.mp4

03:16

3. Selecting a Cell or Range of Cells in Microsoft Excel.mp4

02:29

4. Selecting a Cell or a Range of Cells with the Go to Dialog Box.mp4

02:19

5. Naming a Cell Reference or a Range of Cells in Excel.mp4

02:19

6.1 Book1.xlsx

6. Exploring the Data Type on Excel Worksheet.mp4

03:03

7. Basic Text Entry in Microsoft Excel Worksheet.mp4

03:36

8. Using the Undo and Redo Commands in Excel.mp4

02:09

9. Editing the Basic Cell Contents in Excel.mp4

01:26

10. Exploring the Microsoft Excel Basic Cell Modes.mp4

02:03

11. Removing Cell Contents in Excel Worksheet.mp4

01:25

9. Working with Mouse and Keyboard in Excel Sheets

1. Moving in the Worksheet Cells with Keyboard Keys.mp4

03:44

2. Regular Mouse Icon in Excel Interface.mp4

01:23

3. Fat Plus Mouse Icon in Excel Worksheet.mp4

01:43

4. I-Beam Insertion Mouse Icon in Excel.mp4

02:45

5. Skinny Plus Mouse Icon in Excel.mp4

03:50

6. Black Arrow Mouse Icon in Excel Worksheet.mp4

01:54

7. Double Headed Arrow Mouse Icon in Excel.mp4

01:34

8. Maltese Cross Mouse Icon in Excel.mp4

03:45

9. Right Clicking in Microsoft Excel Worksheets.mp4

03:05

10. Working with Rows and Columns in Excel

1.1 A Brief Review of Microsoft Excel Worksheet.pdf

1. A Brief Review of Microsoft Excel Worksheet.mp4

02:24

2.1 Book1.xlsx

2. Selecting Rows and Columns in Excel.mp4

02:22

3.1 Book1.xlsx

3. Inserting Rows and Columns in Excel Worksheet.mp4

02:38

4. Adjusting Row Height and Column Width of Worksheets.mp4

02:18

5.1 Book1.xlsx

5. AutoFit Row Height and Column Width in Excel Worksheet.mp4

02:49

6. Exploring the Default Column Width and Row Height in Excel Worksheet.mp4

02:10

7.1 Book1.xlsx

7. Hide and Unhide Rows and Columns in Excel Worksheets.mp4

03:09

8.1 Book1.xlsx

8. Deleting Rows and Columns in Excel Worksheet.mp4

01:37

9. Change the Unit of Measurement in Excel.mp4

00:51

11. Basic Formatting Options in Microsoft Excel

1.1 Book1.xlsx

1. Changing Cell Content Font Type Face and in Excel.mp4

02:22

2.1 Book1.xlsx

2. Changing Cell Content Font Size in Excel.mp4

02:13

3.1 Book1.xlsx

3.2 Premium Weekly Chore Schedule.xlsx

3. Changing Cell Content Font Color and Background Color in Excel.mp4

03:20

4.1 A Basic List.xlsx

4. Adding Border Around the Cells in Excel.mp4

04:10

5.1 Simple personal Budget.xlsx

5. Removing All Applied Formatting Options from a Cell in Excel.mp4

01:51

6.1 A Basic PhoneBook.xlsx

6. Merging and Centering Cells in Excel Worksheets.mp4

02:53

7.1 A Basic Invoice.xlsx

7. Exploring the Text Alignment Tools in Excel.mp4

03:21

12. Working with Numbers in Excel Worksheet

1. A Basic Reviw of Entering Number Values in Microsoft Excel Worksheet.mp4

03:04

2. Entering Decimal Numbers in Excel Worksheets.mp4

02:35

3. Entering Fractional Numbers in Excel Worksheets.mp4

01:24

4. Entering a Basic Date in Excel Worksheet.mp4

02:31

5. Entering a Basic Time in Excel Worksheet.mp4

02:41

13. Formatting Cells in Micsosoft Excel

1. Exploring the Microsoft Excel Basic Cell Attributes.mp4

02:45

2.1 Reviewing the Font Group in Excel.xlsx

2. Reviewing the Font Group in Excel.mp4

03:52

3.1 A Basic Invoice.xlsx

3. Reviewing the Number Group in Excel.mp4

04:28

14. Working with Basic Formula and Functions

1. Getting Started with Formulas.html

2. Entering Your First Formula in Excel.mp4

02:56

3. What is Pointing-at Formula Cell in Excel.mp4

03:20

4.1 Basic Arithmetic Operations.xlsx

4. Performing a Basic Arithmetics with Operators in Excel.mp4

05:15

5.1 Basic Arithmetic Operations.xlsx

5. Editing a Basic Formula in Excel Worksheet.mp4

02:22

6.1 Student Marks.xlsx

6. TRUE or FALSE Values with Operators in Excel Worksheet.mp4

03:58

7.1 Student Marks - Copying Basic Formulas in Excel Worksheet.xlsx

7. Copying Basic Formulas in Excel Worksheet.mp4

02:02

8.1 Daily Living Expenses.xlsx

8. Using Functions in Formulas in Excel Worksheet.mp4

02:38

9.1 What Goes into a Function.xlsx

9. Looking at What Goes into a Function in Excel.mp4

04:11

10.1 A Basic Expenses List.xlsx

10. Editing Formulas Including Cell Range in Excel Worksheet.mp4

02:01

11.1 Company Inventory List.xlsx

11. Using the SUM Function from the Editing or Formula Library Group.mp4

02:44

12.1 Daily Living Expenses Full Year.xlsx

12. Calculating with Formulas in Both Directions in Excel.mp4

03:22

13.1 Profit & Loss Projection.xlsx

13. How To Use the SUM Function for Multiple Range of Cells.mp4

01:57

14.1 Loan Calculator.xlsx

14. Adding Column and Row Labels in SUM Function in Excel Formula.mp4

02:23

15.1 Basic Menu Items.xlsx

15. Using the Absolute Reference in Excel Formulas.mp4

05:49

16.1 Product Tax Calculation.xlsx

16. Using Names in Building Formulas in Excel.mp4

03:26

17.1 Five Years Average Sale.xlsx

17. Exploring the Normal AVERAGE Function in Excel.mp4

02:26

18.1 January Sale - Exploring the COUNT NUMBERS Function.xlsx

18. Exploring the COUNT NUMBERS Function in Excel.mp4

01:56

19.1 Total Wedding Budget.xlsx

19. Exploring the MIN and MAX Functions in Excel.mp4

03:38

20.1 Yealy Expenses.xlsx

20. Using the Insert Function Button in Excel.mp4

04:13

21.1 Total Wedding Budget with Status.xlsx

21. Exploring the Basic IF Function in Excel Worksheet.mp4

01:53

22.1 Gradebook and Assignments.xlsx

22. Exploring the IFS Function in Excel Worksheet.mp4

01:44

23.1 Project Invoice.xlsx

23. Exploring the COUNTIF Function in Excel Worksheet.mp4

02:55

24.1 A Basic Contact List.xlsx

24. Exploring the FILTER Function in Excel Worksheet.mp4

03:46

25.1 A Basic Sale Table.xlsx

25. Exploring the SUMIF Function in Excel Worksheet.mp4

02:14

26.1 Basic Sale List - SUMIF Function.xlsx

26. Exploring the SUMIFS Function in Excel Worksheet.mp4

02:04

27.1 Basic Food Budget.xlsx

27. Exploring the FIND and REPLACE Dialog Box in Excel.mp4

02:44

28.1 FIND Function.xlsx

28. Exploring the FIND Function in Excel Worksheet.mp4

02:31

29.1 A Basic Car List.xlsx

29. Exploring the SEARCH Function in Excel Worksheet.mp4

01:42

30.1 Loan Amortization Schedule.xlsx

30. Exploring the VLOOKUP Function in Excel Worksheet.mp4

02:46

31.1 Element List Element Names and Numbers.xlsx

31. Exploring the XLOOKUP Function in Excel Worksheet.mp4

02:00

32.1 A Basic List of Employees.xlsx

32. Exploring the MATCH Function in Excel Worksheet.mp4

01:49

33.1 Exploring the Formulas Tab in Excel Ribbon Bar.xlsx

33. Exploring the Formulas Tab in Excel Ribbon Bar.mp4

04:27

34.1 Basic Food Budgeting.xlsx

34. Defining Name Groups and Use in Formula in Excel.mp4

02:02

35.1 Basic Food Budgeting - Managing Defined Names.xlsx

35. Managing Defined Names for Excel Formulas.mp4

01:55

15. Copying and Moving Contents Around in Excel

1.1 ClipBoardGroup Review.xlsx

1. Reviewing the Clipboard Group in Home Tab in Excel.mp4

01:58

2.1 ExerciseFile-Cut-Copy-Paste-Commands.xlsx

2. Using the Cut Command in Excel.mp4

01:51

3.1 ExerciseFile-Cut-Copy-Paste-Commands.xlsx

3. Using the Copy Command in Excel.mp4

02:21

4.1 Homework Log Exercise File.xlsx

4. Using the Format Painter in Excel.mp4

01:27

5.1 Moving the Cell Content with Mouse in Excel.xlsx

5. Moving the Cell Content with Mouse in Excel.mp4

01:39

16. Creating and Managing Worksheets in Excel

1. Understanding the Microsoft Excel Workbook and Worksheets.mp4

02:01

2. Inserting New Sheets in an Excel Workbook.mp4

02:18

3. Using the Tab Scrolling Buttons for Sheets.mp4

01:50

4. Active Sheets and Moving Between Sheets.mp4

01:14

5. Renaming Sheets in an Excel Workbook.mp4

02:30

6. Deleting Sheets in an Excel Workbook.mp4

01:17

7. Moving Sheet Tabs in an Excel Workbook.mp4

02:29

8. Moving a Sheet Tab to a New Excel Workbook.mp4

01:57

9. Changing Sheet Tab Color in an Excel Workbook.mp4

01:35

10. Create a New Copy of a Sheet in an Excel Workbook.mp4

02:24

11. Assigin an Image as the Sheet Background in Excel.mp4

02:04

12. Hiding and Unhiding Excel Sheets.mp4

01:54

13. Selecting Multiple Sheets in a Excel Workbook Project.mp4

02:01

14. Preventing Sheet Actions in Microsoft Excel.mp4

02:48

15.1 Moving Cell Contents between Worksheets in Excel.xlsx

15. Moving Cell Contents between Worksheets in Excel.mp4

01:23

17. Adding Graphic Obejcts in Microsoft Excel Projects

1. Introduction to Adding Graphic Objects in Excel Worksheet.mp4

00:57

2.1 Introduction to Adding Graphic Objects.xlsx

2. Adding Pictures and Photos in Excel Worksheet from Stock Images.mp4

02:20

3.1 Adding Icons in an Excel Worksheet.xlsx

3. Adding Icons in an Excel Worksheet.mp4

01:58

4. Reviewing the Basics of Working with Shapes in Excel.mp4

02:00

5. Adding 3D Models in an Excel Worksheet.mp4

01:44

18. Presenting and Printing Excel Data

1.1 Exercise File - Basic Conditional Formatting.xlsx

1. Introduction to Using Conditional Formatting.mp4

02:39

2.1 Exercise File - Basic Conditional Formatting.xlsx

2. Creating Custom Conditional Formatting Rules in Excel.mp4

01:56

3.1 Managing Conditional Formatting Rules in Excel.mp4

01:40

3. Managing Conditional Formatting Rules in Excel.mp4

01:40

4. Protecting Worksheets with Password in Excel.mp4

01:57

5. Sharing Workbooks with Others.mp4

01:54

6. Printing a Worksheet in Excel.mp4

03:16

7. Clearing Conditional Formatting in Excel.html

19. Data Management in Microsoft Excel

1. Creating a Blank Table in Excel Worksheet.mp4

02:15

2.1 Project Invoice - Designing the Basic Table in Microsoft Excel.xlsx

2. Designing the Basic Table in Microsoft Excel.mp4

04:16

3. Exploring the Elements of an Excel table.mp4

04:12

4. Inserting a New Field and Record in an Excel Table.mp4

01:33

5.1 Project Invoice - Changing the Basic Properties.xlsx

5. Changing the Basic Properties of a Table in Excel.mp4

01:53

6. Difference between a Field and a Column in a Table.html

7.1 Project Invoice - Changing the Field and Columns Size of a Table in Excel.xlsx

7. Changing the Row and Columns Size of a Table in Excel.mp4

02:31

8. Applying a Standard Conditional Formatting in Excel.html

9.1 Project Invoice - Deleting Record and Fields and in an Excel Table.xlsx

9. Deleting Record and Fields and in an Excel Table.mp4

01:26

10.1 Project Invoice - Eliminating Duplicated Records.xlsx

10. Eliminating Duplicated Records in the Table in Excel.mp4

02:33

11.1 Start Up Cost - Sorting Records in a Single Field in the Table in Excel.xlsx

11. Sorting Records in a Single Field in the Table in Excel.mp4

02:39

12.1 Food Budget - Exploring the Multi Level Sorting in Excel.xlsx

12. Exploring the Multi Level Sorting in Excel.mp4

02:18

13.1 Food Budget - Sorting on Cell Colors.xlsx

13. Sorting a Table on Cell Colors in Excel.mp4

01:52

14.1 Basic Employee List.xlsx

14. Basic Filtering by Selecting a Specific Field Entries.mp4

02:43

15. Using the Text Filter Option in Excel.mp4

03:03

16.1 Basic Employee List - Using the Number Filter Option in Excel.xlsx

16. Using the Number Filter Option in Excel.mp4

02:48

17.1 Basic Employee List - Using the Date Filter Option in Excel.xlsx

17. Using the Date Filter Option in Excel.mp4

01:49

18. Filtering a Table on a Fields Font and Fill Color.html

19.1 Basic Employee List - Creating a Basic Pivot Table in Excel Worksheet.xlsx

19. Creating a Basic Pivot Table in Excel Worksheet.mp4

04:11

20.1 Basic Employee List - Sorting Data in a PivotTable in Excel.xlsx

20. Sorting Data in a PivotTable in Excel.mp4

01:17

21.1 Basic Employee List - Filtering Data in a PivotTable in Excel.xlsx

21. Filtering Data in a PivotTable in Excel.mp4

01:55

22.1 Basic Employee List - Deleting a PivotTable in Excel.xlsx

22. Deleting a PivotTable in Excel.mp4

01:09

20. Adding Charts and Visualization Graphics in Microsoft Excel Projects

1. Understanding the Pupose of Charts and Graphs.mp4

01:42

2. Creating Basic Charts in Excel Worksheet.mp4

01:42

3.1 Chart Type, Style and Layout.xlsx

3. Changing Chart Types and Layouts in Excel.mp4

01:44

4. Customizing the Basic Elements of a Chart in Excel.mp4

02:10

5. Creating a PivotChart in Excel Worksheet.html

21. Collaboration and Sharing in Excel

1. Collaboration and Sharing in Excel.html

Description

Learn Everything You Should know about Microsoft Excel Step by Step for Beginners

What You'll Learn?

Creating workbooks and worksheets
Navigating Excel user interface
Navigating workbooks and worksheets
Getting familiar with cells, rows, and columns
Entering text, numbers and working with dates, and time
Getting familiar with formulas and functions
Getting familiar with tables and pivot tables
Getting familiar with graphic objects and charts
Getting familiar conditional formating presentaiton and print options

Who is this for?

This course suitable for Office 365 Users

This course is suitable for Windows users

What You Need to Know?

Basic Knowlege of Computer and Windows Operating System

Microrosft Excel

More details

Description
Welcome to the world of Microsoft Excel! In this course, we will explore the powerful features and functionalities of Excel that will help you become a proficient user. Whether you are a student, professional, or just curious about spreadsheets, this course will equip you with the necessary knowledge and skills to thrive in Excel

This course is specifically designed for beginners who have little to no experience with Microsoft Excel. If you have never used Excel before or feel overwhelmed by its functionalities, this course is for you. Our step-by-step approach and practical examples will guide you through the learning process, ensuring that you build a strong foundation in Excel. Even if you have some prior knowledge of Excel but want to refresh your skills or learn more advanced techniques, this course will still be beneficial to you.

Excel is a spreadsheet program developed by Microsoft and is widely used for data analysis, financial modeling, and organizing information. With Excel, you can manipulate and visualize data in various ways, helping you make informed decisions and save time. This course focuses specifically on Microsoft Excel for Office 365, the latest version of Excel that offers more dvanced features and collaboration options

If you've ever felt overwhelmed by the thought of navigating Microsoft Excel, you're not alone. Trying to make sense of the complex interface, figuring out how to enter and edit data, and getting the formatting just right can be a daunting task. But fear not, because our comprehensive course is here to solve all your Excel-related issues

In this course, we will start by familiarizing ourselves with the Excel interface. You will learn how to navigate through workbooks, worksheets, and cells, as well as how to select and edit data efficiently. Understanding the interface is crucial, as it allows you to make the most out of Excel's extensive functionalities

Each section has been carefully desiged to address the most common challenges that beginners face when working with Excel. Once you are comfortable with the interface, we will dive deeper into entering and editing data. You will learn various techniques to input and manipulate data effectively. We will cover essential topics such as formatting cells, using formulas and functions, and handling basic calculations. These skills will provide a solid foundation for your Excel journey. You'll learn everything from the basics of understanding the Excel interface to intermediate techniques like sorting and filtering data, creating stunning charts and graphs, and using formulas and functions to solve various calculations

Together, we will explore the purpose and importance of visualizing data using charts and graphs. We will start with creating basic charts such as bar, column, and line charts, and guide you through customizing chart elements, labels, and titles. You will also learn how to change chart types and layouts to suit your specific needs. You'll learn how to create different types of charts to visually represent your data in a meaningful way.

With its immense popularity and wide range of applications, Microsoft Excel is a crucial tool for anyone working with data. By completing this course, you will gain the necessary skills to navigate through Excel, enter and edit data efficiently, and perform basic calculations. This knowledge will set a solid foundation for your Excel journey and empower you to explore more advanced features in the future

Are you ready? Let's embark on this exciting Excel adventure together!
Who this course is for:
This course suitable for Office 365 Users
This course is suitable for Windows users

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

E Learning Platform

Instructor's Courses

Viyan is passionate about life, and technology. She teaches many skills to help people achieve their personal or business goals using the power of their minds, creativity and technology.Viyan is a lifetime student who considers a day wasted if she is not awed by something. She is a certified sound/audio engineer, electronic music producer and also freelance video editor, content creator and designer.Her passion for life, mind and technology has led her to teach on social media platforms for people who seek a new way of learning in technology, science and more.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.