Course Description
In today's workplace, knowing how to use Excel has got to be the
NUMBER ONE skill that everyone needs to have. Excel is easy to get
started with and most people are just self taught, but do they really
KNOW Excel? Are they using it the right way? Usually the answer is no
and there is a lot of time being wasted.
This course can change all of that.
By learning Excel from the ground up, and learning the BEST, quickest
way to do any given task, this is your opportunity to jump ahead of
most people and become not just good with Excel, but AWESOME!
If
you are willing to take the time to go through this course and do the
exercises, you could easily be more proficient than most in just a few
days from now!
This course is "hands on" and has exercise files
for every lecture. This is not a course you just watch - you learn new
techniques by doing them.
There is a HUGE need in the marketplace for people who REALLY know how to use Excel. This is your opportunity to break away from the pack of
people who struggle to get their work done using Excel. Stop being
like everyone else and and learn how to use Excel MUCH more effectively
than just about anyone else!
This could be your shortest path to increasing your income!
Course Details
Aligning of Cell Contents
Background Fill, Patterns and Effects
Basic Formatting
Basic Formulas
Basic Selecting With The Keyboard
Basic Selecting With The Mouse
Borders
Bruce's Introduction
Columns and Rows Quiz
Conditional Formatting 1
Conditional Formatting 2
Copy Cells or Ranges
Copy or Move Columns and Rows
Copying and Moving Quiz
Copying Formulas and Absolute References
Create 6 Month Totals and Adjust Column Widths
Create Combined Name Column and Change Margins
Custom Fill Series
Custom Number Format Exercise
Custom Number Formats
Date Formats
Editing Data
Entering and Editing Data Quiz
Entering Dates
Entering Numbers
Entering Symbols
Entering Text
Excel Data Entry Helps
Fill Handle Basics
Final Adjustments and Print Preview
Fixing Circular References
Format a Table and Use Filters
Formatting Numbers
Formatting Quiz
Formulas on Dates
Formulas Quiz
Formulas with Text
Functions Quiz
Getting Started: How To Use This Course To Gain The Maximum For Our Teachings!
How to Use Fill Series
Inserting, Deleting, Hiding and Unhiding Columns and Rows
Intro to the Quick Analysis Tool
Looking at the Task and Getting Started
Modify Print Titles and add Header and Footer
More Functions
Move Cells or Ranges
Move or Copy Sheets
Multiple Criteria in an If Statement
Multiple Worksheets
Multi-Sheet Formulas
Multi-Sheet Range Names
Naming Ranges Quiz
Navigating Worksheets with Ctrl+Arrow Keys
Overview of Naming Ranges
Print Exercise Quiz
Proper, Round and Other Functions
Resizing Columns and Rows
Rule of Order
Saving and Opening Files
Section 1: Welcome To Our Microsoft Excel 2016 Master Class Course: Beginner To Adanved
Section 10: Functions
Section 11: Formatting Worksheet Contents
Section 12: Table Filters and KEYBOARD SHORTCUTS
Section 13: Bringing It All Together PRINT Exercise
Section 14: Payment Function and What If Analysis
Section 15: Finding and Fixing Errors
Section 2: Worksheet Basics
Section 3: Manipulating Columns and Rows
Section 4: Entering Data
Section 5: Selecting Cells and Ranges
Section 6: Formulas
Section 7: Copying and Moving
Section 8: The Fill Handle
Section 9: Naming Ranges
Selecting Cells and Ranges Quiz
SUM - The Most Popular Function
Table Filters Quiz
The Extend Key
The Fill Handle Quiz
The IF Function
The Parts of the Excel Screen
The Ribbon - How Does It Work?
The Worksheet - What Is It?
Time Formats
Undoing Changes
Use Quick Analysis and Angle Alignment on Titles
Using 1 and 2 Variable Data Tables
Using Data Slicers
Using Error Checking
Using GOAL SEEK
Using Range Names Like Bookmarks
Using the Clipboard Task Pane
Using the PMT Function
Using the SCENARIO MANAGER
VLookup 1 - Simple Example
VLookup 2 - Match Within a Range
Vlookup 3 - Intro to Data Validation Lists
Vlookup 3 - Multiple VLookups Using the Validation List
Welcome To Our Course! Learn All of The Benefits Using Microsoft Excel Today!
Worksheet Basics Quiz
LINK FOR THE FREE COURSE
100% Off, Udemy 100% Off, Udemy Coupon, Udemy Coupon Code, Udemy course, Udemy course download, Udemy course reviews, Udemy courses, Udemy courses for free, Udemy courses free, Udemy courses free download, Udemy discount, Udemy download, Udemy education, Udemy free, Udemy free course, Udemy free courses, Udemy free online courses, Udemy online, Udemy online course, Udemy online courses, Udemy online courses review, Udemy reviews, Udemy tutorial, Udemy tutorials, Udemy.com free courses,
No comments:
Post a Comment
Note: only a member of this blog may post a comment.