Microsoft Excel 2023 - From Beginner To Expert In 5 Hours

From Beginner to Expert - 2023 with latest techniques and pivoting tables | Microsoft Certified Master Instructor

What you'll learn

You'll learn Microsoft Excel 2023 from beginner to advance

Learn Linking workbooks & Shortcuts

using advanced sorting and filtering

Working with range names and sub totals

Creating table, formatting tables, and calculating the table

Conditional formatting, databases, icon sets, and color scalers

Modifying or removing conditional formatting

Working with charts, elements, formatting charts and dual axis charts

creating pivoting tables, Data analysis, and formatting

Slicers, Formatting slicers, chart wizard, and power pivot add-on

Requirements

no prior experience, you will learn from basic to advanced

latest pivotings, charts, and data organisation

Description

Learn learn Microsoft Excel easily and quickly Microsoft excel 2023You'll Learn everything you need to know about Microsoft Excel 2023. From the basic fundamentals, to the most advanced features and data organizations using pivoting and charts. This course designed by a Microsoft Certified Master Instructor & industrial expert in cyber security reports with excel. You'll learn microsoft excel 2023 with latest techniques, tactics, and pivoting. Course Outline: Working with Linking workbooksyou'll learn Consolidate featureworking with Shortcutssort nd filterworking with range namesSub totalsCreate a tableFormatting a tableSot and filter by names and colorFilter with slicersCalculate with tableRemoving errorsExport, refresh converting tablesConditional formattingHighlighying cells top and bottomDatabase, icons sets, color scalerUsing custom fonts and colorsUsing conditional formattingModifying or removing conditional formattingCreating chartsUnderstand the chart elementsModifying chart elementsChanging and moving chartsFormatting chartsAdjusting numberingCretinv dual axis chartForecasting with trend linesCreating chart templatesDisplying trends with sparkling toolsWhat is pivot tableCreating pivot tablePivot table field planeData organisation and analysis with pivot tableFormatting pivot chartCreating pivot chartsSlicersFormatting slicersChart wizardAdding a calculated fieldCreating filter pages for a pivotPower pivot add in

Overview

Section 1: Introduction

Lecture 1 MS Excel 2023 Introduction

Lecture 2 FEATURES OF MS EXCEL

Lecture 3 Linking Workbooks

Lecture 4 Working with Shortcuts

Lecture 5 Working with Sorting and Filtering

Lecture 6 Working with range names

Lecture 7 Sub Totals

Lecture 8 Create a table

Lecture 9 Formatting a table

Lecture 10 Working with Sort and filter by names and color

Lecture 11 Filter with slicers

Lecture 12 Working with Calculate with table

Lecture 13 Removing errors

Lecture 14 Working with Export and refresh converting tables

Lecture 15 Conditional formatting

Lecture 16 Highlighting cells top and bottom

Lecture 17 Database, icons sets, color scaler

Lecture 18 Using custom fonts and colors

Lecture 19 Using Conditional formatting

Lecture 20 Modifying or removing conditional formatting

Lecture 21 Working with Creating charts

Lecture 22 Understand the chart elements

Lecture 23 Modifying chart elements

Lecture 24 Changing and moving charts

Lecture 25 Formatting charts

Lecture 26 Adjusting numbering

Lecture 27 Creating dual axis chart with example

Lecture 28 Forecasting with trend lines

Lecture 29 Creating chart templates

Lecture 30 Displaying trends with sparkling tools

Lecture 31 Wrap Text

Lecture 32 What is pivot table

Lecture 33 Pivot table field panes

Lecture 34 Data organisation and analysis with pivot table

Lecture 35 Formatting pivot chart

Lecture 36 Creating pivot charts

Lecture 37 Slicers

Lecture 38 Formatting slicers

Lecture 39 Pivot Chart wizard

Lecture 40 Adding a calculated field

Lecture 41 Creating filter pages for a pivot

Lecture 42 Working with Power pivot

Data analyst,Data entry,Data experts