Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction: Learn to create, insert and modify a function|
In this lesson you will find out also about the parts of a formula.
Discover various methods to insert a functionPreview
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.
|Section 2: Excel formulas used in great and understandable projects|
Take use of a smart tool Formula Autocomplete
Solve your tasks quicker with maths functions
See the big picture of your database using statistical functions
Define and use names in formulas
Date and time functions that update and extract your datesPreview
Information functions to verify your database
Text functions to convert between Upper and Lower case
Text functions for a cleaner and more arranged database
If logical function in practice
Practicing absolute and relative cell reference in a logical project
Vlookup your data in the same sheet
Vlookup your data in a different sheet
Have a result depending on multiple formulas with nested functions
|Section 3: Excel tips and tricks for interactive dashboards|
Add your formulas and formats in the same time in different sheets
Copying data, sheets and formats for different rowsPreview
Easy synthesize your data with great tips on using pivot table
Tips of copying data, rows and columns
Transform your text using text to columns
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.