· Master Microsoft Excel from Beginner to Advanced

Description

· Build a solid understanding on the Basics of Microsoft Excel

· Learn the most common Excel functions used in the Office

· Surprise your boss with what you can do and how fast you are

· Get your knowledge from someone with +12 years of field experience rather than academic unreal one, hence… you won’t waste your time with stuff you won’t need in business

· Description and content are expanding, 8 hours is just a beginning

Who this course is for:

• Anyone who wants or needs to learn Microsoft Excel for their work, studies, ...etc.

Course content

• Introduction to Excel 365
  • Introduction
  • New Workbook
  • Entering Data
  • New Sheet on same workbook
  • Filling Series
  • Paste Options
  • Getting Data From Outside
  • Using Clipboard
  • Font Editing
  • Alignment
  • Dealing with numbers
  • Styles and Formatting
  • Conditional Formatting Why?
  • Configuring highlightcells rules
  • Working With top/buttom rules
  • Using data bars
  • Configuring data bars
  • using color scales
  • Manage multiple rules
  • New Rule Menu
  • Insert/Delete Rows/columns
  • Hide/unhide rows/columns/sheets VB included
  • Cells Applet
  • Notes/Comments
  • Editing / sort & filter / find and replace
  • Using Absolute Referance
  • Dropdown lists
  • Dependent Dropdown lists
  • Freeze Panes
  • Spelling check
• Functions, Intro
  • Intro
  • Difference between functions and formulas
• Compatibility Functions
  • CONCATENATE
  • CELING & FLOOR
  • MODE
  • RANK
• Math functions
  • Basic math
  • AutoSum Quicklist
  • Countif, Sumif, Averageif
  • Countifs, Sumifs, Averageifs
  • ABS & INT
  • Even & Odd
  • Fact & Factdouble
  • Combin & Permut
  • GCD & LCM
  • MOD
  • Round, Roundup, Rounddown & MROUND
  • Power
  • Product
  • Rand & Randbetween
  • Roots
  • Sumproduct1
  • Sumproduct2
• Logical Functions
  • If, nestedIf, IFs, IfNa, Iferror, and & or
• Trigonometric Functions
  • How to use Trigonometric functions
• Text Functions
  • Lower & Upper
  • Len
  • Find
  • Left, Mid & Right
  • Name Splitting
  • Trim
• Lookup Functions
  • Vlookup, Hlookup
• Date Functions
  • Date - Today - date format and subtraction
• Getting more of Excel
  • Format Cells using formula
  • Pivot Tables
  • Protection
  • Solver
  • Solver Example 2
  • 3D Reference
• Graphics
  • Insert - Format Pictures
  • Insert - Format Shapes
  • Insert - Format Icons & SmartArt
  • Insert - Format WordArt
• Charts
  • Introduction
  • Scatter Charts
  • Combo - More Charts
  • Pivot Charts
  • Progress Doughnut
• Printing
  • Printing
• Extras
  • Charts Conditional Formatting
  • Thesaurus
  • Graphs with Better Influence
  • No VBA Form