Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel

Learn Microsoft Excel 2016 in 1 Hour (+12 Excel Templates)

Master Microsoft Excel 2016 in 1 hour, elite step-by-step formula transforming beginners into Experts in Excel.
Rating: 4.1 out of 54.1 (47 ratings)
2,812 students
Created by How To Technology
Published 8/2015
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Create a variation of graphs and charts which can be used in real life scenarios.
  • Manipulate data the way you want.
  • Produce captivating and stunning pivot tables to perfectly analyse and sort data.
  • Apply calculations, functions and formulas to boost productivity with spreadsheets.

Requirements

  • No previous knowledge of Excel required - This course will teach you everything you need to know to go from beginner to expert.
  • A willingness to learn Excel.
  • A working environment where you will not be disturbed.
  • A working computer which allows internet access.
  • Microsoft Excel 2016 installed and ready to use on your computer.

Description

How great would it be if you could learn Microsoft Excel in just 1 hour? Well that is now possible. You will be transformed from a beginner to an expert in Excel in just 1 hour, following 4 easy and simple steps.

Why should you take this course?

"I found this course very helpful. I have been struggling for 2 weeks trying to figure out Excel myself, trying to learn how to move around menu board only to get more and more frustrated. This course has been a blessing, no more frustration no more high blood pressure from stress. Excellent presentation and easy to understand." - Sandra Lee (student)


We Have trained 1000s of beginners Excel, where they have immediately been able to apply what they have learnt within this course.

Here we welcome you to the Learn Microsoft Excel 2016 in 1 hour course, where you will learn how to use Excel in real life scenarios based on a variety of case studies.

"I wanted a course that gets straight to point and I got it. The instructor's delivery is very good and provides good explanations on how different parts of excel work. Didn't think I could get through so much in just 1 hour. Nice and concise course." - Emma Morgan (student)


Guarantee: By the end of this course you will be able to use Excel in real life scenarios within just 1 hour.

Excel can be used for…

  • Scheduling
  • Pay roll systems
  • Weekly planners
  • Invoices
  • Bookkeeping
  • Budget keeping
  • Sorting and listing data
  • Employee and customer data
  • Almost anything that uses and requires data

And the best part is you can even use it at…

  • Work
  • Home
  • An educational establishment
  • Or just for fun - the possibilities are unlimited!


In our Learn Microsoft Excel 2016 in 1 Hour course we will give you the blueprint for getting the most out of Excel. Even if you are completely new to Excel the simple step by step video tutorials, instructions and material will give you thorough guidance - everything you need in just 4 easy steps.

No more feeling stressed and overwhelmed, as our fully accredited Microsoft certified instructors will provide all the answers to how Excel operates; we will focus on…

  • Creating spreadsheets which will turn you into an Excel expert in less than 1 hour
  • Applying Excel to real life situations to enhance your results in your working environment
  • Implementing the correct tools that will skyrocket your productivity by at least 33%


Plus you will receive 1 additional Bonus for enrolling…

Bonus: The 4 Step Excel 2016 Functions Guide - makes using functions and formulas easy and simple.

The 30 Day Money Back Guarantee

As always, we offer our 30 day money back guarantee. Providing value is of the utmost importance to us and if you are not receiving the results you desire then we will ensure to refund you for the course.

Special Introductory Price - Rising Soon

Normally we usually charge $397, $697 and $997 for our Excel courses, but we will keep this special introductory price before increasing it, just for the Udemy community.

Enroll and Take Action

Join now and make the commitment of going through our course. It is sure to enhance your skills and level of knowledge with Excel.

We look forward to seeing you in the course and remember to check out our previews.

See you then

How To Technology

Who this course is for:

  • If you want to become a guaranteed job ready Excel expert.
  • If you want to learn Excel in the fastest way possible.
  • If you want an easy, clear and no-nonsense guide to learning Excel.
  • If you want to refresh your memory and understanding of Excel.
  • If you want to take your knowledge and skills of Excel to the next level.

Course content

