Microsoft Excel and PowerPoint Training With Certificate
Microsoft Excel and PowerPoint Training With Certificate, available at $64.99, has an average rating of 3.71, with 43 lectures, 21 quizzes, based on 373 reviews, and has 2314 subscribers.
You will learn about Microsoft Excel Training With Certificate Excel Layout: Standard Tool Bar Excel Layout: Formatting Toolbar Excel Layout: Home Tab Excel Layout: Layout Tab Excel Layout: Tables Tab Excel Layout: Charts Tab Excel Layout: Smart Art, Formulas, Data and Review Functions: Sum, Average, Max, Min and Count Functions: Vertical and Horizontal Lookup Functions: Vertical and Horizontal Lookup with Index Functions: SumIf and AverageIf Functions: The IF Statement Functions: Nested IF Statement Functions: Vlookup nested inside an if statement Making a simple presentation with Powerpoint Slide Master Home Tab – 1 – Insert Image – PPT Home Tab – 2 – Paragraph Options – PPT Home Tab – 3 – Adding Clip Art – PPT Home Tab – 4 – Insert Options This course is ideal for individuals who are Beginner and Intermediate It is particularly useful for Beginner and Intermediate.
Enroll now: Microsoft Excel and PowerPoint Training With Certificate
Summary
Title: Microsoft Excel and PowerPoint Training With Certificate
Price: $64.99
Average Rating: 3.71
Number of Lectures: 43
Number of Quizzes: 21
Number of Published Lectures: 43
Number of Published Quizzes: 21
Number of Curriculum Items: 64
Number of Published Curriculum Objects: 64
Original Price: $19.99
Quality Status: approved
Status: Live
What You Will Learn
- Microsoft Excel Training With Certificate
- Excel Layout: Standard Tool Bar
- Excel Layout: Formatting Toolbar
- Excel Layout: Home Tab
- Excel Layout: Layout Tab
- Excel Layout: Tables Tab
- Excel Layout: Charts Tab
- Excel Layout: Smart Art, Formulas, Data and Review
- Functions: Sum, Average, Max, Min and Count
- Functions: Vertical and Horizontal Lookup
- Functions: Vertical and Horizontal Lookup with Index
- Functions: SumIf and AverageIf
- Functions: The IF Statement
- Functions: Nested IF Statement
- Functions: Vlookup nested inside an if statement
- Making a simple presentation with Powerpoint
- Slide Master
- Home Tab – 1 – Insert Image – PPT
- Home Tab – 2 – Paragraph Options – PPT
- Home Tab – 3 – Adding Clip Art – PPT
- Home Tab – 4 – Insert Options
Who Should Attend
- Beginner and Intermediate
Target Audiences
- Beginner and Intermediate
About the class:
This is a combined certificate training of Microsoft Excel and Microsoft Powerpoint. This training encompasses all the training from “Microsoft Excel Training With Certificate” and “Microsoft Powerpoint Training with Certificate”. 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 Powerpoint?
Microsoft Powerpoint is a software that is used for making presentations. This class teaches how to make a Microsoft Powerpoint Presentation. Microsoft Powerpoint is the most commonly used software for the creation of presentations. Knowing how to make a presentation is very valuable in the communication of ideas. Corporations around the World rely on Microsoft Powerpoint for communicating their ideas and messages to mass audiences. At the core of every international meeting lies a Powerpoint Presentation. This class teaches you how to think in Powerpoint. The ability to communicate your ideas to the World is your greatest asset. We are here to show the tools you have access to for achieving this goal.
Why learn Microsoft Powerpoint?
There will be many circumstances throughout your career and personal life when you will have to educate an audience or communicate a message in a formalized manner. Powerpoint is the tool that will allow you to achieve this goal. Powerpoint can be used for communicating ideas of all levels of complexity. It is very commonly utilized by University Professors, Executives and heads of states to make presentations. Whatever your goal may be, knowing Powerpoint will help you achieve your goal.
Who is this class for?
This is a beginner and intermediate level class.
Topics covered in class?
Interface components of Powerpoint are covered. Sample presentations are made to show the functionality of Powerpoint. The features of Powerpoint are implemented on these sample presentations. Most commonly used features of Power Point are highlighted and visited several times throughout the class.
~~~~~~~~~~
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 focuses 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. Certificate is delivered through email.
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.
Course Curriculum
Chapter 1: Introduction: Microsoft Excel Training With Certificate
Lecture 1: Class Intro – Microsoft Excel
Lecture 2: Before we begin
Chapter 2: Excel Layout: Standard Tool Bar
Lecture 1: Standard Tool Bar
Chapter 3: Excel Layout: Formatting Toolbar
Lecture 1: Formatting Toolbar
Chapter 4: Excel Layout: Home Tab
Lecture 1: Home Tab
Chapter 5: Excel Layout: Layout Tab
Lecture 1: Layout Tab
Chapter 6: Excel Layout: Tables Tab
Lecture 1: Tables Tab
Chapter 7: Excel Layout: Charts Tab – Part 1
Lecture 1: Charts Tab – Part 1
Chapter 8: Excel Layout: Charts Tab – Part 2
Lecture 1: Charts Tab – Part 2
Chapter 9: Excel Layout: Smart Art, Formulas, Data and Review
Lecture 1: Smart Art, Formulas, Data and Review
Chapter 10: Excel Functions: Sum, Average, Max, Min and Count
Lecture 1: Functions: Sum, Average, Max, Min and Count
Chapter 11: Functions: Vertical and Horizontal Lookup
Lecture 1: Vertical and Horizontal Lookup
Chapter 12: Functions: Vertical and Horizontal Lookup with Index
Lecture 1: Vertical and Horizontal Lookup with Index
Chapter 13: Functions: SumIf and AverageIf
Lecture 1: SumIf and AverageIf – Part 1
Lecture 2: SumIf and AverageIf – Part 2
Chapter 14: Functions: The IF Statement
Lecture 1: The IF Statement
Chapter 15: Functions: Nested IF Statement
Lecture 1: Nested IF Statement
Chapter 16: Functions: Vlookup nested inside an if statement
Lecture 1: Vlookup nested inside an if statement
Chapter 17: Using Microsoft Excel for Personal Finance – Example
Lecture 1: Using Microsoft Excel for Personal Finance – Part 1
Lecture 2: Using Microsoft Excel for Personal Finance – Part 2
Lecture 3: Using Microsoft Excel for Personal Finance – Part 3
Chapter 18: Powerpoint: Making a simple presentation
Lecture 1: Making a simple presentation
Chapter 19: Powerpoint: Slide Master
Lecture 1: Slide Master
Chapter 20: Powerpoint: Home Tab – Insert Image
Lecture 1: Home Tab – Insert Image
Chapter 21: Powerpoint: Home Tab – Paragraph Options
Lecture 1: Home Tab – Paragraph Options
Chapter 22: Powerpoint: Home Tab – Adding Clip Art
Lecture 1: Home Tab – Adding Clip Art – Part 1
Lecture 2: Home Tab – Adding Clip Art – Part 2
Lecture 3: Home Tab – Adding Clip Art – Part 3
Chapter 23: Powerpoint: Home Tab – Insert Options
Lecture 1: Home Tab – Insert Options
Chapter 24: Excel 2013 – Add Subtract Multiply Divide
Lecture 1: Add Subtract Multiply Divide
Chapter 25: 2013 Home Tab Clipboard
Lecture 1: 2013 Home Tab Clipboard
Chapter 26: 2013 Home Tab Clipboard Copy Paste
Lecture 1: Home Tab Clipboard Copy Paste
Chapter 27: 2013 Fonts and related features
Lecture 1: 2013 Fonts and related features
Chapter 28: Excel 2013 Alignment
Lecture 1: Excel 2013 Alignment
Chapter 29: Excel 2013 Currency Feature
Lecture 1: Excel 2013 Currency Feature
Chapter 30: Excel 2013 Conditional Formatting
Lecture 1: Conditional Formatting 1
Lecture 2: Conditional Formatting 2
Lecture 3: Conditional Formatting 3
Chapter 31: Excel 2013 Format Table and Cells Features
Lecture 1: Excel 2013 Format Table and Cells Features
Chapter 32: Excel 2013 Edit Options in Home Tab
Lecture 1: Excel 2013 Edit Options in Home Tab
Chapter 33: Pivot Table
Lecture 1: Pivot Table
Lecture 2: Insert Table and recommended Pivot Table
Chapter 34: Excel 2013 Illustrations
Lecture 1: Excel 2013 Illustrations
Instructors
-
Startup Saturdays
Thought leaders in entrepreneurship and business
Rating Distribution
- 1 stars: 16 votes
- 2 stars: 18 votes
- 3 stars: 54 votes
- 4 stars: 134 votes
- 5 stars: 151 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Language Learning Courses to Learn in November 2024
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024