Excel in Microsoft Excel 1: beginner to Excel intermediate

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

Get certified! Levels 1-5 for Microsoft Excel 2007, Excel 2010, Excel 2013 and Excel 2016. Covers 77-727 and 77-420.

1 - Welcome

1 - Introduction

2 - Welcome to Udemy.html

3 - Introduction to Udemy

4 - Do you want autotranslated subtitles in more languages.html

5 - Curriculum

2 - Level 1 Section 1 An introduction to Excel

6 - Creating new blank workbooks

7 - Entering data

8 - An introduction to fonts and highlighting

9 - Saving and closing your workbook

10 - Practice Activity Number 1.html

11 - Practice Activity Number 1 The Solution

3 - Level 1 Section 2 Create worksheets and workbooks

12 - Creating new workbooks using templates

13 - Menus and toolbars

14 - Managing multiple workbooks Excel 2013 and 2016

15 - Managing multiple workbooks Excel 2007 and 2010

16 - Importing files and Opening nonnative files directly in Excel

17 - Adding worksheets to existing workbooks

18 - Copying and moving worksheets and changing spreadsheet order

4 - Level 1 Section 3 Configure worksheets and workbooks to save

19 - Saving workbooks in alternate file formats

20 - Maintaining backward compatibility

21 - Saving files to remote locations

5 - Level 1 Section 4 Basic formulas

22 - Using basic operators

23 - Order of operations

24 - How to enter numbers and dates in Excel

25 - Level-1-Session-4.161228.xlsx

25 - Referencing cell ranges in formulas

26 - Solution to the above exercise.html

27 - Practice Activity Number 2.html

27 - musiclist.zip

28 - Practice Activity Number 2 Solution

6 - Level 2 Section 1 Navigate through Excel worksheets and workbooks

29 - Level-2-Session-1-Start.xlsx

29 - Searching for data within a workbook

30 - Hyperlinks

31 - Using Go To and Using Name Box

32 - Hot Keys

7 - Level 2 Section 2 Format worksheets and workbooks

33 - Changing worksheet tab colour

33 - Level-2-Session-2-Start.xlsx

34 - Inserting and deleting columns and rows

35 - Undo and Redo

36 - File Management tips

37 - Adjusting row height and column width

38 - Hiding columns and rows

39 - Selecting multiple ranges

40 - Practice Activity Number 3.html

40 - Practice-File-0202.xlsx

8 - Level 2 Section 3 Customise options and views for worksheets and workbooks

41 - Hiding worksheets

41 - Level-2-Session-3-Start.xlsx

42 - Customising the Quick Access toolbar

43 - Customising the Ribbon

44 - Assigning shortcut keys

45 - Recording simple macros

46 - Managing macro security

47 - Changing workbook views

48 - Using zoom

49 - Adding values to workbook properties

50 - Displaying formulas

51 - Freezing panes

52 - Splitting the window

53 - Practice Activity Number 4.html

53 - Practice-File-0203.xlsx

9 - Level 2 Section 4 Configure Excel worksheets and workbooks to print

54 - Level-2-Session-4-Start.xlsx

54 - Printing individual worksheets

55 - Printing an entire workbook and printing a selection

56 - Setting a print area

57 - Page setup Part 1 first two tabs

58 - Page setup Part 2 Repeating headers and footers

59 - Adding dynamic text to headers and footers

60 - Inserting watermarks

61 - Page setup Part 3 Headings etc

62 - Configuring workbooks to print

63 - Inspecting your workbook prior to distribution

64 - Practice Activity Number 5.html

64 - Practice-File-0204.xlsx

10 - Level 2 Section 5 Utilise cell ranges and references in formulas and functions

65 - Copying and pasting basics and Utilising references relative mixed absolute

65 - Level-2-Session-5-Start.xlsx

66 - Practice Activity multiplication table

67 - Answer multiplication table

11 - Level 3 Section 1 Insert data in cells and ranges

68 - Appending data to Excel worksheets

68 - Level-2-Session-5-End.xlsx

68 - Level-3-Session-1-Start.xlsx

69 - Setting data validation

70 - Finding and replacing data

71 - Copying and pasting data including Paste Special

72 - Cutting and moving cell data

73 - Using AutoFill tool and Expanding data across columns

74 - Practice Activity Number 6.html

74 - Practice-File-0301.xlsx

12 - Level 3 Section 2 Format cells and ranges

75 - Level-3-Session-2-Start.xlsx

75 - Modifying cell alignment and indentation

76 - Wrapping text within cells

77 - Merging cells and Shrink to Fit

78 - Changing font and font styles

79 - Applying highlighting

80 - Applying Number format

81 - Applying borders

82 - Applying cell styles

83 - Using Format Painter

