The Easiest Beginners Guide to Microsoft Excel

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course 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.

Each section has been designed so you can take it on it's own. i recommend taking the first section but then after that you can take any section you want in any order! You have complete freedom!


WHAT YOU’LL LEARN IN THIS COURSE

In this course I'll be covering the basics of how to get started, text and cell formatting, number formatting, autosum and count functions, formulas and arithmetic operations, equation generator, symbols, wordart, hyperlinks, organisation techniques, hotkeys, correct sheet use, data management basics, image control, artistic effects, shapes, flowcharts, banners, SmartArt, Data Sorting, Filtering, Charts and styling, PDF printing and anything else I can squeeze in for you!!


100% Money Back Guarantee

If you end up not liking my course, that's ok, I will refund your money back no questions asked even if you've completed a portion of the course. Your satisfaction is my priority!


ABOUT ME

  1. Member of the Udemy Council
  2. Co-Founder of Paperclip Learning
  3. Over 70,000 students
  4. Over 175,000 enrollments
  5. Over 5,300 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

Who this course is for:

  • People who have basic skills with Excel and find it frustrating or difficult to learn. This course uses the simplest language and the shortest videos for easy consumption.
  • Students who have just completed university and have minor skills in Excel. Excel is an absolute requirement for anyone joining the industry. You won't even be taken seriously without it.
  • Job Seekers who are looking to upskill because their current skills have become obsolete
  • Business Professionals who need a leg-up on the competition. Strong skills in Microsoft Excel is crucial which leads to data management abilities; one of the most desired skill sets by employers leading up to 2020

