Excel shortcuts Master – Increase speed by 100%
Excel shortcuts Master – Increase speed by 100%, available at $34.99, has an average rating of 3.7, with 41 lectures, 12 quizzes, based on 11 reviews, and has 3914 subscribers.
You will learn about Master easy memory shortcuts, functions, and formulas to save time speed up you skills Master 17 most popular functions: Vlookup, Hlookup, Index, Match, Choose, Offset, IF Statement, Indirect, Address, Sumif/Sumifs, Average/Averageifs, Round Functions, Counta/Countif, Concatenate, etc Know basic knowledge of recording Macros and create Pivot Table Stand out in an interview or move up the ladder by dramatically boosting your Excel skills and confidence at work Create Report in a fast pace and give your boss a shock This course is ideal for individuals who are This course started by assuming you have never use Excel before and quickly processes through Excel's most useful and powerful feature. or If beginning chapters to be too basic for you, you can skip to the next chapter. or Disconnect the mouse with your computer and use keyboard only is the most efficient way to learn shortcuts or Through practice and master all the shortcuts, you will shock by your own efficiency. It is particularly useful for This course started by assuming you have never use Excel before and quickly processes through Excel's most useful and powerful feature. or If beginning chapters to be too basic for you, you can skip to the next chapter. or Disconnect the mouse with your computer and use keyboard only is the most efficient way to learn shortcuts or Through practice and master all the shortcuts, you will shock by your own efficiency.
Enroll now: Excel shortcuts Master – Increase speed by 100%
Summary
Title: Excel shortcuts Master – Increase speed by 100%
Price: $34.99
Average Rating: 3.7
Number of Lectures: 41
Number of Quizzes: 12
Number of Published Lectures: 41
Number of Published Quizzes: 12
Number of Curriculum Items: 53
Number of Published Curriculum Objects: 53
Original Price: $22.99
Quality Status: approved
Status: Live
What You Will Learn
- Master easy memory shortcuts, functions, and formulas to save time speed up you skills
- Master 17 most popular functions: Vlookup, Hlookup, Index, Match, Choose, Offset, IF Statement, Indirect, Address, Sumif/Sumifs, Average/Averageifs, Round Functions, Counta/Countif, Concatenate, etc
- Know basic knowledge of recording Macros and create Pivot Table
- Stand out in an interview or move up the ladder by dramatically boosting your Excel skills and confidence at work
- Create Report in a fast pace and give your boss a shock
Who Should Attend
- This course started by assuming you have never use Excel before and quickly processes through Excel's most useful and powerful feature.
- If beginning chapters to be too basic for you, you can skip to the next chapter.
- Disconnect the mouse with your computer and use keyboard only is the most efficient way to learn shortcuts
- Through practice and master all the shortcuts, you will shock by your own efficiency.
Target Audiences
- This course started by assuming you have never use Excel before and quickly processes through Excel's most useful and powerful feature.
- If beginning chapters to be too basic for you, you can skip to the next chapter.
- Disconnect the mouse with your computer and use keyboard only is the most efficient way to learn shortcuts
- Through practice and master all the shortcuts, you will shock by your own efficiency.
-
This course is design for beginner. Excel expert will also benefit from this course since almost everything can be done with keyboard shortcuts with quicker speed compare with using mouse.
-
Learning keyboard shortcuts and more advanced functions in excel will greatly improve the efficiency and save your job.
-
Disconnect the mouse from your computer and using only the keyboard is the most efficient way to learn shortcuts.
-
Through practice and master all the excel keyboard shortcuts, you will be shocked by your own efficiency.
-
By applying those shortcut, you could stand out in your team and be the best.
-
$9.99 Promotion Code: SC2019A, please use this code when register the course for lower price $9.99
Course Curriculum
Chapter 1: Welcome to Excel
Lecture 1: Introduction
Lecture 2: Excel Setting
Chapter 2: Excel Basics
Lecture 1: Basic Excel Shortcuts
Lecture 2: Format Cells
Lecture 3: Referencing Cells
Lecture 4: Move Between Workbooks and Zoom In
Chapter 3: Most Popular Excel Shortcuts
Lecture 1: Freezing & Splitting
Lecture 2: Shortcuts inside formula and clear
Lecture 3: Highlight, Add, Delete Rows and Columns
Lecture 4: List of Paste Special shortcuts
Lecture 5: Ctrl and Ctrl Shift Shortcuts
Lecture 6: Add Worksheets, delete worksheets and Naming worksheets
Lecture 7: Using $ to fix cells and How to give cell a name
Lecture 8: Hiding Columns or Rows vs Grouping
Lecture 9: Find and Replace
Lecture 10: Go to Special
Lecture 11: Format Cells – Custom, use of & in formulas, and Text Function
Lecture 12: Conditional Formatting and Conditional Formatting Manager
Lecture 13: Merge & Center
Lecture 14: Printing Master_Page layout
Lecture 15: Group selected worksheets
Chapter 4: Advanced Excel Function for data management
Lecture 1: HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEX Functions
Lecture 2: Match Function
Lecture 3: Match with HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEX
Lecture 4: Indirect, Address & Match
Lecture 5: One Variable and Two Variable Data Table
Chapter 5: IF Statement
Lecture 1: How to Use IF Function
Lecture 2: IF Function with And & Or
Chapter 6: Math Function
Lecture 1: Average, Sum, Max & Min
Lecture 2: SUMPRODUCT
Lecture 3: Sumproduct with Criteria
Lecture 4: SUMIF/S & AVERAGEIF/S
Lecture 5: COUNT/A & COUNTIF/S
Chapter 7: Data Management
Lecture 1: Concatenate
Lecture 2: Remove Duplicate
Lecture 3: Filter
Lecture 4: Text to Columns
Lecture 5: Sort and Subtotal
Lecture 6: Pivot Table
Lecture 7: Macro
Lecture 8: Bonus Lecture
Instructors
-
Derek Humble
Financial Analyst
Rating Distribution
- 1 stars: 1 votes
- 2 stars: 1 votes
- 3 stars: 4 votes
- 4 stars: 1 votes
- 5 stars: 4 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 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024