Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 3 hours on-demand video
  • 31 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel

Microsoft Excel tricks (MacBook & Windows) beginner-advanced

Became advanced user today! Hack 2010, 2013, 2016, Excel 2019, Office 365: functions & formulas, data analytics, charts!
Rating: 3.9 out of 53.9 (462 ratings)
48,847 students
Created by Denis Kulikov
Last updated 5/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • More then 40 Microsoft Excel tricks ( for Windows and Macbook)
  • Microsoft Excel Functions & formulas - XLOOKUP, FILTER, CONVERT, UNIQUE, CHOOSE, PMT (and a lot more)
  • Microsoft Excel Beginners tricks - 3D references, Transpose, Filled Map, Autofit, how to ad your own picture in a charts (and a lot more)
  • Microsoft Excel features for data analysis and visualization - Getting  data from web, Advanced filter, Pivot tables, Analysis Tool pack
  • Microsoft Excel features for business, finance and forecast - What if analysis, Scenario manager, Payment (PMT), Goal seek
  • Microsoft Excel ittle useful tricks, such as - tracking changes, Excel translator, Excel Ideas and how to do VLOOKUP on left side
  • You will know a lot of Microsoft Excel SHORTCUTS
  • Learn the most common Excel functions and formulas used in the Office
  • Maintain large sets of Excel data in a list or table ( plus data analysis )
  • Learn how to use Pivot Tables, Slicers and other Excel visualization tools for Interactive Excel Reports
  • Get lifetime access to Excel quizzes and exercises

Requirements

  • You need PC, notebook or MacBook
  • You have to have Microsoft Excel or access to Google Spreadsheets

Description

*** This "Microsoft Excel tricks (MacBook & Windows) beginner- advanced"  course access includes project files, quizzes & homework exercises, Excel workbook with all sheets from course, 1-on-1 instructor support, LIFETIME access and a money-back guarantee!***

__________

MICROSOFT EXCEL TRICKS( & HACKS) (MACBOOK & WINDOWS) BEGINNER - ADVANCED" DESCRIPTION:

Microsoft Excell nowadays is an absolutely essential tools for life. The truth is that, Microsoft Excel is a really powerful, and dynamic data performing software . Absolutely everyone could get their life on a new level after studying this "Microsoft Excel tricks ( hacks) (Macbook & Windows) beginner - advanced" course and applying this knowledge in their lives.

This "Microsoft Excel tricks ( hacks) (Macbook & Windows) beginner - advanced" provides you with all the tools and instruments which you need, to understand this software.

I am sure it is not so important to remember each of the functions, more essential is how to understand how Microsoft Excel "thinks" and know where you could find explanation of function which do you need.


Thats why my  "Microsoft Excel tricks ( hacks) (Macbook & Windows) beginner - advanced" consists of very individual, deep  and simple explanations of:

  1. Excel functions and formulas,

  2. tricks and shortcuts,

  3. and data visualization and data analysis tools.

which I placed separately. In this case if you forget some function you could come back to my video course and refresh all information in your memory.


We are cover here so different and interesting tricks, as:

  • Microsoft Excel Functions & formulas - XLOOKUP, FILTER, CONVERT, UNIQUE, CHOOSE, PMT (and a lot more)

  • Microsoft Excel Beginers tricks  - 3D references, Transpose, Filled Map, Autofit, how to ad your own picture in a charts (and a lot more)

  • Microsoft Excel features for data analysis and visualization  - Getting  data from web, Advanced filter, Pivot tables, Analysis Tool pack

  • Microsoft Excel features for business, finance and forecast - What if analysis, Scenario manager, Payment (PMT), Goal seek

  • And also a lot of little useful Microsoft Excel tricks, such as - tracking changes, Excel translator, Excel Ideas and how to do VLOOKUP on left side

  • And a lot of SHORTCUTS

__________

We will also will be touching those aspects

  • Microsoft Excel Interface

  • Microsoft Excel basic skills (Autofill, Shortcuts and etc.)

  • Microsoft Excel data skills (Import, finding and replacing text, constant links, linking text)

  • Microsoft Excel Functions and Formulas

  • Formatting skills in Microsoft Excel 

  • Visualisation skills in Microsoft Excel ( Charts, Conditional formatting)

  • Extra skills in Microsoft Excel  ( Smart tables, Pivot tables and other)

  • And more...


Just check a couple of reviews on my "Microsoft Excel tricks ( hacks) (Macbook & Windows) beginner - advanced"

  • Amazing course!! There's so much to do with Excel that i couldnt imagine. Now im able to use it not only better in my work, but also for personal stuffs, even for gaming! Thanks a lot!!!!!


  • Nice lectures.I have learned amazing stuff about excel.


  • IT WAS A GOOD EXPERIENCE FOR ME AND IT HELPED ME IN MANY WAYS.


  • it's very good , i benefit from every minute in this course

    and intructor is be graet

    thank to him


My suggestion to you..

