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 AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP Node.Js WordPress 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 Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging 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

This course includes:

  • 7.5 hours on-demand video
  • 3 articles
  • 16 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel

Microsoft Excel Beginner and Intermediate with Certificate

Learn how to use Excel for Mac and PC with this beginner and intermediate excel certificate class. Top Rated Training.
Rating: 4.5 out of 54.5 (199 ratings)
12,029 students
Created by Startup Saturdays
Last updated 12/2014
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • To educate on Microsoft Excel
  • Layout: Standard Toolbar​
  • Layout: Formatting Toolbar
  • Layout: Home Tab
  • Layout: Layout Tab
  • Layout: Tables Tab
  • Layout: Charts Tab
  • Layout: Smart Art
  • Layout: Formulas
  • Layout: Data
  • Layout: Review
  • Functions: Sum
  • Functions: Average
  • Functions: Max
  • Functions: Min
  • Functions: Count
  • Functions: Vertical and Horizontal Lookup
  • Functions: Vertical and Horizontal Lookup with Index
  • Functions: Sumif and Averageif
  • Functions: The IF statement
  • Functions: The nested IF statement
  • Functions: Vlookup nested inside an IF Statement

Requirements

  • Microsoft Excel

Description

This is a beginner and intermediate Microsoft Excel training class that requires no prior knowledge of Excel. The training provided in this class covers MAC and PC. Ideal for students who use a MAC and just as applicable to students who use a PC.

The class starts be describing the interface and then explains different functions a user can utilize to perform a variety of analysis.

This is a beginner and intermediate level class, no prior excel experience necessary.

Following is a list of topics covered in class:

Layout

  • Standard Toolbar
  • Formatting Toolbar

  • Home Tab

  • Layout Tab

  • Tables Tab

  • Charts Tab

  • Smart Art

  • Formulas

  • Data

  • Review

Functions

  • Sum
  • Average
  • Max
  • Min
  • Count
  • Vertical and Horizontal Lookup

  • Vertical and Horizontal Lookup with Index

  • SumIf and AverageIf

  • The IF Statement

  • Nested IF Statement

  • Vlookup nested inside an if statement

Who this course is for:

  • Beginner
  • Intermediate
  • Advanced
  • Anyone interested in harnessing the power of Microsoft Excel
  • Mac users

Course content

28 sections • 34 lectures • 7h 18m total length

  • Preview07:50
  • Preview00:50

  • Standard Tool Bar
    12:49
  • Standard Tool Bar Quiz
    5 questions

  • Formatting Toolbar
    08:02
  • Formatting Toolbar Quiz
    5 questions

  • Preview23:01
  • Home Tab Quiz
    5 questions

  • Layout Tab
    14:26
  • Layout Tab Quiz
    5 questions

  • Tables Tab
    09:20
  • Tables Tab Quiz
    4 questions

  • Charts Tab - Part 1
    18:22
  • Charts Tab - Part 1 Quiz
    4 questions

  • Charts Tab - Part 2
    26:55
  • Charts Tab - Part 2 Quiz
    5 questions
  • Connect with us
    00:55

  • Smart Art, Formulas, Data and Review
    21:55
  • Smart Art, Formulas, Data and Review Quiz
    5 questions

  • Sum, Average, Max, Min and Count
    10:29
  • Sum, Average, Max, Min and Count Quiz
    5 questions

Instructor

Startup Saturdays
Thought leaders in entrepreneurship and business
Startup Saturdays
  • 3.9 Instructor Rating
  • 645 Reviews
  • 31,995 Students
  • 8 Courses

Startup Saturdays is empowering the global community through offerings that instill and enhance leadership, entrepreneurship and technical skills. Individuals empowered through Startup Saturdays are able to explore new business and career opportunities that lead to a better quality of life and higher earnings.

Explore new pathways for your life by attending one of our classes. We are here to assist individuals with personal growth and help eliminate unsightly hurdles that may be arising from a lack of knowledge.

The skills taught by Startup Saturdays are in Global demand; your goal might be to start a company or to attain better paying employment. Startup Saturdays has offerings that will help you with these goals. Our trainings are practical, exercise based and come from experienced instructors. Classes take place in a professional conference room setting with individual attention.

The premise of our existence is that we would like to share knowledge with you and encourage you to achieve greatness in your careers and business along with all other aspects of your life.

Leadership and Management Training: The cornerstone of any action is leadership and management. It is the leader within us that drives us to achieve all our goals ranging from getting up in the morning to becoming what ever we desire to become in life.

Startup Saturdays has a series of offerings that help harness this inner leader and polish management skills. Operating in any environment (public or private) is hinged on a set of very necessary skills that need constant maintenance. If nurtured properly these skills can bear sweet fruit and if left unattended these skills can lead to the demise of any individual. These skills make the difference between winning and losing in life.

Technology: A student who has taken a technology class at Startup Saturdays will have a better understanding of technology. This may lead into the student building a new technology product or attaining a new position that requires technical skills the student did not have before. Anyone who has had to deal with building a technology can attest to this challenge. We are here to help you take the right steps. Don’t let the lack of understanding of technology be your handicap.

Having a good grasp of technology can result in more earning and increased employment opportunities.

Finance: The fuel that powers the economy determines how individuals and businesses survive. An integral part of business and life that can’t be ignored and a driving force behind the circumstances of most people and businesses in the World; the classes on Finance offered by Startup Saturdays are eye opening and targeted towards building a smarter financial brain.

Marketing: The greatest challenge for any business is marketing. An individual who can alleviate marketing pains is very valuable to any business. Marketing is an evolving challenge and requires constant attention. The rate with which marketing strategies become obsolete is comparable to the rate with which technologies become obsolete. Ignoring marketing needs can result in the failure of many qualified products and people. A business is incomplete without marketing and will miss out on opportunities along with possibly never reaching scale in its lifetime.

Marketing classes taught through Startup Saturdays focus on practical solutions and strategy building that can be implemented for initial traction or long term growth.

Information Technology Sales: Startup Saturdays offers training that teaches technology sales; a solution valuable to technical entrepreneurs and anyone interested in making money. Technical sales are very different from traditional sales. Technical sales require a good understanding of technology and traditional sales training can’t be used as a substitute to technical sales training.

Startup Saturday’s Technical Sales Training is available to individuals and corporations alike.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.