Published 5/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.46 GB | Duration: 4h 3m
Learn Advanced Excel Techniques - Data Analysis and Reporting Made Easy
Free Download What you'll learn
Cell formatting
Working with sheets
Functions - structure & most used
Graphs
Analysis
Pivot table & pivot graph
Ordering, Filtering, Advanced filter
Subtotals
Scenario, Data table, Sum of the scenario
Verification & Control
Import
Macro - record and use
Requirements
No programming experience needed
Description
Welcome to our course, Excel Essentials! Whether you're a beginner or an experienced user, this comprehensive course is designed to take your Excel skills to the next level. Boost your efficiency and save time. Learn Advanced Excel Techniques: Analyze, Visualize, and Automate.With a large amount of short video lectures, the course covers everything you need to know to become an Excel expert. You'll learn how to create and format spreadsheets, analyze data using powerful functions and formulas, visualize data with charts and graphs, and much more.Videos are short on purpose so that you can easily skip the part that you already mastered in other to save your time during your learning journey with us.Throughout the course, you'll have access to practical examples and real-world scenarios to help you apply what you've learned. You'll also receive step-by-step guidance and detailed explanations, making even the most complex Excel tasks easy to understand.By the end of the course, you'll be equipped with the tools and knowledge you need to streamline your work, save time, and achieve your goals. Whether you're using Excel for work or personal projects, this course will give you the skills and confidence to succeed.So what are you waiting for? Enroll in today and start your journey towards Excel mastery!
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Info
Section 2: Starting
Lecture 3 Adding & highlighting
Lecture 4 Mass insertion
Lecture 5 Adding cols, rows, & freezing
Lecture 6 Basic formatting
Lecture 7 Basic functions
Lecture 8 Own formulas with relative addressing
Lecture 9 Absolute Addressing
Lecture 10 Text orientation
Lecture 11 Simple graph
Lecture 12 Page formatting
Lecture 13 Repeat header when printing
Lecture 14 Conditional formatting
Lecture 15 Split & hide
Section 3: Functions
Lecture 16 Dates
Lecture 17 Math - Rounding
Lecture 18 Statistic - count if blank
Lecture 19 Ranking
Lecture 20 Text
Lecture 21 Finance
Lecture 22 Finance 2
Lecture 23 Finance 3 - Monthly payment & Interest
Lecture 24 Lookup
Lecture 25 Database
Lecture 26 Logical
Lecture 27 Logical statement
Lecture 28 Nested
Lecture 29 Calculate between sheets
Section 4: Analysis
Lecture 30 Graph type formatting
Lecture 31 Pivot table
Lecture 32 Pivot chart
Lecture 33 Data table
Lecture 34 Advanced sorting
Lecture 35 Subtotals
Lecture 36 Scenarios
Section 5: Increase Productivity
Lecture 37 Data validation
Lecture 38 Error checking & comment
Lecture 39 Naming cells
Lecture 40 Paste special
Lecture 41 Import
Lecture 42 Macro - Create/Record & Use
Lecture 43 Sharing & adding password
Lecture 44 Password required to edit
Section 6: Files & tricks
Lecture 45 First Excel Workbook
Lecture 46 Excel Workbook to calculate between more sheets
Lecture 47 Third - MySample
Lecture 48 Text file - To convert
Manager,Business Analysts,Financial Analysts,Accountants,Human Resources Professionals,Anyone who wants to boost their skills in Excel
Homepage
https://www.udemy.com/course/excel-essentials-boost-your-efficiency/
Buy Premium From My Links To Get Resumable Support,Max Speed & Support Me
Links are Interchangeable - Single Extraction
Comments
