Maximize your Organisational Skills using Excel Sheets

Master sheet control, duplication & transfer techniques giving you full data and maximized organisational abilities!

4.45 (506 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
23,173
students
40 mins
content
Jan 2015
last update
$29.99
regular price

What you will learn

Adding new sheets

Deleting sheets

Renaming sheets

Changing the tab colouring

Reordering sheets

Copying sheets

Hiding and Unhiding sheets

Protecting sheets

Window tiling

Dashboard creation

Column chart creation

Line chart creation

Sparklines creation

Description

WHAT’S YOUR STORY?

  1. Are you a business professional needing to up-skill?
  2. Are you struggling to get a pay-rise and/or promotion?
  3. Are you a recent graduate with an empty looking resume and no job experience?
  4. Have you recently been laid off, fired or had a contract end?

If you answered 'yes' to any of the above then having “Expert Microsoft Office Skills” will get you closer to your goal of either landing your first job, a new job or progressing further in your current role. Here's why. 

The job market has never been more volatile. Statistically, people are changing jobs more often now than they ever have before and that also means people are also losing jobs to newcomers who are far more skilled. So if you’re not up-skilling, you’re falling behind. It’s scary I know. I’ve experienced this myself.

A study released by Microsoft and the IDC showed that among 14.6 million job postings, proficiency in Microsoft Office was ranked 2nd as the most desired skills by employers leading up to 2020. Microsoft Office proficiency ranked higher than Project Management skills, Sales Experience, Time Management, Analytical Skills, Interpersonal Skills and Work Ethics.

This is because we live in the digital age, meaning employers are looking for proficient data handlers who process data faster, are more data-organised and can communicate effectively via digital channels. These are skills everyone should have no matter the discipline because they are transferable skills. It makes you more adaptable and more valuable in the long-term. This brings us back to Microsoft Office. It is the oldest, most well-known, most affordable and most trusted data management tool available and hence everyone uses it. So to be noticed and taken seriously in your job or job application, proficiency in these programs is compulsory.

 

ONLINE TRAINING AND THE MOST COMMON PROBLEMS

One of the most common problems with online learning content is that there is so much of it now and it’s difficult to know where to start or who to turn to. Many go the YouTube route and piece together videos from hundreds of tutorials from hundreds of tutors hoping to become an expert at the end of it all. This simply won’t happen and will just waste your time.

Many take the route you’re about to take, they decide to enroll in an online training course. Many charge hundreds, sometimes thousands of dollars for their courses which is simply unaffordable for university students, recent graduates, the unemployed or those looking for a career change. That is the reason why I have decided to keep this course as low as possible even though I’m offering substantially more content than most of my competitors here on Udemy.

 

COURSE DELIVERY STYLE

I have been using Microsoft Office for over 20 years. I know the in’s and out’s and the simplest ways of doing things. My delivery philosophy is simple, if I can’t get a 6 year old to follow along and understand, than I’m not teaching correctly. I hate complicated language and so do you. Nobody likes trainers who focus on impressing rather than teaching and giving value to students. That is also why my lecture videos are as short as can be and divided into small sections for easy consumption. So you won’t get unnecessary chit chat or nonsense. I also assume that all my students are near-sighted and as such, I use a special software tool that allows me to draw on the screen to show exactly what I’m about to press as well as zoom in on small area’s so you don’t miss a thing.


WHAT YOU’LL LEARN IN THIS COURSE

People simply don't use Sheets enough on Excel. Microsoft Excel sheets allows you to control and organise all your data very efficiently. Instead of having heaps and heaps of files, you can organise them within the same document.

So I'm going to teach you everything you need to know about Sheets. This includes how create, delete, rename, reorder, transfer, hide, unhide and protect them. I'll then show you as a bonus how to create your own very simple dashboard via the use of multiple sheets!


ABOUT ME

  1. Member of the Udemy Council
  2. Co-Founded Paperclip Learning which teaches Microsoft Office
  3. Over 60,000 students
  4. Over 130,000 enrollments
  5. Over 5,000 Positive Reviews
  6. Over 20 courses on Udemy

Teaching is my passion and my creative outlet. I have been using the Microsoft Office package since I was a child and have been using it consistently throughout my life. My teaching experiences span from teaching primary school students, high school students, university graduates and business professionals. Professionally, I am trained in Aerospace Engineering, Database Design and Business Analytics.


TESTIMONIALS

Yu Hui Jun Yu - The courses are simply amazing and I can learn them rapidly. The hints presented were also very useful. I like the 'mini-lesson' format. Fast and efficient. The instructor's direction is very detailed and easy to understand. I can immediately start using this program. Thanks!

Narayanan Krishnamoorthy - Perfect and to the point...the instructor doesn’t waste time and gets to the point quickly!!

Lala Darchinova - I've been looking for this kind of course for ages! And finally I find it. Short, comprehensive and absolutely interesting! Thank you for the work you are doing.

Spencer Berkman - Extremely knowledgeable and clear on instructions.

E Frank - Simple to learn techniques and instructor made it all really easy. Thank you!

Parth Gandhi - I learned techniques in a very short time...no need to google and waste time finding the perfect approach

Content

Demonstration

Demonstration
Supplementary File download
My Latest Course! Free for a Limited Time Only

Using Sheets

What are sheets
Adding a new sheet
Deleting a sheet
Renaming a sheet
Changing the tab colour
Reordering the sheets
Copying a sheet
Hiding and Unhding a sheet Explained
Hiding and Unhiding a sheet

Bonus Features - Protection and Creating a Dashboard

Protecting Sheets
Tiling the window for multiple sheets
Creating a simple dashboard - Step 1 - Line and Column Charts
Creating a simple dashboard - Step 2 - Sparklines
Creating a simple dashboard - Step 3 - Split Window

Congratulations

All My Courses!
Help Me Inspire More People!
Congratulations
Check us out on Facebook!

Screenshots

Maximize your Organisational Skills using Excel Sheets - Screenshot_01Maximize your Organisational Skills using Excel Sheets - Screenshot_02Maximize your Organisational Skills using Excel Sheets - Screenshot_03Maximize your Organisational Skills using Excel Sheets - Screenshot_04

Reviews

Khaled
March 6, 2018
The course is short and sweet one, some features are really very helpful and i did not know about it before.
Holly
November 9, 2017
The title makes it sound like it is more than a basic Excel tutorial. Any basic Excel course has this info. There's nothing to help maximize organizational skills! Use your money for a complete Excel course.
Belvai
August 11, 2017
Instructor is engaging & very knowledgeable on the topic. I'm learning new things which is my objective for enrolling in the course.
Ydebell
October 18, 2015
This is just not a worksheet review. There are many ways to present numerical data and statistics in a clear and concise form. I can see myself using excel as part of my grant writing processes.
Teresa
September 2, 2015
Jed is easy to understand and makes learning Excel so much easier. I wish I would have discovered these courses a LONG time ago! Thank you!
Phil
August 21, 2015
Really enjoyed this course, particularly the split screen and dashboard sections...... a real taster for the advanced courses available.
Jonathan
July 6, 2015
He was very clear with how to do each function. However, the course is very skimpy as far as content and honestly the entire course should be part of a section in another course. Layout is way too simplified. This content could all be in one video.
Jozsef
May 28, 2015
I have learned and refreshed some of my knowledge, The course is very good, comprehensive and a lot of well structured information. Amazing Teacher, Thanks Jed
Ben
April 19, 2015
Jed's teaching style is informative and engaging, with useful information that is applicable to a wide range of functions. Thanks!
Julia
March 30, 2015
I get it, it's free. But my honest opinion is that, as far as format, I'd like a longer stretch of learning before being interrupted. Content seems good, actual presentation is very good. This particular course is probably too basic for me, possibly too basic for the average 8th grader. Pretty sure my kids already know how to create, copy, rename, color, etc tabs. We'll see what lies ahead...I've been asked to review after like, 3 one to two minute subsections.
Sonwon
March 23, 2015
I am new to Udemy and revamp my excel skills, reviewing things through Jed's excel classes, it's been great helpful. thanks!
RICARDO
March 17, 2015
What I like about the lectures is that the instructor does not deviate from the subject stated in the title of the lecture. That allows me to get used to the fact that what the lecture title says will teach, is what I will learn.
Misti
February 10, 2015
I have now taken multiple courses from this instructor. I have understood everything he has demonstrated. I know time is tight for everyone. Jed Guinto's course are worth the time. Not only because you know more when you're finished but also because he gets to the point. He tells you what he is about to cover so you have a heads up before he just starts explaining things. Very handy for note taking!
sanjay
February 6, 2015
Best Course in short span you can acquire skill without going through books, good quality of voice and contents
Brian
February 3, 2015
I would recommend this course to anyone that looking to enhance their skills in Microsoft Excel. Really enjoyed this course and the instructor was very easy to follow. Thanks!

Charts

Price

Maximize your Organisational Skills using Excel Sheets - Price chart

Rating

Maximize your Organisational Skills using Excel Sheets - Ratings chart

Enrollment distribution

Maximize your Organisational Skills using Excel Sheets - Distribution chart

Related Topics

384442
udemy ID
1/4/2015
course created date
11/2/2019
course indexed date
Bot
course submited by