Microsoft Excel - From Beginner to Expert in 1 Hour

Master Microsoft Excel 2013 in 1 hour with our elite and efficient step-by-step formula to become an expert in Excel.
4.6 (27 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,098 students enrolled
$70
Take This Course
  • Lectures 79
  • Contents Video: 1.5 hours
    Other: 6 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2015 English

Course Description

>> Special Price ONLY - Increasing To $97 Soon <<

>> Updated for September 2016 <<

Wouldn't it be great if you could learn Microsoft Excel in just 1 hour? Imagine going from beginner to expert in just 1 hour.

All this is possible in just 4 easy and simple steps.

Why should you take this course?

"Took this course and was impressed at how well it flows. nice and easy to follow and instructor gives a good overview of the course. Good clarity of voice as well. I have been on courses in the past where i have struggled with understanding what they are saying. Here I could understand what was being said." - Francesca Gomez (student)


"Thanks to teacher, he begin from the scratch and assume nothing. This course for the novice, who wish to become expert in Microsoft excel. The content of the course is up to date and very informative. I like the instructor approach toward teaching remarkably. Highly Recommend" - Faisal Qamar (student)


Having taught 1000s of beginners Excel, they were instantly able to apply what they had learnt within this course.

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

"Found instructor knowledgeable and course was easy to understand." - Stephanie Cooper (student)


"This is a great course which I am learning all of Excel´s feautures. I have seen other courses but not as broad as this course." - Arend Groot Bleumink (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…

  • Weekly planners
  • Invoices
  • Payroll systems
  • Budget keeping
  • Listing and sorting data
  • Bookkeeping
  • Customer and employee data
  • Scheduling
  • Almost anything that requires and uses data


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

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


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

No longer be in the dark as our fully accredited Microsoft certified instructors will shed light on how Excel operates; we will focus on…

  • Creating worksheets 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
  • Using the right tools that will boost your productivity by at least 33%


Plus you'll receive 3 Bonuses for enrolling which are…

Bonus #1: The Excel 2013 Elite Formula Cheat Sheet - formulas available on demand

Bonus #2: The 4 Step Excel 2013 Functions Guide - makes using functions and formulas simple and easy

Bonus #3: Special Udemy Reward - For those who are eager to learn, if you complete at least 50% of this course within the first 7 days of purchase and leave a review about your experience, we will reward you with a free course of your choice.

*If this hasn't been taken down this Special Udemy Bonus is still available

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

What are the requirements?

  • Nothing - No previous knowledge of Excel is required, this course will teach you everything that you'll need to know to go from beginner to expert.

What am I going to get from this course?

  • Be able to use Excel in real life situations by creating various types of graphs and charts.
  • Have the ability to manipulate data any way you want.
  • Create powerful and eye-popping pivot tables to analyse data in a whole new way.
  • Make use of calculations, formulas and functions to enhance your work.

What is the target audience?

  • If you want to guarantee becoming a job ready Excel expert.
  • If you want to learn Excel in the quickest possible way.
  • If you want a clear, simple and no-nonsense guide to learning Excel.
  • If you want to refresh and take your knowledge of Excel to the next level.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Excel Introduction - Beginner To Expert in 1 Hour
00:56

1.) Brief Introduction to the Learn Excel 2013 in 1 Hour Course.
2.) Introductory Course that will turn beginners into experts with Excel.
3.) Incorporates simple 4 step formula to ensure maximal comprehension of the Course.
4.) Will learn and understand how Excel will revolutionize your productivity and overall efficiency.
5.) Full Commitment required!

00:42

1.) Our exclusive Facebook community.
2.) High value content.
3.) Grow and develop as a collective.

00:54

1.) 4 Step Elite Bonus Completion Incentive.
2.) Complete at least 50% of the course within first 7 days of purchase and leave a review.
3.) We will reward you with a free course of your choice.

00:30

1.) Introduction to learning Excel.
2.) 4 easy and digestible steps.
3.) Excel fundamentals.
4.) Part 1 - The ribbon.
5.) Part 2 - Quick access toolbar.

01:38

1.) Understanding the ribbon.

01:50

1.) Understanding the quick access toolbar.

00:23

1.) To ensure you have a good understanding of the ribbon and quick access toolbar.
2.) Take action - test out and use the ribbon and quick access toolbar.

Section 2: Step 1A: Working With Worksheets (WWW) And Wondrous Workbooks
Article

1.) Work files to download for the course.

00:27

1.) Part 1 - Using workbooks.
2.) Part 2 - Using worksheets.

01:04

1.) How to create a workbook within Excel.

01:48

1.) Using various methods to save a workbook.

01:00

1.) Learning how to navigate throughout Excel.
2.) Excel fundamentals - Cells, name box, formula bar & worksheets.

00:27

1.) Adding and removing worksheets.

00:25

1.) Renaming a worksheet.

01:48

1.) How copying and moving worksheets between workbooks will boost your productivity by at least 25%.

00:51

1.) Hiding and unhiding worksheets.

00:22

1.) To ensure you fully understand how workbooks and worksheets operate.
2.) Take action - experiment and use workbooks and worksheets within Excel.

Section 3: Step 1B: Timeless Secrets of Editing & Entering Data inside Cells
00:31

1.) Part 1 - Data types: Numbers, text & dates.
2.) Part 2 - Cells.
3.) Part 3 - Columns & rows.

01:48

1.) Inputting various data types within cells.

01:11

