What you’ll learn
- Using Power Query and its enormous convenience to speed up your work on Microsoft Excel
- You won’t waste a lot of time fixing, cleaning, simplifying your files in Microsoft Excel anymore
- Create a Query by connecting to a single Microsoft Excel file
- Create a Query by connecting to a folder containing multiple Microsoft Excel files
- Combine two or more Queries with features such as “tuning” and “union”
- Update the data source and re-enter the Power Query editor
- Work much faster on files with huge amounts of data in Microsoft Excel
- You no longer have to perform elementary and repetitive operations manually in Microsoft Excel
- With the knowledge of Power Query you will have in your Curriculum a phenomenal competence that will guarantee you a certain competitive advantage
- Power Query will simplify what you could do through very complicated features in Microsoft Excel
This course includes:
- 1.5 hours on-demand video
- 1 article
- 10 downloadable resources
- Access on mobile and TV
- Full lifetime access
- Certificate of completion
Description
Do you have to prepare dinner for friends, get to the kitchen and what do you find ?!
All the dirty kitchen with still the dishes to be washed the day before!
And so, even before you start cooking, you have to clean up your whole kitchen is wash the dishes!
Metaphorically, this is what unfortunately happens too often even in the workplace on Excel files; you have to do data analysis, manage pivot tables, create dashboards etc., yet the files we have are badly made and set in a terrible way. So what are you doing? You waste a lot of time manually arranging your file (cleaning the kitchen), and only then can you start with what your real job would be (cooking).
Instead, think that there is a fantastic tool that snaps your fingers, rearrange your Excel files according to your needs, no longer making you waste a lot of time each time “cleaning up the kitchen”. This tool is called Power Query, and everyone who sees it, is amazed and fascinated by great comfort.
So just waste a lot of time fixing your Excel files; think about it Power Query!
Iwrite down now to start your learning path!
We will leave from zero and I will guide you step by step through videos, guided exercises and above all practical examples that you can redo by hand because they are attached to the lessons of the video course.
So what are we waiting for?
NB: this course is registered with Microsoft Excel 365 but the 2021, 2019, 2016 versions are also fine.
Keep in mind that you can take advantage of the free trial month of the full version of Excel 365 downloadable from the Microsoft website
Topics:
- Thanks and some information before starting
- Power Query what it is and what it is used for
- Practical demonstration
- Create a Query by connecting to a single Excel file
- Update the data source and re-enter the Power Query editor
- Create a Query by connecting to a folder containing multiple Excel files
- Example of dynamic dashboard
- Create connection only
- Queue Queries
- Join the Queries
- Lines: remove them, filter them, order them, use the first line as a header
- Columns: format them, divide them, rename them, move them, fill them, remove them
- Replace values, upper case and lower case, remove spaces, extract characters
- Custom columns
- Index columns
- Columns linked or “merge” of columns
- Columns “from examples”
- Conditional columns
- Grouped columns
- Pivot and UnPivot columns
- Transpose data
- Working with dates
- Mathematical calculations
- Bonus lesson: greetings and references to my other courses
Who this course is for:
- Anyone who wants to take a leap forward in the use of Microsoft Excel by greatly speeding up their work
- Anyone dealing with especially large Microsoft Excel files
- Anyone dealing with badly made and uncomfortable Microsoft Excel files
- Anyone dealing with Microsoft Excel files to do data analysis and draw conclusions
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: FREEFROM29 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.
