Awesome MS Office Tips You Must Know to Thrive @ Workplace
3.5 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,187 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Awesome MS Office Tips You Must Know to Thrive @ Workplace to your Wishlist.

Add to Wishlist

Awesome MS Office Tips You Must Know to Thrive @ Workplace

Awesome MS Office Tips You Must Know to Thrive @ Workplace
New
3.5 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,187 students enrolled
Created by Adrian Low
Last updated 9/2017
English
Price: Free
Includes:
  • 35 mins on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • Nope
Description

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. 

Bonus* -- I will regularly add new tips into this course for you.



Who is the target audience?
  • Anyone who is looking to harness the power of productivity with a couple of awesome tips from Word and Excel.
Compare to Other Microsoft Office Courses
Curriculum For This Course
+
Introduction
5 Lectures 35:28

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 #1: Using Formulas without messing the data
11:19

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 #2: Automatic Fill Down
04:10

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 #3: Say Goodbye to Text Functions
07:45

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 #4: More Goodbyes to Text Functions
05:15

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.

Awesome Tips #5: Automatic Tables
06:59
About the Instructor
Adrian Low
3.5 Average rating
2 Reviews
1,187 Students
1 Course
Technology Coach / Psychologist

An I/O & Clinical psychologist by profession and throughout the past 7 years, Adrian has been observing microsoft gurus and was able to translate their technical skills into instructional elements that are down-to-earth, plain simple and easy to follow. Adrian has trained over ten thousands of students from all walks of life, from accountants to lawyers to secretaries, university students and even domestic workers.