1.) Editing data within cells and the formula bar.

03:00

1.) How to copy, cut and paste cells.

01:40

1.) Learning how to drag and and drop cells.
2.) Dragging and dropping cells between worksheets.

01:51

1.) Adding and deleting columns and rows.

01:40

1.) Learning how to effectively use find and replace.

01:02

1.) How to adjust column widths and row heights.

03:17

1.) Looking at the various methods of sorting several columns of data.

00:20

1.) To ensure you have fully understood how you can edit and enter data.
2.) Take action - test out and practice editing and entering data.

Section 4: Step 2A: Elite Excel Fundamentals For Workbook Formatting
00:28

1.) Part 1 - Borders.
2.) Part 2 - Cell manipulation.
3.) Part 3 - Cell formatting.

01:33

1.) Going over the various methods of applying borders to cells.

01:16

1.) Learning how to merge cells.

00:40

1.) Understanding how to wrap cells to allow multiple lines of text.

00:54

1.) How to change merged cells into standard cells.

01:24

1.) Learning how to enhance the appearance of worksheets with font size, type and color.

01:52

1.) Learning how to use and apply the date format.

01:06

1.) Going over various types of number formats.
2.) Applying number formats to cells.

02:40

1.) How to create a table within Excel.

00:24

1.) Ensuring that you fully understand how to format cells within Excel.
2.) Take action - Test out and experiment your knowledge and understanding of formatting within Excel.

Section 5: Step 2B: Perfect Printing & Page Setup
00:26

1.) Part 1 - Printing fundamentals.
2.) Part 2 - Page layout.
3.) Part 3 - Printer setup.

01:36

1.) Learning how to apply print titles to worksheets.

00:57

1.) How to print a selected area within Excel.

01:26

1.) Using the correct paper size and orientation.

01:47

1.) Learning how to use margins to fit more data within worksheets.

01:55

1.) Going over various methods of scaling worksheets.
2.) How to correctly scale worksheets.

04:04

1.) Various methods of using headers and footers.
2.) How to customize headers and footers.

04:16

1.) How to efficiently print worksheets.
2.) How to optimally configure printer settings.

4 questions

Time for a Midterm quiz. Let's put that brain to good use!

00:22

1.) To ensure you fully grasp the print options available in Excel.
2.) Take action - test out and experiment print options and settings within Excel.

Section 6: Step 3A: Mastering Functions & Formulas
00:27

1.) Part 1 - Basic formulas.
2.) Part 2 - The SUM function.
3.) Part 3 - Other functions.

02:06

1.) How to make the most effective use of addition & subtraction formulas.

02:36

1.) How to make the most effective use of multiplication & division formulas.

02:21

1.) Understand the power of the SUM function.

01:28

1.) The best and most effective way to copy formulas.

2 pages

1.) The cheat sheet which you will want to keep for your entire Excel career.

02:09

1.) The incredible importance of absolute cell referencing.
2.) How to make the best use of absolute cell referencing.

01:33

1.) This will literally skyrocket your result rate with Excel.
2.) Learn how to use formulas across worksheets.

03:44

1.) Learn about the hidden power of VLOOKUPS.
2.) Understand the various ways of accurately using VLOOKUPS.

02:16

1.) How IF STATEMENT will change the way you look at Excel forever.
2.) Understand how to properly use IF STATEMENTS.

3 pages

1.) Your exclusive bonus which contains all the functions that you need to know.

00:20

1.) To ensure you fully comprehend how functions and formulas work.
2.) Take action - experiment and test out various functions and formulas.

Section 7: Step 3B: Maximise Your Data with Graphs & Charts
00:28

1.) Part 1 - Graphs and charts creation.
2.) Part 2 - Modifying Graphs and charts.

02:05

1.) The quick way of creating graphs and charts.

01:19

1.) The even quicker way to creating graphs and charts.

00:19

1.) Understanding and using filters.

01:19

1.) How to use pie charts in the best possible way.

01:00

1.) Learn how you can make the most use of sparklines.

00:23

1.) To ensure you have a good grasp of graphs and charts.
2.) Take action - Test out and produce graphs and charts.

Section 8: Step 4A: The Power of Pivot Tables (PPT)
00:24

1.) Part 1 - Creating pivot tables.
2.) Part 2 - Modifying pivot tables.

01:13

1.) How to create the best possible pivot tables.

01:19

1.) How to sort and analyse data using pivot tables.

00:21

1.) To ensure you fully understand how pivot tables work.
2.) Take action - Practice and test out pivot tables.

Section 9: Step 4B: The Art of Conditional Formatting
00:24

1.) Part 1 - Working with values.
2.) Part 2 - Using various rules.

01:14

1.) How to change cell appereances based on their value.

00:52

1.) Finding duplicate values is super simple!

01:40

1.) Find out the big difference between top and bottom rules.

01:06

1.) Find out why being average is actually a good thing.

00:44

1.) Discover the power of removing conditional formatting rules.

00:58

1.) How to make full usage of color scales, data bars and icon sets.

00:22

1.) To ensure you have a good understanding of conditional formatting.
2.) Take action - Try conditional formatting yourself.

Section 10: Conclusion
00:42

1.) Putting all the knowledge together for the final action step.

4 questions

It's that time again. Show off everything you've learnt with this final quiz!

1 page

1.) Sources for the images used within this course.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

How To Technology, Elite Technical Training

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"

Ready to start learning?
Take This Course