This class will change the way you are working with Excel and makes you an expert in solving various problems in just a few minutes.
This course provides the information, tips and tricks that will help you save precious time working with all kind of database. Are you tired of copy from side to side? Use formulas and your data will be updated instantly. All you have to do is to write the formula, in only 1 minute. You will stop waste time with the calculation of dates, sums, bonuses, poundage and other.
Do you have Excel database with unformatted data, atypical writing format, commas, too many spaces or other symbols?
Do you have a lot of information that needs synthesizing but first your data has to be in the same format or you need to import an Excel database into a program and these require a specific format?
By learning the lessons from this course you will use formulas, the tips and tricks for an easy to manage database and finish your project in a few minutes. If you have periodical reports with the same format, from now on all you have to do is to copy the new base over a head table and you will have the information updated. You will learn tricks for copying information, mechanisms to have the same formulas in different sheets and will have the knowledge that helps you clean the database.
You have a lot of working files to practice all that you learn.
In this lesson you will find out also about the parts of a formula.
In this lesson you will find out various methods for changing an excel formula. After watching this lesson please download these working files that will help you have the best practice.
I am Excel Instructor, Project manager at Coface and General Manager of the Lucrasium Learn Company
My education includes a bachelor degree at the Academy of Economic Studies – Faculty of Finance, Insurance, Banking and Stock Exchange and a Master at the University of Political, Science and Public Administration and I am a project leader at Coface (multinational company, present in over 98 countries) and the owner of the Lucrasium Learn Company.
I always had an attraction for numbers and logical thinking and from the age of 10 I was sure that finance is my life. If you ask a friend of mine what my nickname is, the answer will be “Count”. With an experience of more than 12 years in working with Excel, I can say that is a passion of mine. During this period I learned all the secrets of probably the most used program in the business sector. Due to the high volume of work, I looked for the most efficient solutions and managed to provide courses for students and working class people. I helped and trained numerous individuals that managed to increase their working productivity. As a comparison, if a person had to provide a report that was being done in a half a day, after learning the course from me, the job was ready in just a half an hour. I also provided over 52 courses in Excel, Access, Word, Powerpoint, Business Administration, Finance, Efficient Working, Time Management and Personal Development.