Expected Outcomes

  1. Getting started from absolute basics - Opening and Saving Excel, Screen navigation, Screen Elements Explained, Typing and Deleting Data Text and Cell formatting - Font Selection and Sizing, Bold, Italic and Underline, Border Creation, Horizontal and Vertical Justification, Wrap Texting, Row and Column Adjustment Number Formatting - Decimal Places, Data Types, Decimal Places, Currency and Accounting, Dates, Format Paint AutoSum and Count Function - Application, Average, Minimum, Maximum, Count, Connection Readjustment, Large Table Considerations Formulas - Arithmetic Operations, Cell Linking, BODMAS, Formula Duplication, Fill Handle Equation Creator, Symbols, WordArt and Hyperlinks (File, Workbook and Webpage Options) Data Organisation using Sheets - Do's and Don'ts, Renaming, Reordering, Tab Colouring, Moving, Copying, New Window Function Images - Importation Methods, Moving, Resizing, Rotating, Picture Styling, Artistic Effects, Bring/Send to Front/Back, Cropping Shapes - Textboxes and Formatting, Arrows and Arrow Locking, Shape Proportion Adjustments, Object Rotation, Quick Duplication Techniques SmartArt - Insertion, Indenting and Hierarchies, Colours, Accents, Styles, Layout Changes, Graphic Restting Data Sorting and Filtering - A-to-Z, Z-to-A, Primary Key Theory, Custom Sort by Field Name, Sorting by Colour, Multi-Level Sorting Line Charts - Data Preparation, Chart Elements, Styling Options, Chart Features Printing - Page Breaks, Margin Settings, Orientation, Paper Select, Page Layout, Scaling, Print Tiles, Printing, Portable Document Format (PDF) Show more Show less Requirements Pen and Paper To Take Notes Microsoft Excel 2007 or Later Access to Internet/Computer Description WHAT’S YOUR STORY? Are you a business professional needing to up-skill? Are you struggling to get a pay-rise and/or promotion? Are you a recent graduate with an empty looking resume and no job experience? 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. Each section has been designed so you can take it on it's own. i recommend taking the first section but then after that you can take any section you want in any order! You have complete freedom! WHAT YOU’LL LEARN IN THIS COURSE In this course I'll be covering the basics of how to get started, text and cell formatting, number formatting, autosum and count functions, formulas and arithmetic operations, equation generator, symbols, wordart, hyperlinks, organisation techniques, hotkeys, correct sheet use, data management basics, image control, artistic effects, shapes, flowcharts, banners, SmartArt, Data Sorting, Filtering, Charts and styling, PDF printing and anything else I can squeeze in for you!! 100% Money Back Guarantee If you end up not liking my course, that's ok, I will refund your money back no questions asked even if you've completed a portion of the course. Your satisfaction is my priority! ABOUT ME Member of the Udemy Council Co-Founder of Paperclip Learning Over 70,000 students Over 175,000 enrollments Over 5,300 Positive Reviews 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 Who this course is for: People who have basic skills with Excel and find it frustrating or difficult to learn. This course uses the simplest language and the shortest videos for easy consumption. Students who have just completed university and have minor skills in Excel. Excel is an absolute requirement for anyone joining the industry. You won't even be taken seriously without it. Job Seekers who are looking to upskill because their current skills have become obsolete Business Professionals who need a leg-up on the competition. Strong skills in Microsoft Excel is crucial which leads to data management abilities; one of the most desired skill sets by employers leading up to 2020 Show more Show less Course content 15 sections • 101 lectures • 3h 25m total length Expand all sections Welcome to Excel for Beginners 2 lectures • 1min Course Structure and Delivery Methodology 00:41 My Latest Course! Free for a Limited Time Only 00:19 Getting Started with Excel for New Users 6 lectures • 19min Introduction Preview 00:49 Opening Excel for the First Time Preview 02:34 Saving, Closing and Opening your File Preview 05:19 Screen Elements Explained Preview 05:31 Typing and Deleting Data Preview 01:30 Scrolling and Zooming Preview 03:42 Text and Cell Formatting 10 lectures • 22min Introduction Preview 00:31 Workbook Download 00:15 Font Selection and Font Sizing Preview 03:35 Bold, Italic and Underline Preview 01:43 Cell and Text Colouring Preview 02:51 Border Creation 04:16 Horizontal and Vertical Justification 02:32 Wrap Text and Merging Preview 02:15 Row and Column Adjustment 02:21 Format Clearing 01:34 Number Formatting – Currency, Decimal Places, Dates and More 9 lectures • 17min Introduction Preview 00:38 Workbook Download 00:16 Number Generator Preview 01:32 Number Types Preview 03:36 Decimal Places 02:03 Currency and Accounting 01:02 Dealing with Dates Preview 02:56 Creating Time and Dates 02:52 Format Painter Preview 02:18 AutoSum and Count Functions 6 lectures • 9min Introduction Preview 00:53 Workbook Download 00:12 Applying the AutoSum Preview 01:11 Average, Minimum, Maximum and Count 02:11 Readjusting the Connections Preview 02:09 Applying to Large Tables 02:10 Formulas - Arithmetic Functions 8 lectures • 11min Introduction Preview 00:34 Workbook Download 00:15 Formula Construction - Addition Preview 01:24 Other Arithmetic Functions Preview 01:03 Linking Cells into your Formulas 02:29 Using BODMAS Preview 01:58 Copying Formulas 01:55 Fill Handle 01:34 Inserting Equations, Symbols, WordArt and Hyperlinks 7 lectures • 20min Introduction Preview 00:51 Workbook Download 00:20 Equation Editor (Part I) Preview 04:55 Equation Editor (Part II) 03:41 Symbols Preview 04:00 WordArt 02:49 Hyperlinks Preview 03:32 Increase your Organisation using Sheets 6 lectures • 15min Introduction Preview 00:41 Workbook Download 00:28 How you shouldn't use Sheets Preview 05:56 Renaming, Reordering and Tab Colouring 03:20 Moving and Copying sheets between Workbooks Preview 02:02 New Window Function 02:43 Importing Images, Control and Formatting 7 lectures • 13min Introduction Preview 00:50 Workbook Download 00:19 Importing Images 02:38 Moving, Resizing and Rotating 04:21 Picture Styling and Artistic Effects Preview 02:18 Bring to Front and Back 01:00 Cropping Preview 01:33 Shapes – Text Boxes, Arrows, Squares, Flowcharts, Banners and More 7 lectures • 12min Introduction 00:47 Workbook Download 00:10 Textboxes and Formatting Preview 02:25 Arrows and Arrow Locking 02:53 Shape Proportion Adjustments Preview 02:07 Object Rotation 01:25 Quick Duplications Preview 01:57 5 more sections Instructor Jed Guinto ~445,000 Enrolments, ~185,000 Students, ~12,000 Reviews 4.5 Instructor Rating 12,779 Reviews 191,819 Students 19 Courses WHAT UDEMY HAS SAID ABOUT MY COURSES: 'We looked at some data + feedback from your courses and found you ranked in the top group of instructors on Udemy! Students love taking courses from instructors they trust' PC MAG: 'Jed Guinto is something of an Udemy wunderkind. 'There are all-stars, such as Mr. Guinto, who do well by any metric' WHAT MY STUDENTS SAY ABOUT ME: 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. BIOGRAPHY: Jed Guinto has an academic background in Aerospace Engineering, System/Database Design, Computer Programming and High Density Data Analysis. He has an Advanced Diploma in Aerospace Engineering, a Bachelor's Degree in Aerospace Engineering with Honours and a Graduate Certificate in Engineering Management. He has been trained by some of the brightest and innovative minds in Aerospace, Automotive, Manufacturing, Mechanical and Computer Engineering in the world. In 2011 he traveled to Augsburg, Germany as an Aerospace Engineer and performed Structural Strength Analysis on aircraft's such as the Airbus A320, A330, A340, A350 and the Boeing 747 and developed his programming and automation skills. In 2012 he returned to Australia to tutor and mentor underprivileged and disadvantaged school students in physics, english, biology, chemistry and mathematics. From 2013-14 he was employed by Ford Motor Company as the Asia Pacific and Africa Tooling Systems Engineer. Programs and Databases he developed have been utilized in several countries. During this time, he began teaching Excel online. In 2015, he was awarded the ARC Discovery Grant Scholarship to pursue his study into Nonlinear Vibro-Acoustics for aircraft carbon-composite applications. Part of experience involved working under former NASA Ames Senior Research Engineer Dr. Jon Watmuff in teaching Computational Engineer Analysis methods to undergraduate students. Surveys from the students he taught had a satisfaction rating of 94%. In 2016, he founded Paperclip Learning which teaches Microsoft Excel online. In 2017, he worked at Careers Training Group, an organisation focused on Aged Care and Early Childhood training. His main role was to develop analytic systems to connect people with technology. In 2018, he was recruited by Toyota Australia as part of the Takata Airbag Recall Program; the largest safety recall in automotive history. There he developed the tracking system which manages all recall activities and introduced Business Analytics and Cloud Technology. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678115af29615403',m:'a46436379ec854ff95f5e5a7b885484956572860-1627842071-1800-AS0sPqwr05cvHt+ndrj81Ro6aapTjBMEg/JnYtBMQJ1VXwCn4Ni3NQXfGtgp/LLb3ody9GYuP+MjId+T7JigL0nWsBlLqr7MakXFbxp09MVm0iSqRuTI4qNJ04BfEBNW/AWvqGSX4LFUQ8psyfzyDOJrYkR8e9GOOZdNCFTN3HWe',s:[0x92cadb5a08,0xbad29ddf31],}})();
  2. Text and Cell formatting - Font Selection and Sizing, Bold, Italic and Underline, Border Creation, Horizontal and Vertical Justification, Wrap Texting, Row and Column Adjustment Number Formatting - Decimal Places, Data Types, Decimal Places, Currency and Accounting, Dates, Format Paint AutoSum and Count Function - Application, Average, Minimum, Maximum, Count, Connection Readjustment, Large Table Considerations Formulas - Arithmetic Operations, Cell Linking, BODMAS, Formula Duplication, Fill Handle Equation Creator, Symbols, WordArt and Hyperlinks (File, Workbook and Webpage Options) Data Organisation using Sheets - Do's and Don'ts, Renaming, Reordering, Tab Colouring, Moving, Copying, New Window Function Images - Importation Methods, Moving, Resizing, Rotating, Picture Styling, Artistic Effects, Bring/Send to Front/Back, Cropping Shapes - Textboxes and Formatting, Arrows and Arrow Locking, Shape Proportion Adjustments, Object Rotation, Quick Duplication Techniques SmartArt - Insertion, Indenting and Hierarchies, Colours, Accents, Styles, Layout Changes, Graphic Restting Data Sorting and Filtering - A-to-Z, Z-to-A, Primary Key Theory, Custom Sort by Field Name, Sorting by Colour, Multi-Level Sorting Line Charts - Data Preparation, Chart Elements, Styling Options, Chart Features Printing - Page Breaks, Margin Settings, Orientation, Paper Select, Page Layout, Scaling, Print Tiles, Printing, Portable Document Format (PDF) Show more Show less Requirements Pen and Paper To Take Notes Microsoft Excel 2007 or Later Access to Internet/Computer Description WHAT’S YOUR STORY? Are you a business professional needing to up-skill? Are you struggling to get a pay-rise and/or promotion? Are you a recent graduate with an empty looking resume and no job experience? 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. Each section has been designed so you can take it on it's own. i recommend taking the first section but then after that you can take any section you want in any order! You have complete freedom! WHAT YOU’LL LEARN IN THIS COURSE In this course I'll be covering the basics of how to get started, text and cell formatting, number formatting, autosum and count functions, formulas and arithmetic operations, equation generator, symbols, wordart, hyperlinks, organisation techniques, hotkeys, correct sheet use, data management basics, image control, artistic effects, shapes, flowcharts, banners, SmartArt, Data Sorting, Filtering, Charts and styling, PDF printing and anything else I can squeeze in for you!! 100% Money Back Guarantee If you end up not liking my course, that's ok, I will refund your money back no questions asked even if you've completed a portion of the course. Your satisfaction is my priority! ABOUT ME Member of the Udemy Council Co-Founder of Paperclip Learning Over 70,000 students Over 175,000 enrollments Over 5,300 Positive Reviews 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 Who this course is for: People who have basic skills with Excel and find it frustrating or difficult to learn. This course uses the simplest language and the shortest videos for easy consumption. Students who have just completed university and have minor skills in Excel. Excel is an absolute requirement for anyone joining the industry. You won't even be taken seriously without it. Job Seekers who are looking to upskill because their current skills have become obsolete Business Professionals who need a leg-up on the competition. Strong skills in Microsoft Excel is crucial which leads to data management abilities; one of the most desired skill sets by employers leading up to 2020 Show more Show less Course content 15 sections • 101 lectures • 3h 25m total length Expand all sections Welcome to Excel for Beginners 2 lectures • 1min Course Structure and Delivery Methodology 00:41 My Latest Course! Free for a Limited Time Only 00:19 Getting Started with Excel for New Users 6 lectures • 19min Introduction Preview 00:49 Opening Excel for the First Time Preview 02:34 Saving, Closing and Opening your File Preview 05:19 Screen Elements Explained Preview 05:31 Typing and Deleting Data Preview 01:30 Scrolling and Zooming Preview 03:42 Text and Cell Formatting 10 lectures • 22min Introduction Preview 00:31 Workbook Download 00:15 Font Selection and Font Sizing Preview 03:35 Bold, Italic and Underline Preview 01:43 Cell and Text Colouring Preview 02:51 Border Creation 04:16 Horizontal and Vertical Justification 02:32 Wrap Text and Merging Preview 02:15 Row and Column Adjustment 02:21 Format Clearing 01:34 Number Formatting – Currency, Decimal Places, Dates and More 9 lectures • 17min Introduction Preview 00:38 Workbook Download 00:16 Number Generator Preview 01:32 Number Types Preview 03:36 Decimal Places 02:03 Currency and Accounting 01:02 Dealing with Dates Preview 02:56 Creating Time and Dates 02:52 Format Painter Preview 02:18 AutoSum and Count Functions 6 lectures • 9min Introduction Preview 00:53 Workbook Download 00:12 Applying the AutoSum Preview 01:11 Average, Minimum, Maximum and Count 02:11 Readjusting the Connections Preview 02:09 Applying to Large Tables 02:10 Formulas - Arithmetic Functions 8 lectures • 11min Introduction Preview 00:34 Workbook Download 00:15 Formula Construction - Addition Preview 01:24 Other Arithmetic Functions Preview 01:03 Linking Cells into your Formulas 02:29 Using BODMAS Preview 01:58 Copying Formulas 01:55 Fill Handle 01:34 Inserting Equations, Symbols, WordArt and Hyperlinks 7 lectures • 20min Introduction Preview 00:51 Workbook Download 00:20 Equation Editor (Part I) Preview 04:55 Equation Editor (Part II) 03:41 Symbols Preview 04:00 WordArt 02:49 Hyperlinks Preview 03:32 Increase your Organisation using Sheets 6 lectures • 15min Introduction Preview 00:41 Workbook Download 00:28 How you shouldn't use Sheets Preview 05:56 Renaming, Reordering and Tab Colouring 03:20 Moving and Copying sheets between Workbooks Preview 02:02 New Window Function 02:43 Importing Images, Control and Formatting 7 lectures • 13min Introduction Preview 00:50 Workbook Download 00:19 Importing Images 02:38 Moving, Resizing and Rotating 04:21 Picture Styling and Artistic Effects Preview 02:18 Bring to Front and Back 01:00 Cropping Preview 01:33 Shapes – Text Boxes, Arrows, Squares, Flowcharts, Banners and More 7 lectures • 12min Introduction 00:47 Workbook Download 00:10 Textboxes and Formatting Preview 02:25 Arrows and Arrow Locking 02:53 Shape Proportion Adjustments Preview 02:07 Object Rotation 01:25 Quick Duplications Preview 01:57 5 more sections Instructor Jed Guinto ~445,000 Enrolments, ~185,000 Students, ~12,000 Reviews 4.5 Instructor Rating 12,779 Reviews 191,819 Students 19 Courses WHAT UDEMY HAS SAID ABOUT MY COURSES: 'We looked at some data + feedback from your courses and found you ranked in the top group of instructors on Udemy! Students love taking courses from instructors they trust' PC MAG: 'Jed Guinto is something of an Udemy wunderkind. 'There are all-stars, such as Mr. Guinto, who do well by any metric' WHAT MY STUDENTS SAY ABOUT ME: 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. BIOGRAPHY: Jed Guinto has an academic background in Aerospace Engineering, System/Database Design, Computer Programming and High Density Data Analysis. He has an Advanced Diploma in Aerospace Engineering, a Bachelor's Degree in Aerospace Engineering with Honours and a Graduate Certificate in Engineering Management. He has been trained by some of the brightest and innovative minds in Aerospace, Automotive, Manufacturing, Mechanical and Computer Engineering in the world. In 2011 he traveled to Augsburg, Germany as an Aerospace Engineer and performed Structural Strength Analysis on aircraft's such as the Airbus A320, A330, A340, A350 and the Boeing 747 and developed his programming and automation skills. In 2012 he returned to Australia to tutor and mentor underprivileged and disadvantaged school students in physics, english, biology, chemistry and mathematics. From 2013-14 he was employed by Ford Motor Company as the Asia Pacific and Africa Tooling Systems Engineer. Programs and Databases he developed have been utilized in several countries. During this time, he began teaching Excel online. In 2015, he was awarded the ARC Discovery Grant Scholarship to pursue his study into Nonlinear Vibro-Acoustics for aircraft carbon-composite applications. Part of experience involved working under former NASA Ames Senior Research Engineer Dr. Jon Watmuff in teaching Computational Engineer Analysis methods to undergraduate students. Surveys from the students he taught had a satisfaction rating of 94%. In 2016, he founded Paperclip Learning which teaches Microsoft Excel online. In 2017, he worked at Careers Training Group, an organisation focused on Aged Care and Early Childhood training. His main role was to develop analytic systems to connect people with technology. In 2018, he was recruited by Toyota Australia as part of the Takata Airbag Recall Program; the largest safety recall in automotive history. There he developed the tracking system which manages all recall activities and introduced Business Analytics and Cloud Technology. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678115af29615403',m:'a46436379ec854ff95f5e5a7b885484956572860-1627842071-1800-AS0sPqwr05cvHt+ndrj81Ro6aapTjBMEg/JnYtBMQJ1VXwCn4Ni3NQXfGtgp/LLb3ody9GYuP+MjId+T7JigL0nWsBlLqr7MakXFbxp09MVm0iSqRuTI4qNJ04BfEBNW/AWvqGSX4LFUQ8psyfzyDOJrYkR8e9GOOZdNCFTN3HWe',s:[0x92cadb5a08,0xbad29ddf31],}})();
  3. Number Formatting - Decimal Places, Data Types, Decimal Places, Currency and Accounting, Dates, Format Paint AutoSum and Count Function - Application, Average, Minimum, Maximum, Count, Connection Readjustment, Large Table Considerations Formulas - Arithmetic Operations, Cell Linking, BODMAS, Formula Duplication, Fill Handle Equation Creator, Symbols, WordArt and Hyperlinks (File, Workbook and Webpage Options) Data Organisation using Sheets - Do's and Don'ts, Renaming, Reordering, Tab Colouring, Moving, Copying, New Window Function Images - Importation Methods, Moving, Resizing, Rotating, Picture Styling, Artistic Effects, Bring/Send to Front/Back, Cropping Shapes - Textboxes and Formatting, Arrows and Arrow Locking, Shape Proportion Adjustments, Object Rotation, Quick Duplication Techniques SmartArt - Insertion, Indenting and Hierarchies, Colours, Accents, Styles, Layout Changes, Graphic Restting Data Sorting and Filtering - A-to-Z, Z-to-A, Primary Key Theory, Custom Sort by Field Name, Sorting by Colour, Multi-Level Sorting Line Charts - Data Preparation, Chart Elements, Styling Options, Chart Features Printing - Page Breaks, Margin Settings, Orientation, Paper Select, Page Layout, Scaling, Print Tiles, Printing, Portable Document Format (PDF) Show more Show less Requirements Pen and Paper To Take Notes Microsoft Excel 2007 or Later Access to Internet/Computer Description WHAT’S YOUR STORY? Are you a business professional needing to up-skill? Are you struggling to get a pay-rise and/or promotion? Are you a recent graduate with an empty looking resume and no job experience? 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. Each section has been designed so you can take it on it's own. i recommend taking the first section but then after that you can take any section you want in any order! You have complete freedom! WHAT YOU’LL LEARN IN THIS COURSE In this course I'll be covering the basics of how to get started, text and cell formatting, number formatting, autosum and count functions, formulas and arithmetic operations, equation generator, symbols, wordart, hyperlinks, organisation techniques, hotkeys, correct sheet use, data management basics, image control, artistic effects, shapes, flowcharts, banners, SmartArt, Data Sorting, Filtering, Charts and styling, PDF printing and anything else I can squeeze in for you!! 100% Money Back Guarantee If you end up not liking my course, that's ok, I will refund your money back no questions asked even if you've completed a portion of the course. Your satisfaction is my priority! ABOUT ME Member of the Udemy Council Co-Founder of Paperclip Learning Over 70,000 students Over 175,000 enrollments Over 5,300 Positive Reviews 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 Who this course is for: People who have basic skills with Excel and find it frustrating or difficult to learn. This course uses the simplest language and the shortest videos for easy consumption. Students who have just completed university and have minor skills in Excel. Excel is an absolute requirement for anyone joining the industry. You won't even be taken seriously without it. Job Seekers who are looking to upskill because their current skills have become obsolete Business Professionals who need a leg-up on the competition. Strong skills in Microsoft Excel is crucial which leads to data management abilities; one of the most desired skill sets by employers leading up to 2020 Show more Show less Course content 15 sections • 101 lectures • 3h 25m total length Expand all sections Welcome to Excel for Beginners 2 lectures • 1min Course Structure and Delivery Methodology 00:41 My Latest Course! Free for a Limited Time Only 00:19 Getting Started with Excel for New Users 6 lectures • 19min Introduction Preview 00:49 Opening Excel for the First Time Preview 02:34 Saving, Closing and Opening your File Preview 05:19 Screen Elements Explained Preview 05:31 Typing and Deleting Data Preview 01:30 Scrolling and Zooming Preview 03:42 Text and Cell Formatting 10 lectures • 22min Introduction Preview 00:31 Workbook Download 00:15 Font Selection and Font Sizing Preview 03:35 Bold, Italic and Underline Preview 01:43 Cell and Text Colouring Preview 02:51 Border Creation 04:16 Horizontal and Vertical Justification 02:32 Wrap Text and Merging Preview 02:15 Row and Column Adjustment 02:21 Format Clearing 01:34 Number Formatting – Currency, Decimal Places, Dates and More 9 lectures • 17min Introduction Preview 00:38 Workbook Download 00:16 Number Generator Preview 01:32 Number Types Preview 03:36 Decimal Places 02:03 Currency and Accounting 01:02 Dealing with Dates Preview 02:56 Creating Time and Dates 02:52 Format Painter Preview 02:18 AutoSum and Count Functions 6 lectures • 9min Introduction Preview 00:53 Workbook Download 00:12 Applying the AutoSum Preview 01:11 Average, Minimum, Maximum and Count 02:11 Readjusting the Connections Preview 02:09 Applying to Large Tables 02:10 Formulas - Arithmetic Functions 8 lectures • 11min Introduction Preview 00:34 Workbook Download 00:15 Formula Construction - Addition Preview 01:24 Other Arithmetic Functions Preview 01:03 Linking Cells into your Formulas 02:29 Using BODMAS Preview 01:58 Copying Formulas 01:55 Fill Handle 01:34 Inserting Equations, Symbols, WordArt and Hyperlinks 7 lectures • 20min Introduction Preview 00:51 Workbook Download 00:20 Equation Editor (Part I) Preview 04:55 Equation Editor (Part II) 03:41 Symbols Preview 04:00 WordArt 02:49 Hyperlinks Preview 03:32 Increase your Organisation using Sheets 6 lectures • 15min Introduction Preview 00:41 Workbook Download 00:28 How you shouldn't use Sheets Preview 05:56 Renaming, Reordering and Tab Colouring 03:20 Moving and Copying sheets between Workbooks Preview 02:02 New Window Function 02:43 Importing Images, Control and Formatting 7 lectures • 13min Introduction Preview 00:50 Workbook Download 00:19 Importing Images 02:38 Moving, Resizing and Rotating 04:21 Picture Styling and Artistic Effects Preview 02:18 Bring to Front and Back 01:00 Cropping Preview 01:33 Shapes – Text Boxes, Arrows, Squares, Flowcharts, Banners and More 7 lectures • 12min Introduction 00:47 Workbook Download 00:10 Textboxes and Formatting Preview 02:25 Arrows and Arrow Locking 02:53 Shape Proportion Adjustments Preview 02:07 Object Rotation 01:25 Quick Duplications Preview 01:57 5 more sections Instructor Jed Guinto ~445,000 Enrolments, ~185,000 Students, ~12,000 Reviews 4.5 Instructor Rating 12,779 Reviews 191,819 Students 19 Courses WHAT UDEMY HAS SAID ABOUT MY COURSES: 'We looked at some data + feedback from your courses and found you ranked in the top group of instructors on Udemy! Students love taking courses from instructors they trust' PC MAG: 'Jed Guinto is something of an Udemy wunderkind. 'There are all-stars, such as Mr. Guinto, who do well by any metric' WHAT MY STUDENTS SAY ABOUT ME: 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. BIOGRAPHY: Jed Guinto has an academic background in Aerospace Engineering, System/Database Design, Computer Programming and High Density Data Analysis. He has an Advanced Diploma in Aerospace Engineering, a Bachelor's Degree in Aerospace Engineering with Honours and a Graduate Certificate in Engineering Management. He has been trained by some of the brightest and innovative minds in Aerospace, Automotive, Manufacturing, Mechanical and Computer Engineering in the world. In 2011 he traveled to Augsburg, Germany as an Aerospace Engineer and performed Structural Strength Analysis on aircraft's such as the Airbus A320, A330, A340, A350 and the Boeing 747 and developed his programming and automation skills. In 2012 he returned to Australia to tutor and mentor underprivileged and disadvantaged school students in physics, english, biology, chemistry and mathematics. From 2013-14 he was employed by Ford Motor Company as the Asia Pacific and Africa Tooling Systems Engineer. Programs and Databases he developed have been utilized in several countries. During this time, he began teaching Excel online. In 2015, he was awarded the ARC Discovery Grant Scholarship to pursue his study into Nonlinear Vibro-Acoustics for aircraft carbon-composite applications. Part of experience involved working under former NASA Ames Senior Research Engineer Dr. Jon Watmuff in teaching Computational Engineer Analysis methods to undergraduate students. Surveys from the students he taught had a satisfaction rating of 94%. In 2016, he founded Paperclip Learning which teaches Microsoft Excel online. In 2017, he worked at Careers Training Group, an organisation focused on Aged Care and Early Childhood training. His main role was to develop analytic systems to connect people with technology. In 2018, he was recruited by Toyota Australia as part of the Takata Airbag Recall Program; the largest safety recall in automotive history. There he developed the tracking system which manages all recall activities and introduced Business Analytics and Cloud Technology. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678115af29615403',m:'a46436379ec854ff95f5e5a7b885484956572860-1627842071-1800-AS0sPqwr05cvHt+ndrj81Ro6aapTjBMEg/JnYtBMQJ1VXwCn4Ni3NQXfGtgp/LLb3ody9GYuP+MjId+T7JigL0nWsBlLqr7MakXFbxp09MVm0iSqRuTI4qNJ04BfEBNW/AWvqGSX4LFUQ8psyfzyDOJrYkR8e9GOOZdNCFTN3HWe',s:[0x92cadb5a08,0xbad29ddf31],}})();
  4. AutoSum and Count Function - Application, Average, Minimum, Maximum, Count, Connection Readjustment, Large Table Considerations Formulas - Arithmetic Operations, Cell Linking, BODMAS, Formula Duplication, Fill Handle Equation Creator, Symbols, WordArt and Hyperlinks (File, Workbook and Webpage Options) Data Organisation using Sheets - Do's and Don'ts, Renaming, Reordering, Tab Colouring, Moving, Copying, New Window Function Images - Importation Methods, Moving, Resizing, Rotating, Picture Styling, Artistic Effects, Bring/Send to Front/Back, Cropping Shapes - Textboxes and Formatting, Arrows and Arrow Locking, Shape Proportion Adjustments, Object Rotation, Quick Duplication Techniques SmartArt - Insertion, Indenting and Hierarchies, Colours, Accents, Styles, Layout Changes, Graphic Restting Data Sorting and Filtering - A-to-Z, Z-to-A, Primary Key Theory, Custom Sort by Field Name, Sorting by Colour, Multi-Level Sorting Line Charts - Data Preparation, Chart Elements, Styling Options, Chart Features Printing - Page Breaks, Margin Settings, Orientation, Paper Select, Page Layout, Scaling, Print Tiles, Printing, Portable Document Format (PDF) Show more Show less Requirements Pen and Paper To Take Notes Microsoft Excel 2007 or Later Access to Internet/Computer Description WHAT’S YOUR STORY? Are you a business professional needing to up-skill? Are you struggling to get a pay-rise and/or promotion? Are you a recent graduate with an empty looking resume and no job experience? 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. Each section has been designed so you can take it on it's own. i recommend taking the first section but then after that you can take any section you want in any order! You have complete freedom! WHAT YOU’LL LEARN IN THIS COURSE In this course I'll be covering the basics of how to get started, text and cell formatting, number formatting, autosum and count functions, formulas and arithmetic operations, equation generator, symbols, wordart, hyperlinks, organisation techniques, hotkeys, correct sheet use, data management basics, image control, artistic effects, shapes, flowcharts, banners, SmartArt, Data Sorting, Filtering, Charts and styling, PDF printing and anything else I can squeeze in for you!! 100% Money Back Guarantee If you end up not liking my course, that's ok, I will refund your money back no questions asked even if you've completed a portion of the course. Your satisfaction is my priority! ABOUT ME Member of the Udemy Council Co-Founder of Paperclip Learning Over 70,000 students Over 175,000 enrollments Over 5,300 Positive Reviews 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 Who this course is for: People who have basic skills with Excel and find it frustrating or difficult to learn. This course uses the simplest language and the shortest videos for easy consumption. Students who have just completed university and have minor skills in Excel. Excel is an absolute requirement for anyone joining the industry. You won't even be taken seriously without it. Job Seekers who are looking to upskill because their current skills have become obsolete Business Professionals who need a leg-up on the competition. Strong skills in Microsoft Excel is crucial which leads to data management abilities; one of the most desired skill sets by employers leading up to 2020 Show more Show less Course content 15 sections • 101 lectures • 3h 25m total length Expand all sections Welcome to Excel for Beginners 2 lectures • 1min Course Structure and Delivery Methodology 00:41 My Latest Course! Free for a Limited Time Only 00:19 Getting Started with Excel for New Users 6 lectures • 19min Introduction Preview 00:49 Opening Excel for the First Time Preview 02:34 Saving, Closing and Opening your File Preview 05:19 Screen Elements Explained Preview 05:31 Typing and Deleting Data Preview 01:30 Scrolling and Zooming Preview 03:42 Text and Cell Formatting 10 lectures • 22min Introduction Preview 00:31 Workbook Download 00:15 Font Selection and Font Sizing Preview 03:35 Bold, Italic and Underline Preview 01:43 Cell and Text Colouring Preview 02:51 Border Creation 04:16 Horizontal and Vertical Justification 02:32 Wrap Text and Merging Preview 02:15 Row and Column Adjustment 02:21 Format Clearing 01:34 Number Formatting – Currency, Decimal Places, Dates and More 9 lectures • 17min Introduction Preview 00:38 Workbook Download 00:16 Number Generator Preview 01:32 Number Types Preview 03:36 Decimal Places 02:03 Currency and Accounting 01:02 Dealing with Dates Preview 02:56 Creating Time and Dates 02:52 Format Painter Preview 02:18 AutoSum and Count Functions 6 lectures • 9min Introduction Preview 00:53 Workbook Download 00:12 Applying the AutoSum Preview 01:11 Average, Minimum, Maximum and Count 02:11 Readjusting the Connections Preview 02:09 Applying to Large Tables 02:10 Formulas - Arithmetic Functions 8 lectures • 11min Introduction Preview 00:34 Workbook Download 00:15 Formula Construction - Addition Preview 01:24 Other Arithmetic Functions Preview 01:03 Linking Cells into your Formulas 02:29 Using BODMAS Preview 01:58 Copying Formulas 01:55 Fill Handle 01:34 Inserting Equations, Symbols, WordArt and Hyperlinks 7 lectures • 20min Introduction Preview 00:51 Workbook Download 00:20 Equation Editor (Part I) Preview 04:55 Equation Editor (Part II) 03:41 Symbols Preview 04:00 WordArt 02:49 Hyperlinks Preview 03:32 Increase your Organisation using Sheets 6 lectures • 15min Introduction Preview 00:41 Workbook Download 00:28 How you shouldn't use Sheets Preview 05:56 Renaming, Reordering and Tab Colouring 03:20 Moving and Copying sheets between Workbooks Preview 02:02 New Window Function 02:43 Importing Images, Control and Formatting 7 lectures • 13min Introduction Preview 00:50 Workbook Download 00:19 Importing Images 02:38 Moving, Resizing and Rotating 04:21 Picture Styling and Artistic Effects Preview 02:18 Bring to Front and Back 01:00 Cropping Preview 01:33 Shapes – Text Boxes, Arrows, Squares, Flowcharts, Banners and More 7 lectures • 12min Introduction 00:47 Workbook Download 00:10 Textboxes and Formatting Preview 02:25 Arrows and Arrow Locking 02:53 Shape Proportion Adjustments Preview 02:07 Object Rotation 01:25 Quick Duplications Preview 01:57 5 more sections Instructor Jed Guinto ~445,000 Enrolments, ~185,000 Students, ~12,000 Reviews 4.5 Instructor Rating 12,779 Reviews 191,819 Students 19 Courses WHAT UDEMY HAS SAID ABOUT MY COURSES: 'We looked at some data + feedback from your courses and found you ranked in the top group of instructors on Udemy! Students love taking courses from instructors they trust' PC MAG: 'Jed Guinto is something of an Udemy wunderkind. 'There are all-stars, such as Mr. Guinto, who do well by any metric' WHAT MY STUDENTS SAY ABOUT ME: 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. BIOGRAPHY: Jed Guinto has an academic background in Aerospace Engineering, System/Database Design, Computer Programming and High Density Data Analysis. He has an Advanced Diploma in Aerospace Engineering, a Bachelor's Degree in Aerospace Engineering with Honours and a Graduate Certificate in Engineering Management. He has been trained by some of the brightest and innovative minds in Aerospace, Automotive, Manufacturing, Mechanical and Computer Engineering in the world. In 2011 he traveled to Augsburg, Germany as an Aerospace Engineer and performed Structural Strength Analysis on aircraft's such as the Airbus A320, A330, A340, A350 and the Boeing 747 and developed his programming and automation skills. In 2012 he returned to Australia to tutor and mentor underprivileged and disadvantaged school students in physics, english, biology, chemistry and mathematics. From 2013-14 he was employed by Ford Motor Company as the Asia Pacific and Africa Tooling Systems Engineer. Programs and Databases he developed have been utilized in several countries. During this time, he began teaching Excel online. In 2015, he was awarded the ARC Discovery Grant Scholarship to pursue his study into Nonlinear Vibro-Acoustics for aircraft carbon-composite applications. Part of experience involved working under former NASA Ames Senior Research Engineer Dr. Jon Watmuff in teaching Computational Engineer Analysis methods to undergraduate students. Surveys from the students he taught had a satisfaction rating of 94%. In 2016, he founded Paperclip Learning which teaches Microsoft Excel online. In 2017, he worked at Careers Training Group, an organisation focused on Aged Care and Early Childhood training. His main role was to develop analytic systems to connect people with technology. In 2018, he was recruited by Toyota Australia as part of the Takata Airbag Recall Program; the largest safety recall in automotive history. There he developed the tracking system which manages all recall activities and introduced Business Analytics and Cloud Technology. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678115af29615403',m:'a46436379ec854ff95f5e5a7b885484956572860-1627842071-1800-AS0sPqwr05cvHt+ndrj81Ro6aapTjBMEg/JnYtBMQJ1VXwCn4Ni3NQXfGtgp/LLb3ody9GYuP+MjId+T7JigL0nWsBlLqr7MakXFbxp09MVm0iSqRuTI4qNJ04BfEBNW/AWvqGSX4LFUQ8psyfzyDOJrYkR8e9GOOZdNCFTN3HWe',s:[0x92cadb5a08,0xbad29ddf31],}})();
  5. Formulas - Arithmetic Operations, Cell Linking, BODMAS, Formula Duplication, Fill Handle Equation Creator, Symbols, WordArt and Hyperlinks (File, Workbook and Webpage Options) Data Organisation using Sheets - Do's and Don'ts, Renaming, Reordering, Tab Colouring, Moving, Copying, New Window Function Images - Importation Methods, Moving, Resizing, Rotating, Picture Styling, Artistic Effects, Bring/Send to Front/Back, Cropping Shapes - Textboxes and Formatting, Arrows and Arrow Locking, Shape Proportion Adjustments, Object Rotation, Quick Duplication Techniques SmartArt - Insertion, Indenting and Hierarchies, Colours, Accents, Styles, Layout Changes, Graphic Restting Data Sorting and Filtering - A-to-Z, Z-to-A, Primary Key Theory, Custom Sort by Field Name, Sorting by Colour, Multi-Level Sorting Line Charts - Data Preparation, Chart Elements, Styling Options, Chart Features Printing - Page Breaks, Margin Settings, Orientation, Paper Select, Page Layout, Scaling, Print Tiles, Printing, Portable Document Format (PDF) Show more Show less Requirements Pen and Paper To Take Notes Microsoft Excel 2007 or Later Access to Internet/Computer Description WHAT’S YOUR STORY? Are you a business professional needing to up-skill? Are you struggling to get a pay-rise and/or promotion? Are you a recent graduate with an empty looking resume and no job experience? Have you recently been laid off, fired or had a contract end? If you answered 'yes' to any of the a