Master Advanced Excel skills in a few hours. Begin now!

Course details

Become an expert in the most relevant advanced topics of Microsoft Excel in a few hours, increase your speed of working and sip your coffee (and relax) and by letting macros do all the work for you, and learn how to use pivot tables to easily and accurately summarize data, in a matter of seconds. And many, many more!

Although this Advanced course is for Excel 2007, you can still use the skills you learn here for the later versions of Excel, including Excel 2010, 2013 and 2016.

If you have the basic skills of using Excel, then this a perfectly logical step to take to increase your Excel skills to complete the whole picture. Master the topics in this course, and you can conquer the world. No one can tell you that you lack the most popular and most relevant advanced skills that you need in Excel. The next logical step is to start today to learn the advanced skills of Excel. And in this course, you will learn exactly that.

Topics in this course include:

• Use macros to automate the routine tasks.
• Use charts to visually analyse data and take corrective actions.
• Link Excel data with outside data including Access database.
• Workbook and worksheet protection.
• VLOOKUP function.

Free Training Files are included which you should use to follow along. You may download the training files for free to your computer.

• By taking this course, you will learn how to use styles to highlight cells that meet a certain criteria, such as top ten clients in terms of revenue.
• Learn how to use the IF function to let Excel work out which reps get the highest commission and which get the lowest commission.
• Use the VLOOKUP function to use a unique value to fetch data for you from another sheet quickly and easily.
• Do not count how many characters there are in a cell: instead, use the LEN function to do that for you accurately and quickly.
• Use the CONCATENATE function to join two or more cells into one cell.

BONUS:

• FREE 2 videos (worth $10) showing how to expand the formula bar for those times when you have long formulas and functions, as well as summing up named ranges.

Get ready to upgrade your skills to the Advanced level of Excel today! If you change nothing, then nothing will change...

Take the course now!