Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication 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 Certifications Network & Security Hardware Operating Systems & Servers 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 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 Paid 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 & Gardening 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 & Diet Yoga Mental Health Martial Arts & 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 Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React CSS Angular Node.Js PHP HTML5 Typescript
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Data Analysis
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin Mobile App Development SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Personal Development Neuro-Linguistic Programming Personal Transformation Life Purpose Mindfulness Sound Therapy Coaching CBT Cognitive Behavioral Therapy
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Leadership
Digital Marketing Social Media Marketing Marketing Strategy Google Analytics Internet Marketing Copywriting Email Marketing Startup YouTube Marketing

Office ProductivityMicrosoftExcel

How to Quickly Excel in the Basics of Excel

Master Excel with short, sharp videos covering all basic and advanced features. Experienced Teacher Instructor.
Rating: 4.0 out of 54.0 (83 ratings)
1,974 students
Created by Paul Barton
Last updated 11/2014
English
English

What you'll learn

  • Confidently use basic functions and calculations in Excel.
  • Successfully create professional looking and effective Excel spreadsheets from scratch.
  • Create eye-catching charts and graphs to better visually represent your spreadsheet data.
  • Be familiar with Excel spreadsheet terminology, layout and formatting.

Requirements

  • Students will need a working copy of Microsoft Excel 2013 software (although Excel 2010 will also work just fine).
  • No prior knowledge is required to commence this course. Just the desire to improve your own skills.

Description

*** All videos are under 5 minutes in duration and are straight to the point to help maintain your concentration ***

This course in Excel 2013 will allow a novice user to quickly become a confident spreadsheet user. Highly practical, you can be applying your new skills within minutes of learning a concept.

Having taught IT for over 20 years I've identified the key aspects and you will benefit from my experience. You will find my videos straight to the point and that I explain all concepts in simple terms rather than getting too technical or using IT jargon. Wherever possible I provide practical examples to demonstrate where the concept being explored can be applied. I have taught these concepts to 1000s of students during my career and now would like to give you the opportunity to also learn some new, valuable and employable workplace skills

The course consists of a brief overview of each concept and short, sharp videos covering the key points for all topics. Additionally, there is a practical, self-marked activity for you to complete and three videos showing me completing the task should you encounter difficulties.

Major topics include:

  • Basics of Excel 2013 - simple arithmetics, formatting, shortcuts and tricks of the trade.
  • Additional features to better utilise the power of Excel - absolute referencing and using cells in multiple ways.
  • Using Common Formulas - sum, average, if, lookup, rank, countif, plus some more advanced functions available to assist you to create professional, efficient spreadsheets.
  • A Challenge Activity - self-marked series of examples to try your new skills. Videos of solutions to all activities are also provided.
  • Adding Charts / Graphs to improve the visual effectiveness of highlighting your information.
  • Some additional concepts to further develop your spreadsheeting skills including using conditional formatting, generating random numbers and probability.

I look forward to assisting you in becoming a confident user of Excel 2013.

Who this course is for:

  • Anyone from complete beginners to those who have done some work with spreadsheets so they can expand their skills.
  • People who want to add these critical IT skills to their computing expertise. Spreadsheets are used in most professions in some form and are highly desirable to employers.
  • As it is an introductory course, not recommended for those with a thorough knowledge of speadsheets.

Instructor

Paul Barton
IT Teacher, Google Cert. Trainer, Microsoft Educator Expert.
Paul Barton
  • 4.0 Instructor Rating
  • 307 Reviews
  • 4,180 Students
  • 5 Courses

Hi, I'm Paul and I've been a full time teacher of Information Technology (IT) for 27 years. I am the Head of Digital Technologies at my secondary school and have a Bachelor of Information Technology and a Master of Educational Leadership specialising in IT. 

I am a Google Certified Trainer and have completed the Google Certified Education Level 1 & 2 qualifications so you know that my courses are well developed and include all aspects of the software.  Additional to my Google qualifications, I am also a Microsoft Innovative Educator Expert (MIEE).

I deliver real-world, highly practical courses drawn from my experience of having taught thousands of students over the last 24 years of teaching. I cut through the jargon emphasising the key points and tell you what you need to know as quickly as possible while not missing any critical skills.

I gain great pleasure teaching people how to better utilise technology in their life and work environment. The tools and skills explored in my courses are applicable in any workplace or for those just looking to improve their own IT skills. 

I look forward to working with you as you develop into a more confident IT user.  Enjoy.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.