Login

**Farid** · 10-09-2023, 12:52 PM

Microsoft Excel Shortcuts, Tips and Tricks
Published 10/2023
Duration: 2h 19m | .MP4 1280x720, 30 fps® | AAC, 44100 Hz, 2ch | 1.35 GB
Genre: eLearning | Language: English
25 individual Shortcuts, Tips and Tricks each one in a dedicated tutorial video complete with a practice file and PDF

What you'll learn
Learn a wide range of Excel shortcuts, tips and tricks to make you more efficient, productive, and confident in using Excel
Apply these new skills to your work, studies, or personal projects to streamline your workflow
By the end of this course, students will be able to proficiently navigate Excel workbooks, sheets, and cells using a variety of shortcuts and techniques
Students will learn how to create charts to represent data accurately and communicate numerical information in a visual manner
Requirements
No previous experience of Microsoft Excel is required; each tutorial comes with a dedicated practice file
Description
Excel Shortcuts, Tips and Tricks
Unlock the full potential of Microsoft Excel with our comprehensive "Excel Shortcuts, Tips and Tricks" course on Udemy! Whether you're a beginner looking to enhance your spreadsheet skills or an experienced user aiming to streamline your workflow, this course is designed to elevate your Excel proficiency to the next level.
In this hands-on, step-by-step course, you will learn a wide range of Excel tips and tricks that will make you more efficient, productive, and confident in using this powerful tool. Our expert instructor will guide you through a variety of practical scenarios and real-world examples, ensuring you gain practical skills that you can immediately apply to your work, studies, or personal projects.
Although Microsoft 365 is used throughout these exercises, many of the tips and tricks will work perfectly well on older versions of Excel. The course contains ONLY shortcuts, tips and tricks for Microsoft Excel, there are no fillers and functions and formulas have deliberately been left out.
Course Highlights:
The course contains 25 individual Shortcuts, Tips and Tricks each contained in a dedicated tutorial video complete with a practice file. Each Excel tutorial video comprises step by step instructions, so you never get lost as we go through the techniques.
Discover keyboard shortcuts and techniques that will dramatically reduce your time spent on repetitive tasks.
Data Visualization: Learn how to create compelling charts and graphs to present your data effectively.
Data Analysis: Master data analysis techniques to extract valuable insights from your spreadsheets.
Excel Tips for Efficiency: Get insider tips on Excel's hidden features, customization options, and best practices for optimal efficiency.
Problem-Solving Scenarios: Tackle real-world Excel challenges with step-by-step guidance and solutions.
Practical Exercises: Apply your newfound knowledge through hands-on exercises.
This collection of Excel shortcuts, tips and tricks has consistently been one of the most popular classroom tutorials taught by David, and now everyone can take advantage of them.
In this course we will cover:
Inserting the date and time
Inserting a chart
Formatting shortcuts
Automatically Incrementing
Automatically totalling multiple columns and rows
Selecting large blocks of data and identifying missing data
Adding Conditional Formatting
Creating a Custom List
Inserting a Named Range and using it in calculations
A Smart alternative to the SUM function
Identifying duplicated without deleting them
Creating a drop-down list
Automatically updating totals when data expands
Applying layout changes to sevaeral worksheets at once
Adding buttons to the QAT
Setting and clearing the Print area and repeating titles
Making a Heat Map to visualize data
Conditional formatting using a formula
Creating a weighted average for an accurate picture
The brand new Analyze Data button
Filling downwards and eliminating blank cells
Using Flash Fill
Importing data from a web page
The Advanced Filter functionality
The Quick Analysis tab
By the end of this course, you'll be equipped with a toolbox of Excel shortcuts tips and tricks that will set you apart in the workplace and empower you to tackle complex data tasks with ease. Whether you're a business professional, student, data analyst, or anyone who uses Excel, this course will help you become a proficient Excel user.
Join us today and take your Excel skills to the next level. Enrol now and start mastering Excel's full potential!
Who this course is for:
Whether you're a beginner looking to enhance your spreadsheet skills or an experienced user aiming to streamline your workflow, this course is designed to elevate your Excel proficiency to the next level.