10 sections • 72 lectures • 1h 34m total length

  • Preview00:59
  • Preview00:56
  • Preview03:47
  • Excel Step #2 - This Is Why The Quick Access Toolbar Is Remarkable
    02:18
  • Action Step
    00:36

  • Work Files - Download These
    00:06
  • Overview
    00:33
  • Workbook Phase #1 - Creating A New Workbook
    01:09
  • Preview01:43
  • Workbook Phase #3 - Navigating Within A Workbook
    01:08
  • Why Worksheets Are Superior - Adding, Removing & Renaming Worksheets
    00:34
  • Warning! Extreme Time Saving With Copying & Moving Worksheets Between Workbooks
    01:33
  • Bonus Step - Hide Or Unhide Worksheets?
    00:32
  • Action Step - Start Working With Workbooks & Worksheets
    00:24

  • Overview
    00:36
  • Preview01:51
  • Elite Step #2 - Easily Edit Data
    01:15
  • Elite Step #3 - Working Wonders With Copy, Cut And Paste
    02:56
  • Elite Step #4 - Drag And Drop
    01:28
  • The Perfect Arrangement - Adding & Deleting Columns And Rows
    02:07
  • Find And Replace - Simple But Very Effective
    01:35
  • Timeless Secret - Adjusting Columns & Rows
    01:07
  • Case Study - "Now How Do I Sort Out This Data?"
    03:20
  • Action Step - Edit & Enter That Data
    00:19

  • Overview
    00:28
  • Formatting Cells #1 - Making Your Presence Known With Borders
    01:09
  • Preview01:28
  • Wrapping Text - A Great Boon Allowing Multiple Lines In Cells
    00:36
  • 3 Key Basics - Font Size, Color & Text
    01:03
  • Fundamental Format #1 - Using the Date Format
    01:37
  • Fundamental Format #2 - Working With The Number Format
    00:59
  • Case Study: Table Creation Made Easy
    02:34
  • Action Step - Time For Some Formatting
    00:19

  • Overview
    00:24
  • Formula Basics #1 - Addition And Subtraction Formulas
    01:57
  • Formula Basics #2 - Multiplication And Division Formulas
    02:02
  • Important - Understanding The SUM Function
    02:13
  • Save More Than 33% Of Your Time By Copying Formulas
    01:15
  • Why You Must Know Absolute Cell Referencing
    02:11
  • Boost Results By Using Formulas Across Worksheets
    01:17
  • Excel Secret #1: VLOOKUPS
    03:08
  • Excel Secret #2: IF STATEMENTS
    02:09
  • Bonus Material: 4 Step Excel 2016 Functions Guide
    2 pages
  • Midterm
    4 questions
  • Action Step - Test Out Those Functions And Formulas
    00:28

  • Overview
    00:22
  • Part #1 - Adding Authority With Print Titles
    01:20
  • Hidden Tip #1 - Save Paper By Using Print Area
    01:06
  • Part #2 - Knowing The Correct Orientation And Paper Size
    00:58
  • Hidden Tip #2 - Print More On A Page With Margins
    01:33
  • Part #3 - How Scaling Will Give You Full Control Of Your Printing
    01:40
  • Headers And Footers - Give Your Work An Identity
    03:04
  • Case Study - All You Need To Know About Printing
    03:43
  • Action Step - Let's Get Printing
    00:24

  • Overview
    00:27
  • Graphs And Charts #1 - Creating Graphs And Charts The Easy Way
    02:05
  • Graphs And Charts #2 - Creating Graphs And Charts The Easier Way
    01:40
  • Producing Brilliant Pie Charts
    01:31
  • Sparklines - Transform Your Worksheets With Mini Graphs
    00:56
  • Action Step - Create Graphs And Charts
    00:23

  • Overview
    00:25
  • APT #1 - Creating Outstanding Pivot Tables
    01:13
  • APT #2 - Modifying & Sorting Pivot Tables
    02:30
  • Action Step - Practice Using Pivot Tables
    00:21

  • Overview
    00:23
  • Bonus Tip #1 - Changing A Cell's Appearance Based On Its Value
    00:54
  • Bonus Tip #2 - The Simple Method Of Finding Duplicate Values
    00:38
  • Conditional Formatting Rule #1 - Top vs Bottom Rules
    01:26
  • Conditional Formatting Rule #2 - Average Rules
    00:50
  • Conditional Formatting Rule #3 - Removing Conditional Formatting Rules
    00:36
  • Bonus Step - Data Bars, Color Scales And Icon Sets
    00:52
  • Action Step - Begin Conditional Formatting
    00:19

  • Final Action Step - Putting It All Together
    00:58
  • Final Quiz
    4 questions

Instructor

How To Technology
Elite Technical Training
How To Technology
  • 4.3 Instructor Rating
  • 194 Reviews
  • 5,615 Students
  • 4 Courses

Wouldn't it be great if you could learn technology whilst having fun?

At How To Technology we've made that a reality. We have managed to combine learning whilst having fun, where you'll be able assimilate and put into practice everything you have learnt.

How We Make Technology Fun

Providing elite technical training for 1,000's of clients and students, we are renowned for our high quality and delivery of IT training, courses and guides. We make it our obligation to turn those who are beginners into experts.

We at How To Technology have made sure that all of our experts teach clients, using our elite step by step formula. This way all individuals being taught are gaining the most from their learning experience. This can range from students and clients learning shortcuts and tips for applications, performing practical tests or being provided with tutorial guides. Our experts also regard engagement and interactivity as a major component of the succession of teaching to our clients. With this they are always striving to train individuals to the highest degree possible.

Products & Services

*Specialize in providing step-by-step guides and tutorials focused on software and hardware. *Methods of teaching and training involve using high quality narrated tutorials, webinars, guides and videos to deliver superior training.

*Training and teaching is provisioned by Microsoft Certified and CompTIA Engineers, who are truly passionate in wanting to help others succeed.

*Flexible and bespoke training and teaching solutions to accommodate your needs.

Achievements

*Fully Accredited Microsoft & CompTIA Certified Engineers

*During mid 2014 was our peak period of enhancing the skill-set of our clients, where we had achieved our highest success rate from over the last 3 years

*Internationally renowned *Delivered training and courses in more than 50 different countries

Industries & Areas

Some examples of where we have implemented our products and services:

*Business Intelligence

*Data Management

*Internet Marketing

*HR

Examples of the content provided

*Server & desktop support

*SQL

*Java

*HTML

*Unix

Our Mission

To spread our message of "Making Technology Fun"

  • Udemy for 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
  • Featured courses
Udemy
© 2021 Udemy, Inc.