Excel - Microsoft Excel Course Beginner To Expert 2022
Published 7/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.93 GB | Duration: 4h 18m

Learn the Essentials of Excel with Filtering, Sorting, Charts, Import & Export, Pivot Tables, Micro, Functions & Formula
What you'll learn
How to properly use Excel
Excel From Beginner to Advanced course
Make your work faster, better and more efficient
How to create basic and advanced formulas
Creating Charts from your data
Most Frequently Used Excel Functions With Examples
How to land your first job as an Excel Expert
How to use Macros
PivotTable Made Easy
Advanced Pivot Table Techniques
Improve your Microsoft Excel Skills
Requirements
There is no need for any knowledge or experience on Microsoft Excel.
A laptop or smartphone with Internet access
Experience with Microsoft Excel is beneficial but not required.
Description
Microsoft Excel Version 2021In this project you will be able to make your own calculation excel sheet. Here attached some Resource file for your practice. share your work with me so we can be able to discuss it and review it together.This Course includes:IntroductionWhat is Microsoft ExcelWhere Excel Is UsedMicrosoft Excel MarketplaceMicrosoft Excel FundamentalsMicrosoft Excel Startup ScreenCreating & Save Document in ExcelFont Styles and SizeData Handling Basics - Cut, Copy and PasteText Wrapping and AlignmentDates and Times FormatsNumbers FormatFind and ReplaceWorking With Rows and Columns (Column & Row Cells Insert, Delete, Hide, Unhide, Merge)Freezing Rows and ColumnsWorking With Multiple WorksheetsSaving and PrintingRelative, Absolute, & Mixed Cell ReferencesRibbon & Quick Access ToolbarCell Borders and MergingAllow Text/Numbers Only in ExcelProtect Ranges & Worksheets in ExcelSave Multiple Excel Sheets in one PDF FileFiltering and Sorting DataBasic FilteringAdvanced FilteringData Sorting in ExcelCreating Charts In ExcelCreating ChartsCreate A Bar In Bar Chart In ExcelProgress Circle Chart in ExcelCreate Pie ChartCreate Line ChartCreate Column ChartFormat Charts in ExcelArea Chart in ExcelWaterfall Charts in ExcelCombination Charts In ExcelMulti-Color Scatter Plot Chart in ExcelImport and Export DataData from Text FilesImport Data from Web to ExcelTranspose Data in ExcelParse Data in Excel Using Various FunctionsExporting Data to Text FilePivot TablesCreate a Pivot TablePivot Tables FilteringPivot Table SlicePivot Table GroupingAdvanced Pivot Table TechniquesMicroCreate Macros in ExcelEdit a Macro in ExcelCreate Macro Buttons in ExcelEssential Excel Functions & FormulasIF FormulaAND FormulaOR FormulaSUM, SUMIF, SUMIFS FunctionsPERCENTAGE FunctionsTODAY FunctionNOW FunctionsCHOOSE FunctionAVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS FunctionsMATCH FormulaROUND, ROUNDUP, ROUNDDOWN FormulasCOUNT, COUNTBLANK, COUNTIF, COUNTIFS FormulasUPPER, LOWER FormulasDependent DROP DOWN ListDynamic DROP DOWN ListDROP DOWN List & FilteringVLOOKUP with Exact MatchVLOOKUP with TrimVLOOKUP Approximate MatchVLOOKUP with MATCH FunctionHLOOKUP FormulaHLOOKUP with MATCH FunctionI am sure you can do it! all you have to do is follow the lessons step-by-step!Feel free to share any problem you are facing and i will be here to review it.To achieve everything mentioned in this piece of advice, please enroll in this course now!Note: Lectures are updated promptly following any modifications in Microsoft Excel.
Overview
Section 1: Introduction
Lecture 1 What Is Microsoft Excel
Lecture 2 Where Excel Is Used
Lecture 3 Microsoft Excel Marketplace
Section 2: Microsoft Excel Fundamentals
Lecture 4 Microsoft Excel Startup Screen
Lecture 5 Create & Save Document in Excel
Lecture 6 Font Styles and Size
Lecture 7 Cut, Copy and Paste In Excel
Lecture 8 Text Wrapping and Alignment
Lecture 9 Dates and Times Formats
Lecture 10 Numbers Format
Lecture 11 Find and Replace
Lecture 12 Working With Rows and Columns
Lecture 13 Freezing Rows and Columns
Lecture 14 Working With Multiple Worksheets
Lecture 15 Saving and Printing
Lecture 16 Relative, Absolute, & Mixed Cell References
Lecture 17 Ribbon & Quick Access Toolbar
Lecture 18 Cell Borders and Merging
Lecture 19 Allow Text/Numbers Only in Excel
Lecture 20 Protect Ranges & Worksheets in Excel
Lecture 21 Save Multiple Excel Sheets in one PDF File
Section 3: Filtering and Sorting Data
Lecture 22 Basic Filtering
Lecture 23 Advanced Filtering
Lecture 24 Data Sorting in Excel
Section 4: Create Charts In Excel
Lecture 25 Creating Charts In Excel
Lecture 26 Create A Bar In Bar Chart In Excel
Lecture 27 Progress Circle Chart in Excel
Lecture 28 Create Pie Chart In Excel
Lecture 29 Create Line Chart In Excel
Lecture 30 Create Column Chart In Excel
Lecture 31 Format Charts In Excel
Lecture 32 Area Chart In Excel
Lecture 33 Waterfall Charts in Excel
Lecture 34 Combination Charts In Excel
Lecture 35 Multi-Color Scatter Plot Chart in Excel
Section 5: Import and Export Data
Lecture 36 Data from Text Files
Lecture 37 Import Data from Web to Excel
Lecture 38 Transpose Data in Excel
Lecture 39 Parse Data in Excel Using Various Functions
Lecture 40 Exporting Data to Text File
Section 6: Pivot Tables In Excel
Lecture 41 Create a Pivot Table
Lecture 42 Pivot Tables Filtering
Lecture 43 Pivot Table Slice
Lecture 44 Pivot Table Grouping
Lecture 45 Advanced Pivot Table Techniques
Section 7: Micro In Excel
Lecture 46 Create Macros in Excel
Lecture 47 Edit a Macro in Excel
Lecture 48 Create Macro Buttons in Excel
Section 8: Essential Excel Functions & Formulas
Lecture 49 IF Formula
Lecture 50 AND Formula
Lecture 51 OR Formula
Lecture 52 SUM, SUMIF, SUMIFS Functions
Lecture 53 TODAY Function
Lecture 54 NOW Function
Lecture 55 CHOOSE Function
Lecture 56 AVERAGE Formula
Lecture 57 MATCH Formula
Lecture 58 ROUND, ROUNDUP, ROUNDDOWN Formulas
Lecture 59 COUNT, COUNTBLANK, COUNTIF, COUNTIFS Formulas
Lecture 60 UPPER, LOWER Formulas
Anyone can do to develop their career in Microsoft Excel.
Screenshots