If you really want to understand all features and aspects ( such as formulas and functions, data visualization, data analysis, conditional formatting, charts and etc.)in Excel.... Just try this excellent course...


You could use next Software to learn this course:

Windows:

  • Microsoft Excel 2007

  • Microsoft Excel 2010

  • Microsoft Excel 2013

  • Microsoft Excel 2016

  • Microsoft Excel 2019

  • Microsoft Excel 2020

Macbook:

  • Microsoft Excel 2011

  • Microsoft Excel 2016

And all upper Microsoft Excel version of software

Any Laptop or Smartphone

  • Google Spreadsheets (sheets)



__________

NOTE: 

"Microsoft Excel tricks ( hacks) (Macbook & Windows) beginner - advanced" includes downloadable resources and project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee.

This "Microsoft Excel tricks ( hacks) (Macbook & Windows) beginner - advanced" were created on Microsoft Excel for Macbook 2016

Who this course is for:

  • People who want to start study Excel and have no any experience in it
  • Excel users who have basic skills but want to be BETTER
  • Data analytics, Marketers, Business owners, Investors, Finance specialists, Insurance agents
  • Entrepreneurs, Teachers, office workers,
  • Anyone who works with huge data
  • Students, who want to develop their skills, and make their labor and life more effective
  • Anyone who want to expand their analytics skills, work more efficiently with data
  • Anyone who want to take their career to a new level
  • And you are also :)

Course content

