By Simpliv
Online
Can be taken anytime
Professional Training Course
Yes (Details)
English
$10
Course Overview
About this Course:
Excel is one of the most used software in the job market and nowadays, it is not enough just to know how to move, you have to know A LOT!
With that in mind, we brought you a course that is totally focused on EXERCISES, with the most used functions and tools in the MARKET.
What you will learn:
Introduction:
- General purpose commands
- Absolute and relative addresses
- Subtotal
- Data input validation
- Filters
- Main functions (IF, SUMMARY, SUMMES, CONT.SE, CONT.SES, PROCV, PROCH, PROC, INDEX, CORRESPOND, SHIFT, SUMMER, TEXT, LEFT, RIGHT, TUMBLE, CAPITAL, CONCATENATE and etc)
- Matrix
- Conditional formatting
- Simple and secondary axis graphics
- Reach goal
- Solver
- Dynamic table
- PivotChart
- Introduction to Macros
Basic knowledge:
- Microsoft Excel software installed, preferably version 2013 or higher
- It only takes a basic knowledge of the tool, as we will start by leveling knowledge and advancing to the most used formulas in the market.
Who should take this course
All the people! Today Excel is one of the leading software on the market, used in any industry. Your knowledge is no longer differential, it is mandatory.
Accreditation
Course Completion Certificate
Course content
What you will learn:
After the course, students will have knowledge of the main formulas and tools used in the market. Rock the trials of selection processes and leave competitors behind! Drop the jawbone boss with the spreadsheets and formulas you'll develop! Take off your career!
About Course Provider
Simpliv LLC, a platform for learning and teaching online courses. We basically focus on online learning which helps to learn business concepts, software technology to develop personal and professional goals through video library by recognized industry experts or trainers.
Why Simpliv
With the ever-evolving industry trends, there is a constant need of the professionally designed learning solutions that deliver key innovations on time and on a budget to achieve long-term success.
Simpliv understands the changing needs and allows the global learners to evaluate their technical abilities by aligning the learnings to key business objectives in order to fill the skills gaps that exist in the various business areas including IT, Marketing, Business Development, and much more.