All Tutorials

Mastering Essential Excel in 3 HOURS Course – Learn Excel

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

What you’ll learn

Understand how Excel works and the most efficient way to do most tasks.
Build a solid understanding of 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

Requirements

Familiarity with Microsoft Excel 2010 or Newer.
Motivation to master the most essential part of Microsoft Excel
Be ready to grasp the concept within a short period of time

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. 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.

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

Who this course is for:

Anyone who works with Excel on a regular basis
For teachers who want to teach the essential part of Excel to their student
Students looking for a comprehensive, engaging, and highly interactive approach to training
Content From: http://www.udemy.com/course/mastering-essential-excel-in-3-hours/
Excel Skills for Business – Scratch to Advanced Level Course