Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Awesome MS Office Tips You Must Know to Thrive @ Workplace
Rating: 4.3 out of 5(497 ratings)
11,432 students
Created byDr. Adrian Low
Last updated 9/2017
English

What you'll learn

  • Efficiently and Effectively apply the techniques of automating Excel Functions by combining two or more functions, without changing the formulas all the time when stakeholders require of it.
  • Efficiently apply the latest techniques of Flash Fill which the majority of people not know about and finish their work within seconds
  • Efficiently apply the fill down function to fill down thousands of empty cells
  • Able to harness the power of Microsoft word secrets to manage their document tables
  • Able to harness the power of Excel functions to massage their unprocessed data into useful and well-informed information
  • Able to translate the skills derived from this workshop to other similar situations experienced at the workplace

Course content

1 section • 5 lectures • 35m total length

  • Awesome Tips #1: Using Formulas without messing the data11:19

    In this session, you will learn how to use Excel formulas without messing up the data in some of the cells.
     Please download the file and use this file for the rest of the course.

  • Awesome Tips #2: Automatic Fill Down4:10

    In this session, you will learn how to fill down all the empty cells with the information that is above. This is very crucial for creating a good and healthy set of data, known as "data massaging."

  • Awesome Tips #3: Say Goodbye to Text Functions7:45

    In MS Excel 2010 and before, text functions have been a hassle for many when we want to perform data extractions. But in Excel 2013 and beyond, we can start to say Goodbye to Text Functions. This session will give you some examples of a wonderful and miraculous way to extract data without using Text Functions.

  • Awesome Tips #4: More Goodbyes to Text Functions5:15

    In this session, we will continue with saying goodbye to Text Functions. You'll learn how to combine data from different cells into one cell without using Text Functions.

  • Awesome Tips #5: Automatic Tables6:59

    When it comes to MS Word, many users have difficulty managing their tables. This session will show you an ingenious way of managing tables automatically, with hidden features of MS Word.

Requirements

  • Nope

Description

*****You don't have to attend LONG HOURS of EXCEL....as compared with other EXCEL courses, ALTHOUGH the Course is just 30 Minutes, but because of the quality concepts and skills, it can be used within your lifetime!

Awesome MS Office Tips You Must Know to Thrive @ Workplace - In this 30-minute session, you'll learn Adrian's step-by-step method for MS Office such as Word and Excel that is used on a daily basis. 

  • If you are an accountant, secretary, lawyer, administrator, manager or someone who is seeking a new job or career change, having these survival skills will make a difference at the workplace.

  • If you have totally no experience with technology or Microsoft office, these awesome tips are also for you to be quickly equipped with the skills to survive at the workplace.

  • Even if you have had experience or knowledge with Microsoft office, these tips are for you too, to harness the power of Microsoft office to thrive at your workplace.

  • At the end of the course, you will be equipped with the most frequently used text functions or short-cut keys to increase your workplace productivity 100-fold. Looking forward to touch base with you on the inside. 

*****You don't have to attend LONG HOURS of EXCEL....as compared with other EXCEL courses, ALTHOUGH the Course is just 30 Minutes, but because of the quality concepts and skills, it can be used within your lifetime!




Who this course is for:

  • Anyone who is looking to harness the power of productivity with a couple of awesome tips from Word and Excel.

Report abuse