What you'll learn
Office .com - Microsoft 365 Dashboard Entry Point & Absolute Beginnings
Microsoft Excel in Microsoft 365: Making Changes in Excel
Microsoft Excel in Microsoft 365: Deleting and Clearing
Microsoft Excel in Microsoft 365: Excel Styling
Microsoft Excel in Microsoft 365: Version History | Undo & Redo
Microsoft Excel in Microsoft 365 View Options
Microsoft Excel in Microsoft 365: Excel Review Features
Microsoft Excel in Microsoft 365: Loading Data
Microsoft Excel in Microsoft 365: Tables in Excel
Microsoft Excel in Microsoft 365: Formulas for Styling Excel Spreadsheets
Requirements
No experience required. It would be helpful to have access to Microsoft Excel, particularly Microsoft Excel in Microsoft 365 (Previously known as Office 365), but with any version of Excel the student has, they will still learn a tremendous amount about using Excel.
Description
Microsoft Excel is the spreadsheet, data visualization, and data analysis tool that has stood the test of time. Microsoft released the first Microsoft Excel for the Macintosh computer version in the year 1985. In 1987, they released Microsoft Excel for Windows computers as well. At the time, Lotus 1-2-3 was the competitor Microsoft had to pull market share from in order to succeed and thrive. While Lotus 1-2-3 is now a legacy, discontinued product, Microsoft Excel continues to thrive and is the leader in spreadsheet software.Despite the emergence and growing popularity of many data analytics tools and even spreadsheet software like Google Sheets, today Excel is as popular as ever and perhaps even more so as it is used in conjunction with popular data analytics and visualization tools such as PowerBI and Tableau.And even so, not every company has opted in to supplying their users with official data analysis and data visualization software like the above, but if they have Microsoft Office products, they have Microsoft Excel.Students of this course will find their work life becomes much easier when they become comfortable using Microsoft Excel. With each lesson, the student will experience increased ease of use and confidence in their professional skillset by growing their knowledge of Microsoft Excel through the hands-on lessons they will walk through in this course.
Overview
Section 1: Introduction
Lecture 1 Microsoft Excel in Microsoft 365: Introduction
Section 2: Office.com - Microsoft 365 Dashboard Entry Point & Absolute Beginnings
Lecture 2 Open Excel in Microsoft 365 - No sound for studying in a quiet office.
Lecture 3 With Sound - Open Excel in Microsoft 365
Lecture 4 Microsoft Excel in Microsoft 365: Create a new workbook - No Sound
Lecture 5 With Sound - Microsoft Excel in Microsoft 365: Create a New Workbook
Lecture 6 Microsoft Excel in Microsoft 365: Enter text in a cell - No Sound
Lecture 7 With Sound - Microsoft Excel in Microsoft 365: Enter text in a cell
Lecture 8 Microsoft Excel in Microsoft 365: Excel sheets - No Sound
Lecture 9 With Sound - Microsoft Excel in Microsoft 365: Excel sheets
Lecture 10 Microsoft Excel in Microsoft 365: Create a new Excel file from the app launcher
Lecture 11 With Sound - Microsoft 365 Excel: Create a new Excel file from the app launcher
Lecture 12 Microsoft Excel in Microsoft 365: AutoSave Excel in the Desktop App - No Sound
Lecture 13 With Sound - Microsoft Excel in Microsoft 365: AutoSave Excel in the Desktop App
Lecture 14 Microsoft Excel in Microsoft 365: File Save As in Excel in browser - No Sound
Lecture 15 With Sound - Microsoft Excel in Microsoft 365: File Save As in Excel in browser
Lecture 16 Microsoft Excel in Microsoft 365: Use Excel as a calculator - No Sound
Lecture 17 With Sound - Microsoft Excel in Microsoft 365: Use Excel as a calculator
Lecture 18 Microsoft Excel in Microsoft 365: Copy and paste cell content - No Sound
Lecture 19 With Sound - Microsoft Excel in Microsoft 365: Copy and paste cell content
Lecture 20 Microsoft Excel in Microsoft 365: Moving sheets in Excel - No Sound
Lecture 21 With Sound - Microsoft Excel in Microsoft 365: Moving sheets in Excel
Lecture 22 Microsoft Excel in Microsoft 365: Indent Text - No Sound
Lecture 23 With Sound - Microsoft Excel in Microsoft 365: Indent Text
Lecture 24 Microsoft Excel in Microsoft 365: Select all cells with the keyboard - No Sound
Lecture 25 With Sound - Microsoft Excel in Microsoft 365: Select all cells with keyboard
Lecture 26 Microsoft Excel in Microsoft 365: Auto-Increment numbers during copy - No Sound
Lecture 27 With Sound - Microsoft Excel Microsoft 365: Auto-Increment numbers during copy
Section 3: Microsoft Excel in Microsoft 365: Making Changes in Excel
Lecture 28 Microsoft Excel: Change a File Name in Excel in Browser - No Sound
Lecture 29 With Sound - Microsoft Excel: Change a File Name in Excel in Browser
Lecture 30 Microsoft Excel in Microsoft 365: File name saving and changing in desktop app
Lecture 31 With Sound - Microsoft Excel in Microsoft 365: File name saving desktop app
Lecture 32 Microsoft Excel in Microsoft 365: Change Font Type - No Sound
Lecture 33 With Sound - Microsoft Excel in Microsoft 365: Change Font Type
Lecture 34 Microsoft Excel: Change the height of all rows thru highlight & drag method
Lecture 35 WithSound-With Sound - Microsoft Excel: Change the height of all rows highlight
Lecture 36 Microsoft Excel in Microsoft 365: Change row height from the ribbon - No Sound
Lecture 37 With Sound - Microsoft Excel in Microsoft 365: Change row height from the ribbon
Lecture 38 Microsoft Excel in Microsoft 365: Change sheet name from ribbon - No Sound
Lecture 39 With Sound -Microsoft Excel in Microsoft 365: Change sheet name from ribbon
Lecture 40 Microsoft Excel in Microsoft 365: Change text size - No Sound
Lecture 41 With Sound - Microsoft Excel in Microsoft 365: Change text size
Lecture 42 Microsoft Excel: Change all columns' width highlight & drag method - No Sound
Lecture 43 With Sound - Microsoft Excel: Change all column width highlight & drag method
Lecture 44 Microsoft Excel in Microsoft 365: Expand a single column to fit text - No Sound
Lecture 45 With Sound - Microsoft Excel in Microsoft 365: Expand single column to fit text
Lecture 46 Microsoft Excel in Microsoft 365: Expand all columns to fit text - No Sound
Lecture 47 With Sound - Microsoft Excel in Microsoft 365: Expand all columns to fit text
Section 4: Microsoft Excel in Microsoft 365: Deleting and Clearing
Lecture 48 Microsoft Excel: Delete columns in Excel - No Sound
Lecture 49 With Sound - Microsoft Excel: Delete columns in Excel
Lecture 50 Microsoft Excel in Microsoft 365: Delete a row - No Sound
Lecture 51 With Sound - Delete a row in Microsoft Excel
Lecture 52 Microsoft Excel in Microsoft 365: Delete all text in a sheet at once - No Sound
Lecture 53 With Sound - Microsoft Excel in Microsoft 365: Delete all text in sheet at once
Lecture 54 Microsoft Excel in Microsoft 365: Delete a cell ina row of data - No Sound
Lecture 55 With Sound - Microsoft Excel in Microsoft 365: Delete a cell ina row of data
Lecture 56 Microsoft Excel in Microsoft 365: Clear contents - No Sound
Lecture 57 With Sound -Microsoft Excel in Microsoft 365: Clear contents
Section 5: Microsoft Excel in Microsoft 365: Excel Styling
Lecture 58 Microsoft Excel in Microsoft 365: Wrap text from the ribbon in Excel Online
Lecture 59 With Sound - Microsoft 365 Excel: Wrap text from the ribbon in Excel Online
Lecture 60 Microsoft Excel in Microsoft 365: Format cells: fill color& wrap text - No Sound
Lecture 61 With Sound - Microsoft Excel in Microsoft 365: Format Cells Fill Color Text Wrap
Lecture 62 Microsoft Excel in Microsoft 365: Cell styles - No Sound
Lecture 63 With Sound - Microsoft Excel in Microsoft 365: Cell styles
Lecture 64 Microsoft Excel: Wrap text from ribbon in Excel in desktop app - No Sound
Lecture 65 Microsoft Excel: Wrap text in Excel using the right-click method - No Sound
Lecture 66 With Sound - Microsoft Excel: Wrap text in Excel using the right-click method
Lecture 67 Microsoft Excel in Microsoft 365: Merge and center text - No Sound
Lecture 68 With Sound - Microsoft Excel in Microsoft 365: Merge and center text
Lecture 69 Microsoft Excel in Microsoft 365: Make a header row that sticks - No Sound
Lecture 70 With Sound - Microsoft 365 Excel: Make a header row that sticks
Section 6: Microsoft Excel in Microsoft 365: Version History | Undo & Redo
Lecture 71 Microsoft Excel in Microsoft 365: Undo & Redo - No Sound
Lecture 72 With Sound - Microsoft Excel in Microsoft 365: Undo & Redo
Lecture 73 Microsoft Excel in Microsoft 365: Version history - No Sound
Lecture 74 With Sound - Microsoft Excel in Microsoft 365: Version history
Section 7: Microsoft Excel in Microsoft 365 View Options
Lecture 75 Microsoft Excel in Microsoft 365: Zoom Excel view in browser - No Sound
Lecture 76 With Sound - Microsoft Excel in Microsoft 365: Zoom Excel view in browser
Lecture 77 Microsoft Excel in Microsoft 365: Add/Remove Gridlines & Headings - No Sound
Lecture 78 With Sound - Microsoft Excel in Microsoft 365: Add/Remove Gridlines & Headings
Lecture 79 Microsoft Excel in Microsoft 365: View workbook in new window - No Sound
Lecture 80 With Sound - Microsoft Excel in Microsoft 365: View workbook in new window
Lecture 81 Microsoft Excel in Microsoft 365: Sheet Views - No Sound
Lecture 82 With Sound - Microsoft Excel in Microsoft 365: Sheet Views
Lecture 83 Microsoft Excel in Microsoft 365: Freeze Panes - No Sound
Lecture 84 With Sound - Microsoft Excel in Microsoft 365: Freeze Panes
Lecture 85 Microsoft Excel in Microsoft 365: Switch Windows Excel Desktop App - No Sound
Lecture 86 With Sound - Microsoft Excel in Microsoft 365: Switch Windows Excel Desktop App
Lecture 87 Microsoft Excel in Microsoft 365: Hide and Show Formula Bar in Desktop App
Lecture 88 With Sound - Microsoft Excel in Microsoft 365: HideShow Formula Bar Desktop App
Lecture 89 Microsoft Excel in Microsoft 365: Arrange All - Desktop App - No Sound
Lecture 90 With Sound - Microsoft Excel in Microsoft 365: Arrange All - Desktop App
Lecture 91 Microsoft Excel in Microsoft 365: Split Feature in Desktop App - No Sound
Lecture 92 With Sound - Microsoft Excel in Microsoft 365: Split Feature in Desktop App
Lecture 93 Microsoft Excel in Microsoft 365 Desktop App: Page Break Preview - No Sound
Lecture 94 With Sound - Microsoft Excel in Microsoft 365 Desktop App: Page Break Preview
Lecture 95 Microsoft Excel in Microsoft 365: Headers & Footers in Page Layout - No Sound
Lecture 96 With Sound - Microsoft Excel in Microsoft 365: Headers & Footers in Page Layout
Lecture 97 Microsoft Excel in Microsoft 365 Desktop Application: Zoom Features - No Sound
Lecture 98 With Sound - Microsoft Excel in Microsoft 365 Desktop Application: Zoom Features
Lecture 99 Microsoft Excel in Microsoft 365: Excel in Browser-Editing to Viewing - No Sound
Lecture 100 With Sound - Microsoft Excel in Microsoft 365: Excel in Browser-Editing to Viewi
Lecture 101 With Sound - Microsoft 365 Excel: Zooming By Sheet
Section 8: Microsoft Excel in Microsoft 365: Excel Review Features
Lecture 102 Microsoft Excel in Microsoft 365: Spell Check - No Sound
Lecture 103 With Sound - Microsoft Excel in Microsoft 365: Spell Check
Lecture 104 Microsoft Excel in Microsoft 365: Check performance of Excel sheets - No Sound
Lecture 105 With Sound - Microsoft Excel in Microsoft 365: Check Performance
Lecture 106 Microsoft Excel in Microsoft 365: Check Accessibility - No Sound
Lecture 107 With Sound - Microsoft Excel in Microsoft 365: Check Accessibility
Lecture 108 Microsoft Excel in Microsoft 365: Workbook statistics - No Sound
Lecture 109 With Sound - Microsoft Excel in Microsoft 365: Workbook Statistics
Section 9: Microsoft Excel in Microsoft 365: Loading Data
Lecture 110 Microsoft Excel in Microsoft 365: Load data from another Excel Workbook
Lecture 111 With Sound - Load data into current Excel workbook from another Excel file
Lecture 112 Microsoft Excel in Microsoft 365: Convert an Excel file (.xlsx) to a CSV file
Lecture 113 With Sound - Convert Excel Spreadsheet (.xlsx) to CSV (.csv) in Microsoft 365
Lecture 114 Microsoft Excel in Microsoft 365: Export to Excel in SharePoint - No Sound
Lecture 115 With Sound - Export data to Excel from a Microsoft 365 list in SharePoint
Lecture 116 Microsoft Excel in Microsoft 365: Refresh data in Excel from a Microsoft List
Lecture 117 With Sound - Refresh data in a Microsoft 365 Excel spreadsheet
Section 10: Microsoft Excel in Microsoft 365: Tables in Excel
Lecture 118 Microsoft Excel in Microsoft 365: Convert data to a table - No Sound
Lecture 119 With Sound - Convert data to a table in Microsoft 365 Excel spreadsheets
Section 11: Microsoft Excel in Microsoft 365: Formulas for Styling Excel Spreadsheets
Lecture 120 Microsoft Excel in Microsoft 365: Formula Use to Highlight Rows - No Sound
Lecture 121 With Sound - Microsoft Excel in Microsoft 365: Formula Use to Highlight Rows
Lecture 122 Microsoft Excel in Microsoft 365: Formula Use to Highlight Columns - No Sound
Lecture 123 With Sound - Microsoft Excel in Microsoft 365: Formula Use to Highlight Columns
Lecture 124 Microsoft Excel in Microsoft 365: Clear rules in a spreadsheet
Lecture 125 With Sound - Microsoft Excel: Clear rules in a spreadsheet
This course is for people who want to learn how to use Microsoft Excel. Beginners will benefit greatly by taking this course. For people who have only worked in legacy versions of Microsoft Excel, this course will also prove useful for familiarizing themselves with the modern Microsoft Excel spreadsheets in Microsoft 365.



Download link

rapidgator.net:


[/b]:

[b]:

ddownload.com: