Microsoft Excel 2023: Advanced Excel Formulas and Shortcuts

Focused View

SiemHunters Academy

4:59:21

163 View

1. MS Excel 2023 Introduction.mp4

03:09

2. FEATURES OF MS EXCEL.mp4

02:29

3. Linking Workbooks.mp4

08:42

4. Working with Shortcuts.mp4

05:07

5. Working with Sorting and Filtering.mp4

05:45

6. Working with range names.mp4

06:23

7. Sub Totals.mp4

05:53

8. Create a table.mp4

08:45

9. Formatting a table.mp4

08:14

10. Working with Sort and filter by names and color.mp4

04:43

11. Filter with slicers.mp4

07:49

12. Working with Calculate with table.mp4

10:06

13. Removing errors.mp4

08:07

14. Working with Export and refresh converting tables.mp4

05:47

15. Conditional formatting.mp4

06:53

16. Highlighting cells top and bottom.mp4

11:20

17. Database, icons sets, color scaler.mp4

08:08

18. Using custom fonts and colors.mp4

07:02

19. Using Conditional formatting.mp4

07:31

20. Modifying or removing conditional formatting.mp4

06:12

21. Working with Creating charts.mp4

07:41

22. Understand the chart elements.mp4

07:21

23. Modifying chart elements.mp4

09:06

24. Changing and moving charts.mp4

06:08

25. Formatting charts.mp4

07:17

26. Adjusting numbering.mp4

06:03

27. Creating dual axis chart with example.mp4

06:45

28. Forecasting with trend lines.mp4

08:02

29. Creating chart templates.mp4

06:49

30. Displaying trends with sparkling tools.mp4

08:44

31. Wrap Text.mp4

03:18

32. What is pivot table.mp4

05:17

33. Pivot table field panes.mp4

07:52

34. Data organisation and analysis with pivot table.mp4

08:29

35. Formatting pivot chart.mp4

11:55

36. Creating pivot charts.mp4

09:26

37. Slicers.mp4

05:10

38. Formatting slicers.mp4

08:37

39. Pivot Chart wizard.mp4

06:15

40. Adding a calculated field.mp4

06:17

41. Creating filter pages for a pivot.mp4

06:51

42. Working with Power pivot.mp4

07:53

Description

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

Who is this for?

Data analyst

Data entry

Data experts

What You Need to Know?

no prior experience, you will learn from basic to advanced

latest pivotings, charts, and data organisation

More details

Description
Learn learn Microsoft Excel easily and quickly Microsoft excel 2023
You'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 workbooks
you'll learn Consolidate feature
working with Shortcuts
sort nd filter
working with range names
Sub totals
Create a table
Formatting a table
Sot and filter by names and color
Filter with slicers
Calculate with table
Removing errors
Export, refresh converting tables
Conditional formatting
Highlighying cells top and bottom
Database, icons sets, color scaler
Using custom fonts and colors
Using conditional formatting
Modifying or removing conditional formatting
Creating charts
Understand the chart elements
Modifying chart elements
Changing and moving charts
Formatting charts
Adjusting numbering
Cretinv dual axis chart
Forecasting with trend lines
Creating chart templates
Displying trends with sparkling tools
What is pivot table
Creating pivot table
Pivot table field plane
Data organisation and analysis with pivot table
Formatting pivot chart
Creating pivot charts
Slicers
Formatting slicers
Chart wizard
Adding a calculated field
Creating filter pages for a pivot
Power pivot add in

Who this course is for:
Data analyst
Data entry
Data experts

User Reviews

Rating

average 0

Total votes0

Focused display

We are SiemHunters leading cyber security and SOC training and certification provider, we are specialized in SOC/SIEM trainings along with real-time lab scenarios and enterprise based learning. We have 14+ Certified Enterprise instructor team to deliver cyber courses with latest tactics and techniques. We are authorized Eccouncil and Comptia ATC in hyderabad.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.