HOT
blank

Master Excel from Basic to Advanced in 2024

Office Productivity

Rating4.3
Enroll Now

Master Excel from Basic to Advanced in 2024, available at $79.99, has an average rating of 4.3, with 352 lectures, 75 quizzes, based on 32 reviews, and has 209 subscribers.

You will learn about 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. This course is ideal for individuals who are Beginner Excel learner and user. It is particularly useful for Beginner Excel learner and user.

Enroll now: Master Excel from Basic to Advanced in 2024

Summary

Title: Master Excel from Basic to Advanced in 2024

Price: $79.99

Average Rating: 4.3

Number of Lectures: 352

Number of Quizzes: 75

Number of Published Lectures: 351

Number of Published Quizzes: 75

Number of Curriculum Items: 427

Number of Published Curriculum Objects: 426

Original Price: $19.99

Quality Status: approved

Status: Live

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.

Who Should Attend

  • Beginner Excel learner and user.

Target Audiences

  • Beginner Excel learner and user.

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 Curriculum

Chapter 1: Overview

Lecture 1: Excel Basic Overview

Chapter 2: Basic Commands

Lecture 1: Section Overview

Lecture 2: Create a New Document

Lecture 3: Keyboard Movements

Lecture 4: Basic Input

Lecture 5: Basic Input 2

Lecture 6: Custom Ribbon

Lecture 7: Quick Access Tool Bar

Chapter 3: Basic Commands 2

Lecture 1: Section Overview

Lecture 2: Copy, Move, Rename Sheets

Lecture 3: Adjust Column and Row Size

Lecture 4: Insert and Delete Rows and Columns

Lecture 5: Using the Shift Key

Lecture 6: Format Painter

Lecture 7: Clipboard

Lecture 8: Cut and Paste

Lecture 9: Copy and Paste 1

Lecture 10: Copy and Paste 2

Lecture 11: Copy/Cut with Enter

Lecture 12: Save Options

Lecture 13: Save As/ Save

Chapter 4: Formatting

Lecture 1: Section Overview

Lecture 2: Font

Lecture 3: Wrap Text

Lecture 4: Border 1

Lecture 5: Borders 2

Lecture 6: Merge Cells

Chapter 5: Shapes and Texts

Lecture 1: Section Overview

Lecture 2: Shapes

Lecture 3: Shapes 2

Lecture 4: Shapes 3

Lecture 5: Text Box

Lecture 6: Smart Art

Chapter 6: Referencing

Lecture 1: Section Overview

Lecture 2: Relative Referencing

Lecture 3: Absolute Referencing

Lecture 4: Mixed Referencing

Chapter 7: Tables

Lecture 1: Section Overview

Lecture 2: Tables 1

Lecture 3: Tables 2

Lecture 4: Tables 3

Lecture 5: Slicer

Chapter 8: Data Tools

Lecture 1: Section Overview

Lecture 2: Consolidate

Lecture 3: Data Validation 1

Lecture 4: Data Validation 2

Lecture 5: Data Form Entry

Lecture 6: Remove Duplicates

Lecture 7: Scenario Manager

Lecture 8: Goal Seek

Chapter 9: Conditional Formatting

Lecture 1: Section Overview

Lecture 2: Conditional Formatting 1

Lecture 3: Conditional Formatting 2

Lecture 4: Conditional Formatting 3

Chapter 10: Find and Replace

Lecture 1: Section Overview

Lecture 2: Find

Lecture 3: Replace

Chapter 11: Fill

Lecture 1: Section Overview

Lecture 2: Flash Fill 1

Lecture 3: Flash Fill Command

Lecture 4: Create Custom Edit Lists

Chapter 12: Error Checking

Lecture 1: Section Overview

Lecture 2: Auditing Tools 1

Lecture 3: Auditing Tools 2

Lecture 4: Watch Window

Lecture 5: Synchronous View

Chapter 13: Printing

Lecture 1: Section Overview

Lecture 2: Printing

Lecture 3: Printing 2

Lecture 4: Printing 3

Instructors

  • Marlon Anan
    Marlon Anan
    Programmer, Game Developer, Machine Learning learner

Rating Distribution

  • 1 stars: 1 votes
  • 2 stars: 0 votes
  • 3 stars: 3 votes
  • 4 stars: 11 votes
  • 5 stars: 17 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Chatgpt And Ai Tools Courses to Learn in November 2024

Top 10 Excel Vba Courses to Learn in November 2024

CreateStudio 2D Animation and 2D Animation Marketing Videos