Data Manipulation In Excel
Genre: eLearning | Level: Intermediate | Language: English
Learn data manipulation in Microsoft Excel. Get tips and tricks and the best practices to prepare data for analysis.
What are the best ways to manipulate data in Excel? How can I change case in Excel? How to use Text-To-Columns? Can I separate data in Excel? How can I combine data in Excel? What to do when imported dates are not dates? I lost leading zeros in Excel! Answers to these questions are inside! When you enroll in this course and complete it, you will not only be able to do all that, but also will know how to import data in Excel the right way, how to prepare data for analysis, how to clean data in Excel. You will be proficient with useful Excel functions, for example VLOOKUP, IF, LEFT, RIGHT, MID, DATE.
In this Excel course, that provides carefully hand-picked most useful video-training material, you will quickly learn the best practices to work with lists of data in Excel. We will start by looking at the best practices in importing data and discuss the common mistakes that one can make when doing it. Next, you will learn to transform data in Excel in a quick, easy, and creative way. You will benefit by making yourself comfortable using Excel as a data manipulation tool. You will fix data, modify data, upend data, concatenate data and clean it using build-in Excel functionality. You will learn to use creatively various Excel functions, such as: VLOOKUP, IF, LEFT, RIGHT, MID, DATE and some others. You will become comfortable “massaging” your data in very useful and beneficial ways.
The Excel course is using a problem-solving approach. It is divided into several sections. Each section deals with a specific common problem that people encounter in Excel all the time. First, we define the problem and then work through a proven solution to fix it. When you work through the solutions offered by the course, you will quickly be improving your problem-solving skills and start coming up with solutions of your own. And that is the ideal learning, isn’t it? You just have fun working through common problems, and your expertise just happens on its own.
This Excel course is one of the Easy Excel With Igor series. The other high quality Excel tutorials include:
"Microsoft Excel Without Pain" that helps you quickly build your foundation skills in Excel;
"Excel Conditional Formatting Master Class" where you can learn how to improve your spreadsheets using conditional formatting in Excel;
"Excel Pivot Tables Data Analysis Master Class" that takes you step by step to mastering pivot tables data crunching skills;
"Microsoft Excel Charts Master Class" that builds your skills in creating your skills in Excel charts and graphs.
What am I going to get from this course?
Over 26 lectures and 2 hours of content!
Learn to manipulate data in Excel
Save time when doing Excel data manipulation
Learn how to use formulas to transform data in Excel
Learn how to solve real-life Excel problems
Discover tips on how to quickly prepare Excel data for analysis