Microsoft Excel Beginner and Intermediate with Certificate
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
Instructor
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.