Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Office 365: Excel and Word BUNDLE - Beginner to expert
Rating: 4.5 out of 5(239 ratings)
743 students

Office 365: Excel and Word BUNDLE - Beginner to expert

Master the essentials of the most popular Spreadsheet AND Word Processing tool, Microsoft Excel AND Word 2019
Created byTim Wright
Last updated 6/2020
English

What you'll learn

  • EXCEL: Format your data to look very professional
  • EXCEL: Easily separate and combine data
  • EXCEL: Create shapes like banners and arrows
  • EXCEL: Create and run macros to automate work
  • EXCEL: Use powerful functions and create custom formulas the easy way
  • EXCEL: Format your data to look very professional
  • EXCEL: Easily learn VLOOKUP
  • WORD: Learn the MS Word interface
  • WORD: Working with styles for professional looking documents
  • WORD: Create Headers and Footers and numbered pages
  • WORD: Create and control columns
  • WORD: Insert illustrations, pictures, charts, icons, shapes, Smartart, and 3D graphics
  • WORD: Create tables to organize text
  • WORD: Create standardized and consistent styling
  • WORD: Create numbered and bulleted lists
  • WORD: Print and collaborate online

Course content

27 sections107 lectures13h 30m total length
  • Using the exercise files0:23
  • Introduction to Excel3:14
  • Using the menu system11:00

    Explore Excel's ribbon-based menu system, including the home, insert, page layout, formulas, data, review, and view tabs; learn about dialog boxes, format cells, and the backstage file view.

  • The quick access toolbar4:15
  • Workbooks and worksheets5:55
  • The Formula Bar2:41
  • The Status Bar3:54
  • Using the Navigation tools7:37
  • Using shortcuts and the Mini Toolbar3:25

    Right-click a cell to reveal a mini toolbar with options from home tab, including font and number formatting, decimals, percent, and shortcuts for cut, paste, and format cells via Ctrl+1.

  • Using the Help features3:09
  • Getting familiar with Excel Quiz

Requirements

  • Microsoft Word and Excel 2013, 2016 or 2019 installed on your computer. Word 2019 required for 3D models.
  • No prior Microsoft Word or Excel Knowledge needed

Description

Microsoft Excel and Word Course BUNDLE!

This course was designed to get you up and running with Microsoft Excel AND Microsoft Word as fast as possible. The course covers all the essentials that make up 80% of the day to day work in Excel and Word. Each lesson is carefully crafted to let you easily practice along and build your Excel and Word skills quickly.

This Microsoft Excel and Word course is up to date with all the latest features and enhancements. However it works great with 2019, 2013 and 2010 versions as well.

Enroll now to get over 13 hours and over 100 lessons of professional training!

Comfortable pace and easy English. Great for ESL.

Enroll now to go from a beginner in Excel and  Word to an Intermediate user ready to tackle most day to day work in Excel and  Word. Microsoft Excel is  the most popular spreadsheet program in the world and Microsoft Word is the most popular word processor. I will be your guide using my 15 years experience as an instructional designer to quickly bring you up to speed on Word saving you months and even years of frustration. 

Stop struggling through your daily tasks at work or wishing you had the skills to advance.  Now you can quickly and easily go from beginner to intermediate step-by-step with clear video lessons and easy to use practice files designed just for this course.

When you have finished this course you will be able to perform the most popular  Word functions and features and have the confidence to take on new challenges, responsibilities and opportunities.  

Here are a few of the highly sought after skills you will acquire in Excel

  • Create attractive and effective spreadsheets

  • Sort and format large sets of data

  • Create and format tables quickly

  • Master useful functions like SUM, VLOOKUP, IF, AVERAGE,  and many others

  • Create dynamic Pivot Tables and Pivot Charts

  • Automate your tasks with Macros

  • Secure workbooks and worksheets

  • Use conditional formatting to highlight data

Here are a few of the highly sought after skills you will acquire in Word:

  • Create Headers and Footers and numbered pages

  • Create and control columns

  • Insert illustrations, pictures, charts, icons, shapes, Smartart, and 3D graphics

  • Create tables to organize text

  • Create standardized and consistent styling

  • Create numbered and bulleted lists

  • Print and collaborate online


    Enroll now and take the next step in making a real difference in your career and income potential. You are only a few clicks away from your new future!

Who this course is for:

  • Beginning and Intermediate WORD and Excel users
  • Anyone new to Excel or Word 2019 - 2020