Excel Essentials - Boost Your Efficiency And Save Time

Learn Advanced Excel Techniques - Data Analysis and Reporting Made Easy

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