Microsoft Excel Tips and Tricks

Empower yourself with advanced Excel skills and techniques in our "Excel Tips and Tricks" course. This comprehensive course is designed to enhance your proficiency in Microsoft Excel, equipping you with a toolkit of powerful features, shortcuts, and strategies to boost your productivity and streamline your data management tasks.

Intermediate 0(0 Ratings) 229 Students enrolled English
Created by Hut to Hut Solutions
Last updated Fri, 18-Aug-2023
+ View more
Course overview

This dynamic and hands-on learning experience is designed to elevate your Excel skills to the next level by introducing you to a wide range of advanced features, shortcuts, and techniques. Whether you're a beginner or an experienced user, this course will empower you to work smarter, faster, and more effectively with your data.

What will i learn?

  • A strong foundation in productivity using Microsoft Excel
Requirements
  • A computer with Microsoft Excel installed and occasional access to the internet
Curriculum for this course
39 Lessons 02:01:32 Hours
Introduction to Microsoft Excel Tips and Tricks
2 Lessons 00:06:07 Hours
  • Introduction
    00:03:04
  • Creating Named Ranges
    00:03:03
Filtering & Sorting Data
5 Lessons 00:19:11 Hours
  • Filter by color
    00:07:37
  • Sorting Data
    00:02:52
  • Table Filters
    00:02:11
  • Slicers
    00:03:43
  • Count Filtered Records
    00:02:48
Functions in Excel
7 Lessons 00:24:29 Hours
  • Count If Function
    00:03:43
  • Summing Value
    00:03:11
  • Generating Random Numbers
    00:02:24
  • Using the Trace Tools
    00:03:20
  • Excel Time-Based Computations
    00:03:02
  • Using the Trim Function
    00:03:11
  • Using the Vlookup Function
    00:05:38
Pivot Tables
7 Lessons 00:19:38 Hours
  • Creating Pivot Tables
    00:05:18
  • Pivot Table Formats
    00:01:50
  • Pivot Table Grand Totals
    00:01:20
  • Pivot Table Filters
    00:02:53
  • Pivot Table Groups
    00:02:34
  • Pivot Table Slicers
    00:03:05
  • Pivot Charts
    00:02:38
Productivity Tips
18 Lessons 00:52:07 Hours
  • Merging Cells
    00:02:24
  • Using the Speak Feature
    00:01:52
  • Quick Access Keys
    00:02:11
  • Tab Colors
    00:01:25
  • Custom Toolbars
    00:05:03
  • Transpose
    00:01:23
  • Text to Column
    00:03:19
  • Numbering
    00:01:44
  • Creating Tables
    00:03:53
  • Changing Case
    00:02:41
  • Insert Comments and Notes
    00:02:37
  • Insert Hyper Links
    00:02:18
  • Copy and Pasting Formats
    00:02:09
  • Embedded Objects
    00:03:18
  • Creating Named Ranges
    00:03:50
  • Creating Drop Down Lists
    00:04:10
  • Creating a Simple Data Entry Form
    00:05:09
  • String Concatenation
    00:02:41

Frequently asked question

Who is this course designed for
This course is designed for individuals at all levels of Excel proficiency, but users should be familiar with basic Microsoft Excel. Whether you're looking to enhance your data analysis skills, streamline your workflow, or become an Excel power user, this course has something to offer for everyone.
How is the course structured
The course is divided into modules, each focusing on a specific topic or set of Excel tips and tricks.
Is there a certificate of completion
Yes, upon successfully completing the course and any required assessments, you will receive a certificate of completion. This certificate can be a valuable addition to your resume and showcase your proficiency in Excel.
Can I access the course materials after completion
Yes, you will have continued access to the course materials
+ View more
Other related courses
03:12:43 Hours
Microsoft Excel Mastery
Updated Sun, 11-Jun-2023
5 144 Free
01:09:28 Hours
Microsoft Word Tips and Tricks
Updated Fri, 18-Aug-2023
0 239 Free
About instructor

Hut to Hut Solutions

11 Reviews | 537 Students | 40 Courses
Web Development Design Productivity Tools Information systems Databases GIS
Student feedback
0
0 Reviews
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Reviews

Free
Get enrolled
Includes: