Google Sheets Masterclass: The Power of Excel and Analysis

سرفصل های دوره

Unleash the Power of Google Sheets: Master Data Analysis, Visualization, and Collaboration

1 - Getting started

1 - Introduction

2 - Getting started on Windows macOS Android and IOS

3 - How to ask great questions

4 - FAQs

2 - Google Sheets Basic

5 - Sheets Basics to start

6 - Cells Rows and Columns

7 - Productivity Tips and File Sharing

8 - Menu and Toolbar options

9 - Save and print in Sheets

10 - Language and Spreadsheet settings

11 - Version recovery and edit History

3 - Data Types and Formulas

12 - Data Types

13 - Data Entry

14 - Autofill in sheets

15 - Data handling basics copy cut and paste

16 - Common functionalities in sheets

17 - Regular Functions in Google Sheets sum average counta and countunique

18 - Relative Vs Absolute referencing

4 - Data Formatting and Useful tools

19 - Useful tools and Report design

20 - Split Text into columns

21 - Conditional formatting

22 - Create Dropdown lists from data

23 - Data Validations

24 - Importing TXT data files into Google Sheets

25 - Importing CSV data files into Google Sheets

26 - Getting Data from Other Google Sheets

5 - Reports Filtering Sorting and Cleaning Data

27 - Sort Features

28 - Filter and Filter view in Sheets

29 - Filtered ResultsSubTotal

30 - Remove Duplicates

31 - Trim White Spaces

32 - Find and Replace Data

6 - Google Sheets Essential Functions to Analyze Data

33 - Unique and Sort Functions

34 - SUMIFS applying on COUNTMIN MAX

35 - Logical Functions

36 - IF Function IF Then

37 - Nested IF and IFS Functions

38 - Named Ranges

39 - Rounding Values

7 - Google Sheets Lookup Functions

40 - VLOOKUP Function

41 - HLOOKUP Function

42 - HLOOKUP Match formula

8 - XLOOKUP and NA

43 - XLOOKUP Function

44 - Handling NA and Approximates match in XLOOKUP

9 - Text Date and Time Functions

45 - Basic Text Functions

46 - Split and Join Data from multiple columns

47 - Search and SUBSTITUTE

48 - Date Time Functions

49 - Time Calculationsworked hours

10 - Collaborate Publish and Protect

50 - Collaboration and Sharing files

51 - Publishing Sheet or chart to Link in a web page

52 - Publishing Sheet or chart to Embedding in a web page

53 - Email Google Sheets or chart

54 - Prepare for Print or PDF with page breaks

55 - Protect a sheet or range

56 - Use Google Forms to collect realtime data

57 - Exercise and Solution for PDF layout

11 - Google Sheets Charts

58 - Chart Basics Column and Line Charts

59 - Aggregating Data in Charts Bar and Pie Charts

60 - Combo charts

61 - Gauge chart

62 - Table chart

63 - Scorecard chart for KPI Dashboards

64 - Adding Slicers to charts

65 - Sparklines chart

66 - Sparklines for Stock and Currency

67 - Geo charts

12 - Pivot Tables in Google Sheets

68 - Explore Pivot Features in Google Sheets

69 - Pivot Table Basics in Google Sheets

70 - Use Filters and Slicers for Dynamic Pivot Tables

71 - Grouping items and datesMonthYear

72 - Custom Formulas in Pivot Tables

13 - Advanced Google Sheets Functions and Formulas

73 - INDEX MATCH for complex lookups

74 - ARRAYFORMULA function

75 - Create your own Arrays and Make totals

76 - INDIRECT Function Lookup

77 - Create Random Data and Text

78 - SEQUENCE Function

14 - The QUERY Functions

79 - QUERY Function Basics

80 - QUERY Function using Select and Where

81 - QUERY Function for Aggregation

82 - Group By Multiple Columns

83 - Transform Distinct Values using PivotQuery Function

84 - Aggregates and Sorting using Order by clause

85 - QUERY Function for Dynamic Totals

86 - QUERY Function to Combine Data from Multiple Sheets

87 - QUERY Function with IMPORTRANGE to Combine External Sheets

15 - Google Sheets Import Data from Web

88 - Import Tables from the WebIMPORTHTML

89 - Import any structured data from WebIMPORTXML

16 - Google Sheets QR Code and Images

90 - Insert Image on Google Sheets

91 - Generate QR Code on Required data

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training