Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
7 Hour(s) 0 Minute(s)
Language
English
Taught by
Marlon Anan
Rating
1 views
Course Overview
Excel in 2023 : Learn the power of every aspect of Excel from Data Entry to Functions to Pivot Tables and M-code.
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.
Course Content
- 10 section(s)
- 352 lecture(s)
- Section 1 Overview
- Section 2 Basic Commands
- Section 3 Basic Commands 2
- Section 4 Formatting
- Section 5 Shapes and Texts
- Section 6 Referencing
- Section 7 Tables
- Section 8 Data Tools
- Section 9 Conditional Formatting
- Section 10 Find and Replace
What You’ll 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.
Skills covered in this course
Reviews
-
PPavan Kumar
Very good
-
UUdemy User
I loved this course. Tutor had gone through in details for every Excel functions. I have known all Excel functions from this course and which will be helpful to me at Job.
-
AALISHA
Yes it was a good match for me to learn about excel.
-
SSahib
nice
