Course Description
This is the Ultimate Microsoft Excel Course which has over 140 short and precise tutorials.
This course was created by a hand-pick of Udemy's best Excel
instructors, so you are sure to benefit from their unique Excel skills.
The course covers all of Excel´s must-know features which include the
Excel Ribbon, Formatting, Formulas & Functions, Excel
Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA, Data
Validation, Excel 2016 new features and keyboard shortcuts!
No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single tool that is available in Microsoft Excel.
The course is designed for Excel 2007, 2010, 2013 or 2016. There are 16 different chapters so
you can work on your weaknesses and enhance your strengths. Each
chapter was designed to improve your Excel skills with extra time saving
Tips and real life business Case Studies.
In no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to work with various time saving Formulas, create automated reports with the press of a button, WOW your boss with stunning Excel Charts and get noticed by top management & prospective employers.
The course is just over 10 hours long so you can become an awesome analyst and advanced Excel user within 1 week!
In this course there are FREE downloadable Excel workbooks for each tutorial and a BONUS video section as well as each instructor's favorite Excel shortcuts.
We have collectively been helping over 45,000 Udemy students further their professional careers by teaching them Excel the easiest and most comfortable way.
These tutorials will give you career-building skills that you can use to become better and more efficient at your job.
If you really want to stand out from your colleagues and improve your professional development to achieve greater opportunities like promotions, a higher salary, knowledge that you can take to another job, etc....then this course is for YOU!
You'll have lifetime online access to watch the videos whenever you like, and there's a Q&A forum right here on Udemy where you can post questions - and we will answer them personally within the day!
We are so confident that you will get lots of value from
this course that you can take it for the full 30 days, download all the
workbooks, watch all the videos and apply it to your work to see the
results. If you're not 100% satisfied, we will be more than happy to refund the full purchase amount!
Curriculum
Working with Workbooks and Worksheets
2-Way Lookup
Absolute vs. Relative Cell References
Adding Row Calculations and Changing the Table Size
Adding the Total Row to an Excel Table
CALCULATED FIELD: Creating a Calculated Field
CALCULATED ITEM: Creating a Calculated Item
Comparing Lists
CONDITIONAL FORMATTING: Introduction
Course Overview
Create a Bar Chart
Create a Line Chart
Create a Pie Chart
Create Formulas to Quickly Calculate Your Costs
Creating Simple Formulas to do Powerful Calculations
CUSTOMIZING: Change Count of to Sum of
CUSTOMIZING: Drill down to audit
CUSTOMIZING: Excel Tables
CUSTOMIZING: Format error values
CUSTOMIZING: Formatting
CUSTOMIZING: Inserting a Pivot Table
CUSTOMIZING: Move a Pivot Table
CUSTOMIZING: No Gaps
CUSTOMIZING: Pivot Table Styles
CUSTOMIZING: Refresh a Pivot Table
CUSTOMIZING: Report Layouts
CUSTOMIZING: Show/Hide Field List
CUSTOMIZING: Tabular Format
Date and Time Formulas
Download for the Next 3 Chart Lectures
Download this Exercise File
Download this Exercise File
Downloadable Excel Workbooks
Downloadable Excel Workbooks
Entering and Formatting Numbers
Entering Data and Navagating Around the Cells
Excel Formula Review
Filter Records Using an Excel Slicer
Filtering Records in an Excel Table
FILTERING: Filter by Dates
FILTERING: Filter by Text
FILTERING: Filter by Values
Financial Formulas
Format Excel List as Excel Table
Format Your Chart
Formatting - Grids and Spacing
Formatting Subheadings and Columns, and Alphabetizings Lists
GROUPING: Group by Date
GROUPING: Group by Sales ranges
GROUPING: Group by Text fields
How to Quickly Select Cells to Use in Your Formula
Informational Formulas
Introduction - Creating and Formatting Your Heading
Introduction - How to Create a Chart
Introduction to Excel Basics
Logic Formulas
Looking to the Left
Mathematical Formulas
Menu Example
PIVOT CHARTS: Insert a Pivot Chart
PIVOT CHARTS: Insert a Slicer with a Pivot Chart
Pivot Table Customization Review
Printing Your Work
Put Your Knowledge to Work - Create Your First Excel Document
Quick Tips to Master These Formulas
Review of Creating Your First Spreadsheet
Review of Excel Basics
Review of How to Create Charts
Review of Introduction to Formulas and Functions
Saving Your Document Where You Can Find It
Section 1: Excel Basics
Section 2: Create Your First Excel Spreadsheet From Scratch
Section 3: Charts - How to Create Bar, Column and Pie Charts
Section 4: Introduction to Excel Formulas and Functions
Section 5: Top 50 Excel Formulas
Section 6: VLOOKUP Deep Dive
Section 7: Working with Excel Tables
Section 8: PIVOT TABLES: Customization
Section 9: PIVOT TABLES: Analytical Tools
SHOW VALUES AS: % Difference From
SHOW VALUES AS: % of Grand Total
SHOW VALUES AS: Running Total In (Year to Date)
SLICERS: Insert a Slicer
SLICERS: Slicer Connections for multiple Pivot Tables
SLICERS: Slicer Styles
SORTING: Sort manually (drag, write, right click)
SORTING: Sort using a Custom List
SORTING: Sorting by Largest or Smallest
SUMMARIZE VALUES BY: Average
SUMMARIZE VALUES BY: Count
SUMMARIZE VALUES BY: Maximum
Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon
Text Formulas
The Anatomy of a Formula
Using Excel Templates to Save Time and Effort
VLOOKUP Review
Vlookup Tips & Tricks
What is a Formula?
What is a Function?
Wildcard Search
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,
