Microsoft Excel Beginner and Intermediate with Certificate
4.1 (98 ratings)
11,748 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel Beginner and Intermediate with Certificate to your Wishlist.

# 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.
4.1 (98 ratings)
11,748 students enrolled
Created by Startup Saturdays
Last updated 12/2014
English
Current price: \$10 Original price: \$20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
• 7.5 hours on-demand video
• 3 Articles
• Access on mobile and TV
• Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
• Beginner
• Intermediate
• Anyone interested in harnessing the power of Microsoft Excel
• Mac users
Students Who Viewed This Course Also Viewed
Curriculum For This Course
34 Lectures
07:18:39
+
Introduction
2 Lectures 08:08

About the class: This is an online video training class. The best way to benefit from this class is to view all the lectures in full screen and sit through all the lectures at least once. All lectures are video lectures.

What is Microsoft Excel?

Microsoft excel is a software that allows its users the ability to find a simple solution to daily data related problems. Excel can be utilized to access most problems in a mathematical spreadsheet format. For example: Let’s say you want to manage your finances. Excel offers a solution by which a user can make a list of expenses and maintain an ongoing log of incurred expenses.

Excel offers a drawing board for daily challenges in a spreadsheet format. Excel allows its users the ability to enter data in a table format. After arranging the data in an excel sheet users are then able to perform calculations on this data for the purpose of data analysis. The type of calculations that needed to be made over hundreds of pages of paper can now be made in a single spreadsheet through Microsoft Excel.

Why learn Microsoft Excel?

There is a very valid and compelling business reason for learning Excel. However more compelling than the business reason is the value excel brings into our personal lives. Excel can serve as a decision making tool as well as a personal life management tool. Management of personal finances becomes significantly easier with the help of Microsoft Excel. Other very common uses of Excel in person life include job application management, weight management, vacation budget management, market analysis and decision analysis. On the business end, excel is essential for all business success. Microsoft Excel lies at the core of all business decision making. The charting feature of excel allows for the representation of data in a colorful format that plays an integral role in business communication. Microsoft Excel is driving Global business decisions in all types of business ranging from large corporations to small privately owned companies. Most all professionals come across Microsoft Excel at some point in their careers.

Who is this class for?

This is a beginner and intermediate level class.

Topics covered in class?

The class covers the layout of the Excel interface. During this process many of the interface features are shown in action. After the interface components are covered, the next part of the class focused on a few of the key formulas used by Excel and the final part of the class is an example of the utilization of Excel.

Most of the components are covered during the layout overview. The overview shows how each one of these components works independently. The charting feature of excel is studied in detail with 2 chapters dedicated to this feature. The formulas portion of the class covers some of the most widely used Excel formulas.

Best way to learn from this class?

The best way to learn from this class is by revisiting the lectures and watching the lectures in full screen.

Certificate?

A certificate for this class can be earned through the completion of all the modules of the class.

Time Commitment?

Students do not need to watch the complete class in a single sitting. Students have the ability to return to lectures and re-visit lectures.

Microsoft Excel is an essential tool for all success. Learn the art of using Excel to enhance personal, professional and business performance. The skills learned in this class are essential for utilizing Microsoft Excel for all purposes. This is a vide based training program with lessons delivered online. Students learn at their own pace by re-visiting classes as needed. Students have access to all course material for up to 1 year from date of purchase. This is a beginner and intermediate level class and requires no prior understanding of Microsoft Excel. Enhance your personal and professional performance with this amazing online training.

Preview 07:50

Connect:

Please take a moment to connect with us on the following platforms:

Pinterest: http://www.pinterest.com/startup99/

Preview 00:18
+
Excel Layout: Standard Tool Bar
1 Lecture 12:49

Covers the components of the Standard Tool Bar. This is usually the top most toolbar in the Excel interface.

Standard Tool Bar
12:49

Standard Tool Bar Quiz
5 questions
+
Excel Layout: Formatting Toolbar
1 Lecture 08:02

Learn about the components of the Formatting Toolbar. This is found at the top of the Excel window.

Formatting Toolbar
08:02

Formatting Toolbar Quiz
5 questions
+
Excel Layout: Home Tab
1 Lecture 23:01

The home tab is a part of the ribbon feature of excel. This video covers the features of the Home Tab. The most commonly used features of excel can be found in the Home Tab.

Preview 23:01

Home Tab Quiz
5 questions
+
Excel Layout: Layout Tab
1 Lecture 14:26

The layout tab is a part of the ribbon feature of excel. Users are able to set sheet layout options from this tab.

Layout Tab
14:26

Layout Tab Quiz
5 questions
+
Excel Layout: Tables Tab
1 Lecture 09:20

This tab allows the creation and formatting of a table for tables that do not have a custom format. It also implements the named range feature to tables.

Tables Tab
09:20

Tables Tab Quiz
4 questions
+
Excel Layout: Charts Tab - Part 1
1 Lecture 18:22

The charts tab allows for the representation of data in chart form. Create a variety of chart types using this tab.

The supporting file for the charts tab part 1 and 2 is the same.

Charts Tab - Part 1
18:22

Charts Tab - Part 1 Quiz
4 questions
+
Excel Layout: Charts Tab - Part 2
2 Lectures 27:17

Part 2 of Charts Tab. The charts tab allows for the representation of data in chart form. Create a variety of chart types using this tab.

The supporting file for the charts tab part 1 and 2 is the same.

Charts Tab - Part 2
26:55

Charts Tab - Part 2 Quiz
5 questions

Connect with us
00:22
+
Excel Layout: Smart Art, Formulas, Data and Review
1 Lecture 21:55

The features of these tabs are combined in a single lesson. Features from this tab are also referred to throughout the course. The Smart Art Tab offers the ability to make flow diagrams, the formula’s tab covers all pre functioned formulas in excel and the review tab allows for implementing features such as notes and spell check.

Smart Art, Formulas, Data and Review
21:55

Smart Art, Formulas, Data and Review Quiz
5 questions
+
Functions: Sum, Average, Max, Min and Count
1 Lecture 10:29

An explanation of some of the key standard formulas available in excel. Functions covered: Sum, Average, Max, Min and Count. These are the most common used functions of excel.

Sum, Average, Max, Min and Count
10:29

Sum, Average, Max, Min and Count Quiz
5 questions
18 More Sections
 4.3 Average rating 381 Reviews 30,818 Students 14 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.