This course is geared to learners that are looking to advance in Excel for a professional goal or career advantage, like applying for a position that requires Excel, advance in their current career, or engaging in a business using Excel as their effective and inexpensive management tool.
With this course, you will learn everything necessary and fundamental to conquer Excel quickly and effectively, and move ahead with your new skills.
🎓 Learning Goals:
✅ Understanding of the basic terminology used to describe the most important parts of an Excel file, which will serve as a guide for the rest of the course.
💻 The most common and essential functionalities to use Excel: different guides appear depending on the position of the mouse in each cell.
🎨 How to change the format, color, font, dimensions, and borders of cells.
✅ Learn about VLOOKUP
✅ Newer features like XLOOKUP, LAMBDA, and FILTER functions.
💵 How to Create a Budget in Excel
✅ Add, Edit and Change Tables
✅ We will learn to organize alphabetically, conditional formatting, and change cell styles.
✅ More common advanced functions in Excel such as MEDIAN, AVERAGE, IF, COUNT, SUMIF, GoalSeek, and absolute references.
✅ How to create and modify a Pivot Table
📊 How to create a Graph in Excel the easy and effective way
🚀 Introduction to Power Query and core functionalities with examples
😎 The different views of Excel
🖨️ How to print in detail in Excel
You just need to review each module lasting approximately 3 to 5 minutes, practice your knowledge with the exercises and files that we include, and you will be amazed at how easy and intuitive Excel is:
🛠️ We will start with a review of the most used and essential tools in Excel.
👣 We continue with short lessons that will show you step by step what each of these Excel tools are ready to do.
🧑🏫 With this course you can contact us and talk to a real human if you have questions. An Excel expert will communicate with you, not a robot or a pre-recorded message.
The course includes a PDF reference booklet that includes the formulas, steps, and objectives that we have seen in Excel for you to print and review.
When you complete this course, we will send you a certificate provided by iKnowledge Learning Center, so that you can show it as proof of your knowledge of Excel.