4 sections • 43 lectures • 2h 53m total length

  • Preview02:10

  • 2.1. Advance selecting |Microsoft Excel tricks: MacBook & Windows
    05:10
  • Advance selecting |Microsoft Excel tricks: MacBook & Windows
    1 question
  • 1.2. SUMIFS Formula |Microsoft Excel tricks: MacBook & Windows
    09:43
  • SUMIFS Formula |Microsoft Excel tricks: MacBook & Windows
    1 question
  • 1.3. Several range naming |Microsoft Excel tricks: MacBook & Windows
    04:32
  • Several range naming |Microsoft Excel tricks: MacBook & Windows
    1 question
  • Preview10:16
  • XLOOKUP formula (advanced) |Microsoft Excel tricks: MacBook & Windows
    1 question
  • 1.5. Paste Special Value (advanced) |Microsoft Excel tricks: MacBook & Windows
    05:12
  • Paste Special Value (advanced) |Microsoft Excel tricks: MacBook & Windows
    1 question
  • 1.6. Data Types (pro) |Microsoft Excel tricks: MacBook & Windows
    05:12
  • Data Types (pro) |Microsoft Excel tricks: MacBook & Windows
    1 question
  • 1.7. 3D References (advanced) |Microsoft Excel tricks: MacBook & Windows
    05:06
  • 3D References (advanced) |Microsoft Excel tricks: MacBook & Windows
    1 question
  • 1.8. Import from Web (pro) |Microsoft Excel tricks: MacBook & Windows
    06:40
  • Import from Web (pro) |Microsoft Excel tricks: MacBook & Windows
    1 question
  • 1.9 EXCEL TRANSLATOR (advanced) |Microsoft Excel tricks|MacBook|Windows|Data
    01:49
  • EXCEL TRANSLATOR (advanced) |Microsoft Excel tricks|MacBook|Windows|Data
    1 question
  • 1.10 SHOW FORMULAS(Advanced)Microsoft Excel: Windows, Macbook,Data visualisation
    01:58

  • 2.1 Fast Scrolling |Microsoft Excel tricks: MacBook & Windows
    02:02
  • Fast Scrolling
    1 question
  • 2.2. Status bar |Microsoft Excel tricks: MacBook & Windows
    01:51
  • status bar
    1 question
  • 11. Advanced filter |Microsoft Excel tricks: MacBook & Windows
    07:01
  • Advanced filter | Microsoft Excel
    1 question
  • 2.3 Filter Formula|Microsoft Excel tricks|MacBook|Windows|Data analysis|advanced
    06:46
  • 12 Filter Formula |Microsoft Excel tricks|MacBook|Windows|Data analysis|advanced
    1 question
  • 2.4 Converter (advanced) |Microsoft Excel tricks|MacBook|Windows|Data analysis
    02:31
  • 13 Converter (advanced) |Microsoft Excel tricks|MacBook|Windows|Data analysis
    1 question
  • 2.5 UNIQUE FUNCTION (advanced) |Microsoft Excel tricks|MacBook|Windows|Data
    05:38
  • 2.6 UNIQUE FUNCTION (advanced) |Microsoft Excel tricks|MacBook|Windows|Data
    1 question
  • 2.7 PMT EXCEL FUNCTION (advanced) |Microsoft Excel tricks|MacBook|Windows|Data
    05:30
  • 2.7 PMT EXCEL FUNCTION (advanced) |Microsoft Excel tricks|MacBook|Windows|Data
    1 question
  • 2.8 ADVANCED AUTOFILL (advanced) |Microsoft Excel tricks|MacBook|Windows|Data
    03:43
  • 2.8 ADVANCED AUTOFILL (advanced) |Microsoft Excel tricks|MacBook|Windows|Data
    1 question
  • 2.9 SCENARIO MANAGER (pro) |Microsoft Excel tricks|MacBook|Windows|Data
    07:18
  • 2.9 SCENARIO MANAGER (pro) |Microsoft Excel tricks|MacBook|Windows|Data
    1 question
  • Preview04:36
  • 2.10 GOAL SEEK (pro) |Microsoft Excel tricks|MacBook|Windows|Data
    1 question
  • 2.11 TRACK CHANGES (pro) |Microsoft Excel tricks|MacBook|Windows|Data
    06:19
  • 2.11 TRACK CHANGES (pro) |Microsoft Excel tricks|MacBook|Windows|Data
    1 question
  • 2.12 CHOOSE FUNCTION (pro) |Microsoft Excel tricks|MacBook|Windows|Data
    04:03
  • 2.12 CHOOSE FUNCTION (pro) |Microsoft Excel tricks|MacBook|Windows|Data
    1 question
  • 2.13 LEFT VLOOKUP FUNCTION (pro) |Microsoft Excel tricks|MacBook|Windows|Data
    03:32
  • 2.13 LEFT VLOOKUP FUNCTION (pro) |Microsoft Excel tricks|MacBook|Windows|Data
    1 question
  • 2.14 TRIM & SUBSTITUTE &CODE FUNCTIONS (pro) |Microsoft Exce|MacBook|Windows
    06:35
  • TRIM & SUBSTITUTE &CODE FUNCTIONS (pro) |Microsoft Excel tricks|MacBook|Windows
    1 question
  • 2.15 HOW TO ADD DATA ANALYSIS TOOL (pro) |Microsoft Excel |MacBook|Windows|Data
    02:01
  • HOW TO ADD DATA ANALYSIS TOOL (pro) |Microsoft Excel |MacBook|Windows|Data
    1 question
  • 2.16 RANDOM NUMBERS GENERATOR (pro) |Microsoft Excel |MacBook|Windows|Data
    01:21

  • 3.1 AUTOFITT (Beginner) (Microsoft Excel: MacBook, Windows) Data visualisation
    01:11
  • 3.2 REMOVE DUPLICATES (Beginner)|Microsoft Excel |MacBook|Windows|Data
    03:50
  • REMOVE DUPLICATES (Beginner)|Microsoft Excel |MacBook|Windows|Data
    1 question
  • 3.3 IFERROR FUNCTION (Beginner)|Microsoft Excel |MacBook|Windows|Data
    03:20
  • 3.4 SCREEN CLIPPING|Beginner(Microsoft Excel:MacBook, Windows)Data visualisation
    01:38
  • 3.5 MOVE DATA (Beginner)|Microsoft Excel |MacBook|Windows|Data
    01:34
  • 3.6 REMOVE BLANKS (Beginner)|Microsoft Excel |MacBook|Windows|Data visualisation
    01:43
  • 3.7 FINDING DIFFERENT VALUES (Advanced) Microsoft Excel: MacBook, Windows| Data
    03:20
  • 3.8 TRANSPOSE (Advanced) Microsoft Excel: Windows, Macbook ,Data visualisation
    01:26
  • Preview07:30
  • 3.10 FILLED MAP(Advanced) Microsoft Excel: Windows, Macbook ,Data visualisation
    02:07
  • 3.11 COUNT BLANKS(Advanced)Microsoft Excel: Windows, Macbook ,Data visualisatio
    02:14
  • 3.12 SORT FUNCTION(Advanced)Microsoft Excel Windows, Macbook ,Data visualisation
    01:50
  • 3.13 YOUR OWN PICTURES IN CHARTS (Advanced)Microsoft Excel: Windows, Macbook
    02:09
  • 3.14 IDEAS (Advanced) Microsoft Excel: Windows, Macbook ,Data visualisation
    02:52
  • 3.15 SLICERS (Advanced) Microsoft Excel: Windows, Macbook ,Data visualisation
    03:20
  • Preview05:02

Instructor

Denis Kulikov
Enterpreneur, dancer, teacher, scientist, rapper and IDK
Denis Kulikov
  • 4.2 Instructor Rating
  • 1,133 Reviews
  • 82,870 Students
  • 5 Courses

Hi there! I am so glad you have found our page :)

I am founder of 7 years old group of the companies , also, owner of two dance schools (more then 200 students and more then 20 staff (Since 2011 y.) (Russia and USA); Russian far east child camp.

I have organized more then 100 hip hop events (include the biggest urban festival in last 10 years in far east of Russia (more then 4000 participants)  and three international dance competitions (there was participate seven Russian's cities and five Chine's cities). And now I've  started to share our experience with you my friend.


I was created this account with the only one reason - to share my knowledge.

I believe, that each person on the Earth able to do a business and achieve a financial freedom. We are - people! We are very talented and have a lot of potential. All what we need - it is a couple of advices from specialist. And I hope that I going to be that person, who will give you those advices.


  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.