Companies Home Search Profile
TrainingHub TrainingHub

Microsoft Excel: Excel Beginner Basics, Formulas & Functions

Focused View

Robert Mathisen

8:58:14

204 View
  • 1. Start Screen.mp4
    01:15
  • 2. Workbooks and Worksheets.mp4
    00:46
  • 3. Exploring the User Interface.mp4
    02:32
  • 4. Navigating around the Worksheet.mp4
    01:21
  • 5. Navigating using your Keyboard.mp4
    01:19
  • 6. Shortcuts for moving the Cell Pointer.mp4
    01:17
  • 7. Scroll & Zoom.mp4
    01:24
  • 8. Backstage View.mp4
    00:35
  • 9. Introducing Your First Assignment.mp4
    02:27
  • 10.1 1) Getting to know Excel - Assignment 1.xlsx
  • 10.2 1) Getting to Know Excel - Notes.pdf
  • 10. Getting to know Excel - Assignment 1.html
  • 11. Getting to know Excel - Assignment 1 (Answer Guide).mp4
    07:03
  • 12. The Ribbon.mp4
    02:21
  • 13. Ribbon Tabs - Part 1.mp4
    02:53
  • 14. Ribbon Tabs - Part 2.mp4
    01:11
  • 15. Types of Commands on the Ribbon.mp4
    03:12
  • 16. Shortcut Menus.mp4
    01:52
  • 17. The Quick Access toolbar.mp4
    00:42
  • 18. Adding Ribbon Commands to the Quick Access toolbar.mp4
    02:24
  • 19. Adding Non-Ribbon Commands to the Quick Access toolbar.mp4
    01:17
  • 20. The Formula bar.mp4
    01:46
  • 21. Dialog Boxes.mp4
    01:10
  • 22. Tabbed Dialog Boxes.mp4
    00:40
  • 23. Task Panes.mp4
    01:25
  • 24.1 1) Getting to know Excel - Assignment 2.xlsx
  • 24.2 1) Getting to Know Excel - Notes.pdf
  • 24. Getting to know Excel - Assignment 2.html
  • 25. Getting to know Excel - Assignment 2 (Answer Guide).mp4
    02:48
  • 1. Data Types.mp4
    02:28
  • 2. Entering Numbers.mp4
    02:19
  • 3. Entering Text.mp4
    05:02
  • 4. Using Enter Mode.mp4
    01:06
  • 5. Entering Date values.mp4
    03:09
  • 6. Entering Time values.mp4
    01:00
  • 7. Working with 2-Digit Years.mp4
    01:16
  • 8.1 2) Entering and Editing Data - Assignment 1.xlsx
  • 8.2 2) Entering and Editing Data - Notes.pdf
  • 8. Entering and Editing Data - Assignment 1.html
  • 9. Entering and Editing Data - Assignment 1 (Answer Guide).mp4
    09:05
  • 10. Data Entry.mp4
    03:35
  • 11. Deleting the Contents of a Cell.mp4
    02:02
  • 12. Replacing the Contents of a Cell.mp4
    01:24
  • 13. Editing the Contents of a Cell.mp4
    01:29
  • 14. Undo and Redo.mp4
    01:47
  • 15. Editing in the Cell versus on the Formula Bar.mp4
    00:31
  • 16. Inserting Cells.mp4
    00:54
  • 17. Displaying Text on Separate Lines within a Cell.mp4
    01:10
  • 18. Using AutoFill to Enter a Series of Values.mp4
    03:13
  • 19. AutoFill Series with Custom Increments.mp4
    01:37
  • 20.1 2) Entering and Editing Data - Assignment 2.xlsx
  • 20.2 2) Entering and Editing Data - Notes.pdf
  • 20. Entering and Editing Data - Assignment 2.html
  • 21. Entering and Editing Data - Assignment 2 (Answer Guide).mp4
    14:37
  • 22. AutoComplete.mp4
    03:59
  • 23. Entering Fractions.mp4
    01:04
  • 24. Automatic Number Formatting.mp4
    01:46
  • 25. Using the Ribbon to Format Numbers.mp4
    01:21
  • 26. Formatting Numbers by using the Format Cells Dialog Box.mp4
    05:18
  • 27.1 2) Entering and Editing Data - Assignment 3.xlsx
  • 27.2 2) Entering and Editing Data - Notes.pdf
  • 27. Entering and Editing Data - Assignment 3.html
  • 28. Entering and Editing Data - Assignment 3 (Answer Guide).mp4
    02:32
  • 1. Working with Excel Windows.mp4
    01:21
  • 2. Moving and Resizing Windows.mp4
    01:43
  • 3. Switching among Windows.mp4
    00:42
  • 4. Closing Windows.mp4
    00:36
  • 5. Activating a Worksheet.mp4
    01:16
  • 6. Adding Worksheets.mp4
    00:48
  • 7. Deleting Worksheets.mp4
    00:58
  • 8. Renaming a Worksheet.mp4
    01:23
  • 9. Changing a Sheet Tab Color.mp4
    00:49
  • 10. Rearranging your Worksheets.mp4
    01:15
  • 11. Zooming In and Zooming Out.mp4
    02:24
  • 12.1 3) Worksheet Operations - Assignment 1.xlsx
  • 12.2 3) Worksheet Operations - Notes.pdf
  • 12. Worksheet Operations - Assignment 1.html
  • 13. Worksheet Operations - Assignment 1 (Answer Guide).mp4
    03:58
  • 14. Freezing Window Panes.mp4
    03:29
  • 15. Selecting Rows and Columns.mp4
    01:42
  • 16. Adding New Columns and Rows.mp4
    02:48
  • 17. Deleting Columns and Rows.mp4
    02:11
  • 18. Hiding Rows and Columns.mp4
    02:20
  • 1. Finding Data.mp4
    08:11
  • 2. Finding and Replacing Data.mp4
    02:31
  • 3. Copying or Moving Ranges.mp4
    02:15
  • 4. Paste Special.mp4
    03:42
  • 5. Paste Special Dialog Box.mp4
    02:10
  • 6.1 4) Working with Ranges - Assignment 1.xlsx
  • 6.2 4) Working with Ranges - Notes.pdf
  • 6. Working with Ranges - Assignment 1.html
  • 7. Working with Ranges - Assignment 1 (Answer Guide).mp4
    06:51
  • 8. Hyperlinks.mp4
    02:46
  • 9. Editing Links.mp4
    01:44
  • 10. Removing a Link.mp4
    00:58
  • 11. Adding Notes to Cells.mp4
    02:27
  • 12. Sorting and Filtering.mp4
    07:18
  • 13. Custom Sort.mp4
    02:34
  • 14. Copy & Paste - Filter vs Hide.mp4
    01:34
  • 15.1 4) Working with Ranges - Assignment 2.xlsx
  • 15.2 4) Working with Ranges - Notes.pdf
  • 15. Working with Ranges - Assignment 2.html
  • 16. 4) Working with Ranges - Assignment 2 (Answer Guide).mp4
    07:55
  • 1. Fonts.mp4
    03:13
  • 2. Text Alignment.mp4
    05:16
  • 3. Colors and Shading.mp4
    03:43
  • 4. Borders and Lines.mp4
    05:41
  • 5. Format Painter.mp4
    02:43
  • 6.1 5) Formatting - Assignment 1.xlsx
  • 6.2 5) Formatting - Notes.pdf
  • 6. Formatting - Assignment 1.html
  • 7. Formatting - Assignment 1 (Answer Guide).mp4
    05:48
  • 1. Creating a New Workbook.mp4
    01:07
  • 2. Opening an Existing Workbook.mp4
    03:32
  • 3. Saving a Workbook.mp4
    02:41
  • 4. Changing the Default File Location.mp4
    01:44
  • 5. Password-Protecting a Workbook.mp4
    01:03
  • 6.1 6) Saving and Password Protection - Assignment 1.xlsx
  • 6.2 6) Saving and Password Protection - Notes.pdf
  • 6. Saving and Password Protection - Assignment 1.html
  • 7. Saving and Password Protection - Assignment 1 (Answer Guide).mp4
    02:10
  • 1. Printing from the Backstage View.mp4
    05:04
  • 2. Previewing the Printout.mp4
    00:58
  • 3. Changing Your Page View.mp4
    03:44
  • 4. Previewing the Pages.mp4
    02:01
  • 5. Creating PDF Files.mp4
    01:11
  • 6.1 7) Printing - Assignment 1.xlsx
  • 6.2 7) Printing - Notes.pdf
  • 6. Printing - Assignment 1.html
  • 7. Printing - Assignment 1 (Answer Guide).mp4
    05:42
  • 1. Formulas & Editing Formulas.mp4
    02:29
  • 2. Order of Operations.mp4
    01:47
  • 3. Functions.mp4
    05:08
  • 4. Relative & Absolute Cell References.mp4
    01:25
  • 5. Mixed References.mp4
    06:57
  • 6. Circular References.mp4
    02:31
  • 7.1 8) Intro to Formulas, Functions, and Cell References - Assignment 1.xlsx
  • 7.2 8) Intro to Formulas, Functions, and Cell References - Notes.pdf
  • 7. Intro to Formulas, Functions, and Cell References - Assignment 1.html
  • 8. Intro to Formulas, Functions, and Cell References - Assignment (Answer Guide).mp4
    05:32
  • 1. RANDBETWEEN.mp4
    02:30
  • 2. ROUND, ROUNDUP, ROUNDDOWN.mp4
    02:36
  • 3. INT, TRUNC, ROUND.mp4
    02:49
  • 4. MROUND.mp4
    02:08
  • 5. FLOOR, CEILING.mp4
    04:05
  • 6.1 9) Math Functions - Assignment 1.xlsx
  • 6.2 9) Math Functions - Notes.pdf
  • 6. Math Functions - Assignment 1.html
  • 7. Math Functions - Assignment 1 (Answer Guide).mp4
    03:28
  • 8. ODD, EVEN.mp4
    01:45
  • 9. MOD.mp4
    01:08
  • 10. SUM, AutoSum, Alt + Plus Sign, Quick Analysis.mp4
    03:01
  • 11. Running Total Formula.mp4
    03:23
  • 12. SUMIF.mp4
    01:53
  • 13. SUMIFS.mp4
    01:29
  • 14.1 9) Math Functions - Assignment 2.xlsx
  • 14.2 9) Math Functions - Notes.pdf
  • 14. Math Functions - Assignment 2.html
  • 15. Math Functions - Assignment 2 (Answer Guide).mp4
    10:37
  • 1. AND Function.mp4
    01:43
  • 2. IF (boy).mp4
    02:18
  • 3. IF (older than 4).mp4
    03:40
  • 4. IF & AND (boy, and older than 4).mp4
    01:59
  • 5. IF (not a boy).mp4
    00:57
  • 6. IF & AND (not a boy, and younger than 4).mp4
    01:42
  • 7.1 10) Logical Functions - Assignment 1.xlsx
  • 7.2 10) Logical Functions - Notes.pdf
  • 7. Logical Functions - Assignment 1.html
  • 8. Logical Functions - Assignment 1 (Answer Guide).mp4
    04:28
  • 9. OR Function.mp4
    01:15
  • 10. IF & OR (girl, and younger than 4).mp4
    01:16
  • 11. IFS.mp4
    03:51
  • 12. Nested IF.mp4
    04:38
  • 13.1 10) Logical Functions - Assignment 2.xlsx
  • 13.2 10) Logical Functions - Notes.pdf
  • 13. Logical Functions - Assignment 2.html
  • 14. Logical Functions - Assignment 2 (Answer Guide).mp4
    17:22
  • 15. ISEVEN.mp4
    02:16
  • 16. ISODD.mp4
    01:35
  • 17. ISBLANK.mp4
    04:22
  • 18. ISFORMULA.mp4
    02:12
  • 19. ISERROR, IFERROR.mp4
    03:21
  • 20.1 10) Logical Functions - Assignment 3.xlsx
  • 20.2 10) Logical Functions - Notes.pdf
  • 20. Logical Functions - Assignment 3.html
  • 21. Logical Functions - Assignment 3 (Answer Guide).mp4
    02:45
  • 1. AVERAGE.mp4
    00:38
  • 2. MEDIAN.mp4
    01:17
  • 3. MODE.mp4
    01:59
  • 4. COUNT.mp4
    01:53
  • 5. COUNTA.mp4
    00:45
  • 6. COUNTBLANK.mp4
    00:22
  • 7. COUNTIF.mp4
    01:01
  • 8. COUNTIFS.mp4
    01:31
  • 9. MAX, MIN.mp4
    01:06
  • 10.1 11) Statistical Functions - Assignment 1.xlsx
  • 10.2 11) Statistical Functions - Notes.pdf
  • 10. Statistical Functions - Assignment 1.html
  • 11. Statistical Functions - Assignment 1 (Answer Guide).mp4
    18:13
  • 1. UPPER, LOWER, PROPER.mp4
    00:42
  • 2. LEN.mp4
    01:39
  • 3. TRIM.mp4
    01:20
  • 4. Concatenation using the Ampersand symbol (&).mp4
    03:31
  • 5. LEFT, RIGHT, MID.mp4
    04:06
  • 6.1 12) Text Functions - Assignment 1.xlsx
  • 6.2 12) Text Functions - Notes.pdf
  • 6. Text Functions - Assignment 1.html
  • 7. Text Functions - Assignment 1 (Answer Guide).mp4
    10:06
  • 8. TEXTBEFORE.mp4
    01:26
  • 9. TEXTAFTER.mp4
    04:06
  • 10. Text to Columns.mp4
    01:00
  • 11. Concatenation using the Ampersand symbol (&) - Part 2.mp4
    00:49
  • 12. TEXTJOIN.mp4
    02:31
  • 13. CONCATENATE.mp4
    03:19
  • 14. TEXTSPLIT.mp4
    01:03
  • 15.1 12) Text Functions - Assignment 2.xlsx
  • 15.2 12) Text Functions - Notes.pdf
  • 15. Text Functions - Assignment 2.html
  • 16. Text Functions - Assignment 2 (Answer Guide).mp4
    18:40
  • 17. TEXT (including Leading Zeros and Padding Zeros).mp4
    09:47
  • 18. TYPE.mp4
    03:04
  • 19. VALUE.mp4
    03:00
  • 20. T Function.mp4
    04:39
  • 21.1 12) Text Functions - Assignment 3.xlsx
  • 21.2 12) Text Functions - Notes.pdf
  • 21. Text Functions - Assignment 3.html
  • 22. Text Functions - Assignment 3 (Answer Guide).mp4
    08:40
  • 1. Date.mp4
    05:30
  • 2. Time.mp4
    02:12
  • 3.1 13) Date & Time Functions - Assignment 1.xlsx
  • 3.2 13) Date & Time Functions - Notes.pdf
  • 3. Date & Time Functions - Assignment 1.html
  • 4. Date & Time Functions - Assignment 1 (Answer Guide).mp4
    08:08
  • 1. XLOOKUP.mp4
    04:22
  • 2. UNIQUE.mp4
    03:29
  • 3. TRANSPOSE.mp4
    01:32
  • 4. VSTACK, HSTACK.mp4
    03:18
  • 5.1 14) Lookup Functions - Assignment 1.xlsx
  • 5.2 14) Lookup Functions - Notes.pdf
  • 5. Lookup Functions - Assignment 1.html
  • 6. Lookup Functions - Assignment 1 (Answer Guide).mp4
    11:45

    • Description

    Microsoft Excel Course: From A-Z, Zero to Hero - Microsoft/Office/Excel 365, Microsoft Excel 2019, Microsoft Excel 2016

    What You'll Learn?

    • Build a solid understanding on the Basics of Microsoft Excel
    • Learn the most common Excel functions used in the Office
    • Take control of your Excel data! Learn fast and efficient management techniques.
    • Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch
    • How to standardize and clean data ready for analysis in Excel
    • Be a Confident & Advanced Microsoft Excel user
    • Learn new techniques and formulas to tackle tasks faster and better in Excel
    • Learn practical methods to sort and filter your data in Excel

    Who is this for?

  • Anyone looking for a deeper understanding of Microsoft Excel.

    • What You Need to Know?

  • Must have access to Microsoft Excel (ideally Excel 365, Excel 2021, or Excel 2019)

    • More details

    Description

    Are you ready to master Microsoft Excel and unlock its full potential? Whether you're a beginner looking to grasp the basics or an experienced user aiming to refine your skills, you've come to the right place!

    In this comprehensive Microsoft Excel course, we cover everything from the fundamental functions to advanced techniques that will make you a spreadsheet wizard. Excel isn't just a tool. It's your secret weapon for organizing data, and performing complex calculations that drive informed decisions.

    Why Microsoft Excel? It's the cornerstone of data management across industries, from finance and marketing to education and beyond. By the end of this course, you'll feel confident navigating Excel's interface, and creating formulas with ease.

    Each module is designed for maximum clarity and hands on practice, ensuring you not only understand concepts but can apply them immediately.

    Ready to excel in Excel? Join us on this exciting learning journey and take your skills to the next level. Enroll today and empower yourself with the spreadsheet skills that employers value.

    Let's dive in and discover the endless possibilities of Microsoft Excel together!


    Below are the sections and topics that will be covered in this course.

    Getting to know Excel
               Understanding Excel Workbooks and Worksheets
               Exploring the User Interface
               Navigating Excel
               Shortcuts for moving the Cell Pointer
               The Microsoft Excel Ribbon
               Excel Dialog Boxes

    Entering and Editing Data in Excel
               Excel Data Types
               Entering Data
               Editing & Deleting Cell Contents
               Undo & Redo in Excel
               Inserting Cells
               AutoFill
               AutoComplete
               Intro to Formatting

    Worksheet Operations in Excel
               Moving and Resizing Microsoft Excel Windows
               Activating a Worksheet
               Adding, Deleting, and Renaming Worksheets
               Zooming In & Out in Excel
               Freezing Window Panes
               Selecting, Adding, Deleting, and Hiding Rows and Columns

    Working with Ranges in Excel
               Finding and Replacing Data
               Copying, Moving, and Cutting Ranges
               Paste Special in Excel
               Adding, Editing, and Removing Hyperlinks
               Excel Cell Notes
               Sort and Filter
               Custom Sort

    Formatting in Excel
               Excel Fonts
               Text Alignment
               Colors and Shading
               Borders and Lines in Excel
               Format Painter

    Saving and Password Protection in Excel
               Creating a New Microsoft Excel Workbook
               Opening an Existing Microsoft Excel Workbook
               Saving a Microsoft Excel Workbook
               Changing the Default File Location
               Password-Protecting a Microsoft Excel Workbook

    Printing in Excel
               Previewing the Printout
               Changing your Page View
               Previewing the Pages
               Creating PDF Files

    Disclaimer: If running Excel 365, Excel 2021, Excel 2019, you'll likely have access to all of the following functions.
    Although, if you're using Excel 2016 or earlier versions, some functions may not be available.

    Intro to Excel Formulas, Functions, and Cell References
               Excel Formulas
               Excel Functions
               Relative & Absolute Cell References
               Mixed References
               Circular References

    Math Functions in Microsoft Excel
               RANDBETWEEN
               ROUND, ROUNDUP, ROUNDDOWN
               INT, TRUNC, ROUND
               MROUND
               FLOOR, CEILING
               ODD, EVEN
               MOD
               SUM, AutoSum, Alt + Plus Sign, Quick Analysis
               Running Total Formula
               SUMIF
               SUMIFS

    Logical Functions in Microsoft Excel
               AND
               IF
               OR
               IFS
               Nested IF
               ISEVEN
               ISODD
               ISBLANK
               ISFORMULA
               ISERROR, IFERROR

    Statistical Functions in Microsoft Excel
               AVERAGE
               MEDIAN
               MODE
               COUNT
               COUNTA
               COUNTBLANK
               COUNTIF
               COUNTIFS
               MAX, MIN

    Text Functions in Microsoft Excel
               UPPER, LOWER, PROPER
               LEN
               TRIM
               Concatenation using the Ampersand symbol (&)
               LEFT, RIGHT, MID
               TEXTBEFORE
               TEXTAFTER
               Text to Columns
               TEXTJOIN
               CONCATENATE
               TEXTSPLIT
               TEXT (including Leading Zeros and Padding Zeros)
               TYPE
               VALUE
               T

    Date & Time Functions in Microsoft Excel
               TODAY
               MONTH
               DAY
               YEAR
               WEEKDAY
               DAYS
               EOMONTH

               NOW
               HOUR
               MINUTE
               SECOND

    Lookup Functions in Microsoft Excel
               XLOOKUP
               UNIQUE
               TRANSPOSE
               VSTACK, HSTACK

    Who this course is for:

    • Anyone looking for a deeper understanding of Microsoft Excel.

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category

    Excel

    Excel Formulas and Functions

    Robert Mathisen
    Robert Mathisen
    Instructor's Courses
    My name is Robert Mathisen.I started tutoring when I was in high school. Not for pay, or anything like that, but simply because there was a friend in the class that needed help.I knew at some point in my career I wanted to become a teacher, but admittedly, I wanted to keep my options open and see what I could do with my Math & Science skills.I went to New Jersey Institute of Technology where I graduated as an Industrial Engineer.I would sit in the front of all my classes, take notes, and do my work.When I learn something new, I take notes in a way that I would explain it to someone else.I was taught at a young age, "If you can explain it to someone else, then you really have the content down pat."In college, it seemed like it was nearly every exam, I would have 5 classmates asking if I would help them prep for the exams.I was, once again, unofficially tutoring my classmates now in my Physics & Engineering classes.They would tell me, "You should be a teacher."This gave me the confidence that I was capable of teaching complex topics.After 4 years in the engineering field, realizing this was not my true passion, I transitioned into becoming a high school teacher.Being an instructor for 7 years, I’ve gained experience teaching on many different learning levels, from students with learning disabilities to those in my honors classes.Working with this range gave me the opportunity to experiment with what works & what doesn’t when I’m teaching a certain topic.And now, I’d like to share the lessons that I’ve learned with you on my Udemy course. I wish you luck and hope you enjoy my course :)
    Udemy
    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.
    • language english
    • Training sessions 172
    • duration 8:58:14
    • Release Date 2024/07/25

    Courses related to Excel

    Subtitle
    MO-200 Microsoft Excel 365/2019 Associate Certification
    Udemy Dave Murphy
    Dave Murphy
    MO-200 Microsoft Excel 365/2019 Associate Certification
    6:34:20
    English subtitles
    06/14/2023
    Excel For Business Analyst
    Udemy Aditya Yadav
    Aditya Yadav
    Excel For Business Analyst
    1:10:32
    07/22/2023
    Formatting an Excel Workbook: practical skills
    Udemy Janet Margaret Rayward
    Janet Margaret Rayward
    Formatting an Excel Workbook: practical skills
    3:48:53
    11/25/2022

    Courses related to Excel Formulas and Functions

    Vlookup - Process Data across multiple MS Excel worksheets
    Udemy Deepak Aggarwal
    Deepak Aggarwal
    Vlookup - Process Data across multiple MS Excel worksheets
    1:30:22
    06/10/2023
    Prompt Flow Engineering with ChatGPT in Excel
    Udemy Mitja Martini
    Mitja Martini
    Prompt Flow Engineering with ChatGPT in Excel
    4:16:01
    07/29/2024
    Learning Excel What-If Analysis
    Linkedin Learning Curt Frye
    Curt Frye
    Learning Excel What-If Analysis
    1:22:19
    01/07/2023