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.

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