Master Excel from Basic to Advanced in 2024

Excel in 2023 : Learn the power of every aspect of Excel from Data Entry to Functions to Pivot Tables and M-code.

Ratings 4.21 / 5.00

Master Excel from Basic to Advanced in 2024

What You Will Learn!

Students will learn a basic to advanced comprehension and usage of the Excel interface. They will know who to use the commands and manipulate the basic ribbon.
Students will also learn a basic to advanced comprehension and usage of a large array of functions.
Students will learn the fundamentals of programming using VB Excel.
Students will learn basic to advanced Power Query, and an introduction to M-code.
Students will learn about ActiveX, Form objects and the usage of the Excel Forms
Students will learn how to use the basic default commands on the default Excel ribbon.

Description

Hi, and welcome on behalf of all of us here at Xcell’N Excel. Our team has put together an ongoing and current course on the major aspects of Excel. In this course, you will learn:

· Basic data entry - learn simple and advanced data input and keystrokes.

· Formatting - learn how to affect the font, styles, border colors and sizes.

· Functions - learn the power of Excel through basic to advanced inbuilt functions.

· Dynamic Arrays – learn about the power of this new technology for performing calculations.

· Pivot Tables - learn how to summarize and analyze data.

· Power Query - learn how to transform and connect to different data forms.

· Printing – learn the seeming mysteries of printing documents.

· VBA - learn the basics of VBA coding

· Charts - insert charts of different formats for professional visual presentation of your data.

· M-Code – learn the basics of this robust language that powers Power Query and a lot more...

Our course will be updated on a weekly basis to help keep you up to date.

Although we have tried to cater this course to users of 2010 upwards, be aware that some of the material such as Dynamic Arrays will not work with older, legacy versions.

Plus, we will always be here to hear what you have to say and help as you grow in your knowledge of the most popular spreadsheet software in the world.