- Excel introduction
- Basic statistical functions and some formulas
- More formulas and filters
- Xlookup
- Pivot Table and chart
What you'll learn
- Excel syntax, basic, shortcuts etc
- Basic statistical functions
- Xlookup/Reference function
- Text/Date & Time Formulas
- Pivot table and Chart introduction
Description
In this Microsoft Excel training, you will learn how to navigate and manipulate worksheets and workbooks. With formulas, functions, and names. Design a pivot table with charts, slicers, and filters.
Formulas will start from basic functions as count till nesting formulas as an index. At the end of the training each attendee will understand the importance of excel and why it's the most used tool in the accounting and how to use it.
Improved data management using Excel. Excel makes it possible to efficiently store and manage large sets of data so you can track, sort, and filter to find just the information you need at any time. Excel, like other spreadsheets, uses a grid-based structure to hold data within cells. You can use the data to create tables and categorize information within rows or columns, making it easier to maintain and update. Whether managing a list of names and addresses an inventory of products and parts, or tracking who is working on which parts of a project, Excel helps to organize your information
Perform better data analysis with Excel. With built-in formulas, functions, and pivot tables, Excel makes it possible to perform calculations and gain insights from data that has been well organized.
Other Courses
Advanced Cardiac Life Support (ACLS)
Learn ACLS entirely online! Created by physicians and adheres to the latest ILCOR Standards and Guidelines
Learn How to Craft Game Effects using Houdini & UE4
A guide for experienced film vfx artists to start their journey into real time graphics.
Developing Cloud-Native Apps w/ Microservices Architectures
Identify the proper frameworks and tools to build your microservices architecture.
Fun with Beginner LEGO MindStorms EV3 Robotics.
Learning by Doing - Lego EV3 Robotics for the absolute beginner, build small robots and program them using EV3-G.
Android Fundamentals: Ultimate Tutorial for App Development
Learn Android and Create Amazing Apps for Android Playstore
About the instructors
- 4.67 Calificación
- 33 Estudiantes
- 4 Cursos
Alexandru Popiniuc
Excel guru at udemy
One of my passions is Excel, I see Excel as a picture frame where I can create little working things. I have worked daily with Excel as a corporate worker for almost a decade and want to share all my passion with you.
Want to be efficient at your work? It's simple, join my course and together will grow a passion on excel.
Student feedback
Course Rating
Reviews
Despite the background noises, I have really appreciathe the informal fun approach to present tge course. Very engaging
the number of messages this person receives in the back ground is very distracting , he should turn his notifications off.