Excel Basics: Helpful Tips & Formulas for Excel

Excel Basics: Helpful Tips & Formulas for Excel

.MP4 | Video: 1280x720, 30 fps(r) | Audio: AAC, 48000 Hz, 2ch | 590 MB

Duration: 1 hours | Genre: eLearning Video | Language: English
Learn how to quickly format, view, and organize your Microsoft Excel data using easy formulas and built-in tools.

What you'll learn

How to use Text to Columns
How Remove Duplicates
How to use VLOOKUP
How to use Concatenate
IF functions
How to use Average/Sum/Median
How to create and use Pivot Tables
How to create Conditional Formatting
Freezing top rows and first columns
Filter from A-Z
Creating a graph/chart
Creating a graph with a secondary axis


Be able to open a basic excel spreadsheet


Microsoft Excel is used by millions of people around the world every day. It is an extremely powerful tool that allows individuals and businesses to easily sort, search, and review large sets of data.

While there are endless possibilities for how to use Excel, there are a number of basic formulas and built-in tools that everyone should know. You can learn these basic tips in under an hour and once you've mastered them you'll be using Excel faster and more efficiently than ever before.

In this course I'm going to show you how to use the following:

Section 1: Must Know Formulas

Text To Column: Split the text into multiple columns based on pre-determine break points

Remove Duplicates: Easily clean up large lists and columns.

VLOOKUP: For a specified value, the function finds (or 'looks up') the value in one column of data, and returns the corresponding value from another column

CONCATENATE: link (things) together in a chain or series

'IF' Function: An if statement is a programming conditional statement that, if proved true, performs a function or displays information

Average/Sum/Median: Quickly get basic information about your data

Section 2: Filters & Conditions

Create a Pivot Table to better view large sets of data

Use Conditional Formatting to visualize your data

Freeze Top Row and First Column

Filter A-Z, by Date, and Numerically

Section 3: Making a Chart

Create your basic chart using Pivot Table data

Create a chart with a Secondary Axis to compare two sets of data at once

This course is perfect for those looking to get a leg-up on their peers, those who use Excel for any function, and those looking to better understand how to take control of their data.

I've been teaching classes on business subjects like Digital Advertising & Marketing, Public Speaking, Email Marketing, and more. Here are some real life review from other classes:

Who this course is for:

Anyone working in a sales role
Students working in Excel
Anyone who's job requires reporting in Excel
Any data heavy jobs
Anyone interested in becoming more efficient in using Excel



[Fast Download] Excel Basics: Helpful Tips & Formulas for Excel

Related eBooks:
Exploring Apple Mac Mojave Edition
OS X Mavericks All-in-One For Dummies
Karma-based API on Apple Platforms: Building Privacy Into iOS and macOS Apps
Teach Yourself VISUALLY Mac OS X Lion
MOS EXCEL EXPERT 77-728 Exam Preparation (Solution Based)
Learn Excel From Scratch
Das Buch fuer Umsteiger Vom PC zum Mac
MacRuby: The Definitive Guide: Ruby and Cocoa on OS {Repost}
Switching to the Mac: The Missing Manual, Yosemite Edition
Macs on the Go!: Mobile Computing Guide
Surviving Digital Forensics: Imaging a Mac Fusion Drive
Take Control The Mac OS X Lexicon
Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.