What you’ll learn
- 📐 Create a table in its correct format
- ⁇ Print sheets using the print area, insert headers and list worksheets
- ⁇ Use the most used functions in Excel: addition, average, conditional yes, etc.
- 🔀 Use conditional format for those cells that require it
- 📊 Insert charts
- ⁇ Immobilize rows and columns
- ❌ Delete duplicate cells
- 🔃 Segment the data to be able to filter much faster
- 🔁 Create dynamic tables that allow analyzing data without using formulas
- 🔘 Introduction to macros. Insert our first button and popup
- ⁇ Introduction to VBA programming
- 📋 Power Pivot
- 📈 Power View
- 🌍 Power Map
- վ ⁇ The Solver Tool
This course includes:
- 7.5 hours on-demand video
- 1 practice test
- 5 articles
- 58 downloadable resources
- Access on mobile and TV
- Full lifetime access
- Certificate of completion
Description
East full Microsoft Excel course is geared for those who want learn or improve using this powerful tool. The course begins with the most basic aspects of the program, so that those who have never used Excel can know the interface, the basic formulas and facilitate the compression of the rest of the classes.
Later the intermediate level aspects most important and used in companies today, such as the use of conditional functions, dynamic tables, delete duplicate data and insert graphs.
We will also see several very useful tools like Power Pivot, Power View and Power Map, which will make our work much more efficient and that the presentations have a more professional aspect.
In the last section they will be seen more advanced aspects, there will be a introduction to macros in Excel and programming in Excel VBA, which are a very powerful tool to automate many processes, and thus avoid performing repetitive tasks.
We will learn to use the macros without knowing how to program, although later we will see how to program easily to obtain the same results. We will learn to insert a button to perform certain actions and create pop-ups that will be useful to alert other users that our books have taken some action.
We will finally learn to create a form by programming in VBA very simply, and we will learn how to insert a few lines of code so that we can update dynamic tables automatically when new data is inserted.
Is a full course of Excel designed for all those people who want to start using the program, but it is also an ideal course for those others who, even though they are intermediate-advanced users are unaware of many of the essential functions to be able to carry out work more effectively and professionally.
So it is a course for both high school and college, workers and professionals who, due to their daily work in businesses and companies, require the use of Excel 365 spreadsheets at different levels of depth.
This complete course is focused on learning in a practical way those Excel functionalities that are essential to be able to handle the program with ease. That is why various downloadable materials to practice and replicate the exercises on the agenda.
I progressively expand the classes on the agenda with new materials and videos, to cover all aspects of this software. So, soon I will try Power BI, data analysis and visualization, dashboards, Power Query, DAX, templates or automation.
If you sign up for the course, do not hesitate to ask me any questions, offer me your feedback or propose new topics to improve the course syllabus, since in this way it will be more complete and according to your needs.
I will be happy to do it!
Who this course is for:
- Users without knowledge of Excel
- Anyone interested in improving their Excel domain
- People with different levels of Excel, from basic to intermediate-advanced
How to Get this course FREE?
Get a 100% Discount On Udemy courses by clicking on the Apply Here Button. This Course coupon code is automatically added to the Apply Here Button.
Apply this Coupon: 2D15179892DFC8312029 is applied (For 100% Discount)
For Latest Udemy Courses Coupon, Join Our Official Free Telegram Group :https://t.me/freecourseforall
Note: The udemy Courses Will be free for a Maximum of 1000 Learners can use the promo code AND Get this course for 100% Free. After that, you will get this course at a discounted price.
Important Notice and Disclaimer:- CareerBoostZone platform is a free Job Sharing platform for all the Job seekers. We don’t charge any cost and service fee for any job which is posted on our website, neither we have authorized anyone to do the same. Most of the jobs posted over Seekajob are taken from the career pages of the organizations. Jobseekers/Applicants are advised to check all the details when they apply for the job to avoid any inconvenience.
