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

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