Excel Course

4.0 682

About the course

You learn to work with Excel 2016. You will learn more basic functions and commands to more advanced functions, for example: procv, proch, among others. You will also learn about the new features of Excel 2016 as the data trend forecast worksheet.

  • 1 Chapter 1
  • Lesson 1. Introduction to Excel: System Requirements
  • Lesson 2. Accessing Software, Interface, and Exiting Excel # 00: 02
  • Lesson 3. Creating and Saving a Spreadsheet
  • Lesson 4. Spreadsheet Concept: Important Definitions
  • Lesson 5. How to Work with the Office Assistant
  • Lesson 6. Using Keyboard and Accentuation
  • Lesson 7. Working with Icons and Images
  • Lesson 8. Inserting Images
  • Lesson 9. What and How to Save Files
  • Lesson 10. Open and Close Files and Data Types
  • Lesson 11. Sources
  • Lesson 12. Inserting Rows / Columns and Format of Cells with Data Types
  • 2 Chapter 2
  • Lesson 13. Mathematical Operators and Basic Calculations
  • Lesson 14. Keyboard / Mouse Cursor and Percentage Calculation
  • Lesson 15. Creating Sheets with Varied Data Types
  • Lesson 16. Creating Formulas in Excel: Formulas Concept
  • Lesson 17. Basic Formulas I
  • Lesson 18. Economic Cycles
  • Lesson 19. Editing and Naming Cells
  • Lesson 20. Editing Content of a Cell
  • Lesson 21. Selecting Blocks and Naming Cells
  • Lesson 22. Undo Content
  • Lesson 23. Viewing and Printing Sheets
  • Lesson 24. Spreadsheet Sorting and Auto-Filtering
  • Lesson 25. Conditional Formatting
  • 3 Chapter 3
  • Lesson 26. Creating Conditional Formatting I
  • Lesson 27. Creating Conditional Formatting II
  • Lesson 28. Advanced Formulas: Function ?? - Concept
  • Lesson 29. Creating Function ?? I
  • Lesson 30. Creating Function ?? II
  • Lesson 31. Advanced Formulas II
  • Lesson 32. Freeze Panels and Cont. SE II
  • Lesson 33. Trend Sheet
  • Lesson 34. Advanced Formulas III Procv - Concept
  • Lesson 35. Creating Spreadsheets with Procv I
  • Lesson 36. Procv II and Proch ?? Concept and Application
  • Lesson 37. Excel Chart: Basic Charts
  • Lesson 38. Changing Graphics Types
  • Lesson 39. Minigraphs in Cells

About the Certificate

Only in iPED can you print the digital certificate for free or choose to receive this beautiful certificate at home (additional cost of + freight). On the back of the certificate is the schedule, CNPJ stamp and the signature of the person in charge, characteristics that are mandatory for the validity of the certificate.

  • Online chat
  • Pad
  • Study Groups
  • Virtual instructor
  • Support material
  • Online reports
  • Interactive animations
  • Explanatory videos

Only iPED can offer a quality service for free. We are the only company in the industry that possesses all the qualities and numbers below:

Purchase Security Differentials

  • Professional security audit;
  • Digital certificate with 256-bit encryption in transactions;
  • Quality with the consumer award;
  • National reference award in education;
  • National reference award in social projects

Differentials in Services Offered

  • Content-rich video, games and animations online;
  • Accumulation of loyalty points;
  • satisfaction rate of more than 98.5%;
  • indication index for friends over 98%;
  • Index that considers good / optimal material of more than 95%;
  • Online, face-to-face or telephone service;
  • Service through 0800 (free connection for all of Brazil);
  • Variation of the workload from 20 to 120 hours for free courses;
  • More than 500 online courses;
  • Significant testimony for each course attended;
  • Presence in more than 60 countries;
  • Thousands of students enrolled in courses;
  • More than 1 million consumers of our services.
Anderson Cardoso

About the Author: Anderson Cardoso

Professional Analysis Systems, Consulting and Projects. Graduated in Information Systems and postgraduate in Management and Governance of Ti.
Professional Experience of 10 years in the area of ​​Ti, having acted as a developer, consultant and teacher in analysis and programming of systems and creation of Websites.

Choose your plan

Free Plan

80 hours
  For Free!  
  • Valid only for new students
  • 1 interactive course
  • Animations during course
  • Reflective Activities
  • Digital Certificate
  • Study Group
  • Course 100% Video
  • Enroll now

Premium Plan

80 hours
US$ 53 .30
  • 1 interactive course
  • Animations during course
  • Reflective Activities
  • Pedagogical Accompaniment
  • Digital Certificate
  • Study Group
  • Course 100% Video
  • Enroll now

Unlimited Plan

300 courses x 80 hours
US$ 119 .60
  • Access to all courses
  • 1 year of unlimited access
  • Digital certificate
  • More than 3,000 lessons
  • + 300 courses of 80 hours
  • New courses included
  • 1 interactive course
  • Enroll now

Related courses

Tests and certificate

At the end of the online course you can issue our free digital certificate or request the special certificate by paying for the clothes and the shipping that we send you wherever you are.

Our special certificate has an anti-counterfeit security stamp and seal, as well as a non-transferable number that can be viewed online. The back of the certificate includes the schedule, the stamp of the CNPJ and the signature of the responsible person.

Our numbers

5,549,837
Registered students
97.4%
Satisfaction Index
98%
I would indicate the courses to friends

Now make your free registration
and start your online course!