Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
MS Excel (Beginners & Advanced): Fast Track Training
Rating: 4.4 out of 5(95 ratings)
3,606 students

MS Excel (Beginners & Advanced): Fast Track Training

Learn how to master MS Excel (Beginners & Advanced) methods quickly and easily for yourself or business.
Created byDouglas Melvin
Last updated 7/2020
English
English [Auto],

What you'll learn

  • How To Easily Master MS Excel Beginners and Advanced
  • How To Optimize MS Excel For Best Results
  • Brand New Over-The-Shoulder Video Series For MS Excel Beginners and Advanced
  • Upgrade Your Skills And Expertise With Our Beginners and Advanced Video Training

Course content

3 sections • 42 lectures • 1h 40m total length

  • Overview - Beginners0:52

    Explore Microsoft Excel to turn numbers and words into insights. Learn to create and manipulate spreadsheets using the File, Home, Insert, Page Layout, Formulas, Data, Review, and View menus.

  • Interface3:54

    Navigate the Excel interface, mirroring other Office apps, and use the formula bar and address bar to edit cells, add and rename sheets, adjust zoom, and explore panels and menus.

  • File Menu - Part 12:27

    Use the file menu info tab to edit metadata like author, company, and brand, and define a named region for web visibility of worksheets.

  • File Menu - Part 23:46

    Navigate the file menu to start with a blank workbook or templates, open existing documents, and save, print, and share via cloud drive or email.

  • Home Menu4:46

    Master the excel home menu to manage clipboard operations, paste with ctrl v, apply text and font formatting, adjust alignment, format numbers with conditional formatting, and insert or delete cells.

  • Insert Menu4:18

    Explore the Excel insert menu to clear cells, insert content, create charts and pivot tables, and add visuals such as map charts, 3D maps, hyperlinks, text boxes, and symbols.

  • Page Layout Menu4:18

    Explore the excel page layout menu to format print areas, themes, colors, fonts and effects, set margins and orientation, and preview and print clean, presentation-ready spreadsheets.

  • Formulas Menu3:44

    Explore the formulas menu to power a cell, using auto sum and average, and apply financial formulas like future value, internal rate of return, and net present value.

  • Data Menu - Part 11:52

    Use the data menu to pull data from files, databases, analysis services, or online sources, then load text or CSV data into a new sheet in Excel.

  • Data Menu - Part 22:36

    Master the data menu's sort and filter tools, sorting numeric and text data, filtering with dropdowns, and removing duplicates. Explore what-if analysis, forecasting, and data organization through grouping or consolidating.

  • Review Menu2:34

    Explore the review menu in Excel to protect workbooks, set sheet permissions, and designate editable ranges with passwords, enabling controlled collaboration and secure formula edits.

  • View Menu2:26
  • Templates2:22

    Discover built-in and online templates in Excel to start a new workbook, including budget templates like expense trends and marketing event budgets.

  • Dates3:19

    Select the row, right-click, and open format cells to set date formatting. Choose date or custom and display month and year with four ms and four ys.

  • Numbers4:14

    Format numbers in Excel by column or row using format cells, choose currency or percentage and decimal places, then convert to percent with a simple formula.

  • Text1:10

    Learn to enter text in any Excel cell or address bar, distinguish text from labels, format with bold, italic, underline, adjust column width, and use text and logical area formulas.

  • Calculations - Manual 11:29

    Master how to perform calculations in Excel by using formulas and functions in any cell, including summing a range from E4 to E16.

  • Calculations - Manual 22:46

    Learn to create manual formulas in any Excel cell using the equals sign and operators like the asterisk, then see how changes, additions, and parentheses affect results.

  • Page Set Up2:07

    Use Excel's page setup to choose orientation, adjust margins, add headers and footers, enable gridlines and headings, and set or clear the print area for horizontal and vertical centering.

  • Print Settings1:40

    Master Excel print settings to choose the entire workbook, the active sheet, or a selection; ignore the print area, and adjust orientation, margins, and scaling to fit on one page.

  • Conclusion - Beginners1:24

    Master the basics of Excel menus, print exact areas, and save as PDF. Import templates, adjust headers, share workbooks, and export for digital delivery.

Requirements

  • A computer with internet access
  • A willingness to learn and take action
  • MS Excel Installed On Your Computer
  • Anyone with basic or advanced IT skills

Description

**By popular demand I have decided to combine all of my (Beginners & Advanced) courses together into one package for my students, as there are important lessons to learn in both courses which I feel should not be missed**


MS Excel (Beginners & Advanced): Fast Track Training:


Upgrade Your Skills And Expertise With Our Advanced Video Training…