84 - Changing text to WordArt

85 - Practice Activity Number 7.html

85 - Practice-File-0302.xlsx

13 - Level 3 Section 3 Highlight and filter cells and ranges in Excel

86 - Applying conditional formatting highlighting

86 - Level-3-Session-3-Start.xlsx

87 - Applying conditional formatting Bars Scales and Sets

88 - Transposing columns and rows and s

89 - Inserting sparklines and how to define a range

90 - Customising Sparklines

91 - Practice Activity Number 8.html

91 - Practice-File-0303.xlsx

14 - Level 3 Section 4 Summarise data with Excel functions

92 - Doing calculations without formulas

92 - Level-3-Session-4-Start.xlsx

93 - Utilising the SUM function

94 - Formula syntax SUM function

95 - Utilising the COUNT function

96 - Utilising the AVERAGE and other averaging functions

97 - Utilising the MIN and MAX functions

98 - Creating named ranges

99 - Getting help with functions

100 - Practice Activity Number 9.html

100 - Practice-File-0304.xlsx

15 - Level 4 Section 1 Create a table

101 - Level-4-Session-1-Start.xlsx

101 - Moving between tables and ranges

102 - Adding and removing cells within tables

103 - Formulas in tables

104 - Defining titles

16 - Level 4 Section 2 Modify a table

105 - Inserting total rows

106 - Adding and removing styles and Banding rows and columns

107 - Practice Activity Number 10.html

107 - Practice-File-0402.xlsx

17 - Level 4 Section 3 Filtering Sorting and Grouping

108 - Level-4-Session-3-Start.xlsx

108 - Setting up a filter and Filtering records

109 - More advanced filtering options

110 - Using sort options

111 - Sorting data on multiple columns changing sort order

112 - Removing duplicates

113 - Inserting subtotals

114 - Creating outlines collapsing groups of data in outlines

115 - Utilising the SUBTOTAL function

116 - Practice Activity Number 11.html

116 - Practice-File-0403.xlsx

18 - Level 4 Section 4 Utilise conditional logic in functions

117 - Level-4-Session-4-Start.xlsx

117 - Utilising the IF function

118 - Utilising the SUMIF function

119 - Utilising the COUNTIF function

120 - Utilising the AVERAGEIF function

121 - Nested IFs and Evaluate Formulas

122 - The CHOOSE function

123 - Practice Activity Number 12.html

123 - Practice-File-0404.xlsx

19 - Level 5 Section 1 Create a chart in Excel

124 - Creating charts and graphs

124 - Level-5-Session-1-Start.xlsx

125 - Adding and removing additional data series

126 - Exploring the Column charts

127 - Line bar and area charts

128 - Pie charts

129 - Other graph types

130 - Switching between rows and columns in source data

20 - Level 5 Section 2 Format a chart in Excel

131 - Adding legends

131 - Level-5-Session-2-Start.xlsx

132 - Positioning and Resizing charts and graphs inc moving charts into chart sheets

133 - Modifying chart and graph parameters Excel 2007 and 2010

134 - Modifying chart and graph parameters Excel 2013 and 2016

135 - Applying chart layouts and styles

21 - Level 5 Section 3 Insert and format an object

136 - Inserting text boxes and positioning objects

136 - Level-5-Session-3-Start.xlsx

137 - Inserting SmartArt

138 - Inserting ClipArt and images

139 - Inserting Screenshots

140 - Adding borders to objects

141 - Inserting shapes

142 - Adding styles and effects to objects

143 - Changing workbook themes

144 - Modifying object properties including adding alternate text

22 - Level 5 Section 4 create and modify images by using the Image Editor

145 - Level-5-Session-4-Start.xlsx

145 - Making corrections to an image

146 - Using picture colour tools

147 - Send to front and back and transparent colour

148 - Changing artistic effects on an image

149 - Crop picture

23 - Level 5 Section 5 Format and modify text with functions

150 - Level-5-Session-5-Start.xlsx

150 - Utilising the CONCATENATE function

151 - Utilising the RIGHT LEFT and MID functions

152 - Utilising the TRIM function

153 - Utilising the UPPER and LOWER functions

24 - Bonus Section

154 - Welcome to the Bonus section.html

155 - Pivot Tables

156 - Graph and PivotCharts

157 - Sparklines

158 - VLOOKUP function

159 - OFFSET function

160 - INDIRECT function

161 - ExcelFree.xlsx

161 - Practice Activity Number 13.html

162 - ExcelFreePA2.xlsx

162 - Practice Activity Number 14.html

25 - Level 5 Conclusion

163 - Thank you for watching

164 - Bonus Lecture

164 - idodatabonuslecture230113.zip

45,900 تومان

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

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

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

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