Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Mastering Essential Excel in 3 HOURS

person icon Damtew Engida

4.1

Mastering Essential Excel in 3 HOURS

Master The Essential Part of Microsoft Excel In Three Hours: Discover 80+ Simple, Short and Practical Projects

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Damtew Engida

English [CC]

category icon Office Productivity,Microsoft Excel

Lectures -75

Duration -3 hours

4.1

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Microsoft Excel is an amazing program. You can get a wealth of Data management and analytics functionality at your fingertips.

This course was designed to focus on the most essential of EXCEL. It covers all the features and capabilities that brand-new users need to get and work in Excel within a short period of time. This mega course covers Data management tools, Data Analysis tools, Function and Formulas, Charts, PivotTable and PivotCharts, Lookup and Reference, Printing and Page setup, and many other Essential Excel. After you finish this course, you'll have the skills you need to start building easy-to-use, accurate spreadsheets in a short period of time.

You will get A Verifiable Certificate of Completion which is presented to all students who undertake this Mastering Excel Analytics Course.

Each lesson will be presented from start to finish, complex topics are taught in a simple way by an instructor with 16 years of experience in data management and analysis area. The contents have been carefully crafted and clearly organized. The videos are high quality with easy to grasp examples. Most importantly you will master the most essential Excel features by doing the provided project examples. Each lesson is accompanied by the project exercise files so that you can do it by yourself at your own pace.

   

  • Easily build dynamic tools & Excel dashboards to filter, display and analyze your data 

  • Go rogue and design your own formula-based formatting rules 

  • Manipulate dates, times, text, and arrays

 You will master a broad range of Excel formulas & functions, including:

  • Date & Time functions and Categorization

  • Advanced Text functions

  • Calculation and Mathematics Functions

  • Counting and Summing Functions

  • Lookup/Reference functions

  • Formula based formatting

  • Conditional Formatting

You will get the Full course including downloadable Resources and Project files, lifetime access, and a 30-day money-back guarantee.

Goals

What will you learn in this course:

  • Understand how Excel works and the most efficient way to do most tasks.
  • Build a solid understanding on the Essential of Microsoft Excel
  • Maximize your current EXCEL skill to the next level
  • Create charts with Trend Lines, and Dual Axis
  • Easily build dynamic Chart & Excel Dashboards to Filter, Display and Analyze
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Master Data management tools: Sort, Filter, Split, Remove and Validate
  • Master Data Analysis Tools: GoalSeek, Scenario, Solver & Data Tables

Prerequisites

What are the prerequisites for this course?

  • Familiarity with Microsoft Excel 2010 or Newer.
  • Motivation to master the most Essential part of Microsfot Excel
  • Be ready to grasp the concept within short period of time
Mastering Essential Excel in 3 HOURS

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
1 Lectures
  • play icon Introduction 01:53 01:53
Getting Started With Microsoft Excel
9 Lectures
Tutorialspoint
Manipulating Data Entry In Excel
5 Lectures
Tutorialspoint
Understanding And Using Formulas & Functions
7 Lectures
Tutorialspoint
Understanding And Using Formatting Methods
9 Lectures
Tutorialspoint
Exploring Worksheet Layout And Data
4 Lectures
Tutorialspoint
Page Setup And Printing
3 Lectures
Tutorialspoint
Understanding And Using Excel Charts
5 Lectures
Tutorialspoint
Exploring Worksheet Views
3 Lectures
Tutorialspoint
Exploring Workbooks And Multiple Worksheets
5 Lectures
Tutorialspoint
Vlookup, CountIF and IF Functions
4 Lectures
Tutorialspoint
Working With Security And File Sharing
3 Lectures
Tutorialspoint
Essential Data Management Tools
7 Lectures
Tutorialspoint
Essential Data Analysis Tools
4 Lectures
Tutorialspoint
Pivot Tables And Pivot Charts
6 Lectures
Tutorialspoint

Instructor Details

user profile image

Damtew Engida

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515