Master Excel from Basic to Advanced in 2024
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
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
- Planning to Produce Results
- Scrum Crash Course: Scrum Essentials and Scrum Fundamentals
- Social entrepreneurship Fundamentals
- CDO and Data Quality Accelerator:Strategy to Implementation
- IBM BAW
- Pareto Analysis Masterclass: Pareto Specialist (Accredited)
- How to Maximize Profits w/ DoorDash and Grubhub Deliveries
- Great Product Manager: Product Management by a Big Tech's PM
- Lead & Empower Agile Teams To Achieve Success
- Use Cases 2.0 with ChatGPT's Help for Lean IT Requirements
- Use Cases 2.0 with ChatGPT's Help for Lean IT Requirements
- 30 Day Digital Agency
- First pitch checklist to present your startup idea
- First pitch checklist to present your startup idea
- The Listing Presentation Of A Top Producer
- The Listing Presentation Of A Top Producer
- How to Master Hiring: Pick the right candidate every time
- Essential Elements of A Good Business Plan
- Build a Successful Ecommerce WordPress site with proper SEO
- How To Quit Your Day Job To Pursue The Work Of Your Dreams