Here's What You'll Learn In These Upgraded Video Series:

  • How to convert your data into graphics and how to make good use of it.

  • Learn how to work with multiple sheets at once to speed up your time.

  • Learn the different techniques involved in creating Excel books like the pros do.

  • Useful tips to become more productive when using MS Excel.

  • Learn the some hidden features within this application to speed up your work.

  • Integrating your work with other applications.

  • Work smarter and accomplish more by using these secret advices that only a few know about.

  • And many more...

Do you have a large amount of data?

Brand New Over-The-Shoulder Video Series On Quickly & Easily Organize & Manage Huge Amounts Of Data Using MS Excel.

Are you looking for an easy to use software that can store and retrieve all your financial data in just a few clicks?

If the answer is YES...

then I have good news for you...

Heard of MS Excel?

Excel is the most popular program for managing and reporting data.

This is largely due to its availability. All computers with windows have MS Excel installed in them.

It is also available on Mac OS, on different mobile devices.

With the latest version of Office, Office 365, Excel has become available online.

This means that users have access to the program from a range of devices, from almost any location.

MS Excel is used by over 1.2 billion people on the planet and if you don't know how to use it yet, then you're missing out big time.

Before we go any further, let me give you some insights about MS Excel:

1. Excel is a well known spreadsheet creating and editing software.

2. Excel was released by Microsoft in 1985. The initial contract was exclusive to Apple, it was not until two years later that the PC version was released.

3. In 1991, Microsoft released Excel 3.0 which was the first software to use the modern toolbar.

4. Since the 2003 version, over 1.2 billion users use Excel on a daily basis.

5. Using the functions and formulas on Excel, users can automatically calculate and update the results on their spreadsheets.

6. With basic programming skills, it is possible to use Excel and Visual Basic to create applications that manage tasks, analyse data and add interactive properties on a spreadsheet.

7. The 2007 Excel version introduced the ability to save documents in different formats including XLSX files.

8. Excel can be used together with some of the Microsoft office tools.

Why You Need To Get Started Now:

Excel helps you get your work done efficiently.

Put together amazing charts and diagrams with Excel.

Use Excel to stay on top of the trends.

Availability and convenience of Excel.

Bring and work on data on one platform.

Manage & Report With Excel Store, Manage & Retrieve Financial Data In Just Clicks!

There’s nothing like this video series.

Watch as I show you how to get started with Ms Excel.

I reveal my best tips for using some unknown tactics that only a few elite few knows.

You get to see everything. I explain everything to you.

There will be no guesswork.

All you need is just a short hour of your time to learn everything and you’d be ready to get started with it instantly.

Here’s What You’ll Discover Inside This Video Training:

  • How to get started with MS Excel.

  • Learn how to get use to the interface and configure your settings.

  • Learn how to create your first sheet and what are the options to select when doing it.

  • Learn how to work with MS Excel templates and properties.

  • How to quickly and easily work with text, formula and others.

  • How to format attractive excel sheets that prints awesomely well.

  • How to use the configuration settings and organize your data properly before working.

  • And so many more...


xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

MS Excel For Beginners Fast Track Training:

1  Overview

2 Interface

3 File Menu Part 1

4 File Menu Part 2

5 Home Menu

6 Insert Menu

7 Page Layout Menu

8 Formulas Menu

9 Data Menu Part 1

10 Data Menu Part 2

11 Review Menu

12 View Menu

13 Templates

14 Dates

15 Numbers

16 Text

17 Calculations Manual 1

18 Calculations Manual 2

19 Page Set Up

20 Print Settings

21 Conclusion Beginners

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

MS Excel Advanced: Fast Track Training:

22 Overview - Advanced

23 Calculations - Absolute References

24 Calculations - Relative References

25 Using Logical Formulas

26 Using Text Formulas

27 Using Lookup Formulas

28 Using Financial Formulas

29 Using Date and Time Formulas

30 Sorting Data

31 Formatting Data into Tables

32 Using Pivot Tables Part 1

33 Using Pivot Tables Part 2 Design

34 Formatting Data as Charts

35 Formatting As Data as Maps

36 Formatting Data as Formal Reports

37 Formatting Data for Other Office Documents

38 Cell Protection and Collaboration Part 1

39 Cell Protection and Collaboration Part 2

40 Interface with Google Sheets

41 Conclusion Advanced

Who this course is for:

  • All MS Excel Students
  • Anyone who want to master MS Excel
  • Professionals, Business Owners, Internet Marketers, Entrepreneurs, Hobbyists
  • If you need a reliable processing software that will help you create great documents

Report abuse