Master Microsoft Excel, PowerPoint and Word 2013 – 27 Hours

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

The Most Convenient Way to Boost Your Confidence And Learn MS Office 2013 Inside And Out—Quickly, No Travel or Classes.

1 - Excel 2013 Introduction

1 - Introduction to Excel 2013

2 - WATCH ME Essential Information for a Successful Training Experience

3 - DOWNLOAD ME Course Exercise Files.html

3 - SSI-Excel-2013-Exercise-Files-1.zip

4 - Downloadable Course Transcripts.html

4 - Learn-Excel-2013-by-Simon-Sez-IT.pdf

5 - Whats New

2 - Excel 2013 Using Touch

6 - Overview of Principles

3 - Excel 2013 Getting Started

7 - Starting and Closing Excel Workbook Sheets Cells Rows & Columns

8 - Templates Creating Opening and Saving a Workbook

4 - Excel 2013 Help

9 - Course Review

10 - Online Offline and Contextual Help

5 - Excel 2013 Settings and Preferences

11 - Excel Options

6 - Excel 2013 The Ribbon and Toolbars

12 - Ribbon Interface

13 - Quick Access Toolbar

14 - Mini Toolbar

7 - Excel 2013 Backup and Recovery

15 - Create Backup Option AutoRecover and Autosave

8 - Excel 2013 Entering and Deleting Data

16 - Entering Text and Numbers

17 - Date Formats

18 - Formatting Cells Editing and Deleting Data

19 - Fill

20 - Flash Fill

9 - Excel 2013 Formatting a Worksheet

21 - Themes and Cell Styles

22 - Inserting Deleting Hiding and Adjusting Rows and Columns

23 - Wrap Text and Alignment

24 - Merging Cells Applying Themes and Styles

25 - Borders

10 - Excel 2013 Copy Paste and Paste Special

26 - Copy Cut and Paste

11 - Excel 2013 Proofing

27 - Spell checking

12 - Excel 2013 Managing Worksheets

28 - Moving Copying Inserting Deleting and Locking Sheets Multiple Worksheets

13 - Excel 2013 Comments

29 - Inserting Comments

14 - Excel 2013 Viewing and Printing

30 - Workbook Views Zoom and Freeze

31 - Printing Headers Footers and Margins

15 - Excel 2013 Formulas and Functions

32 - Overview of Formulas and Functions

33 - Cell References

34 - Names

35 - Finding Errors New Excel Functions

16 - Excel 2013 Working with Workbooks

36 - Multiple Workbooks and Windows Comparing Workbooks

17 - Excel 2013 Find and Replace

37 - Go to Find and Replace Options

18 - Excel 2013 Conditional Formatting

38 - Applying Clearing and Managing Rules

19 - Excel 2013 Graphing and Charting

39 - Chart Types Chart Recommendation

40 - Basic Formatting

41 - Selecting Data Positioning and Printing Charts

20 - Excel 2013 File Types

42 - Saving Workbooks PDF and CSV Formats

21 - Excel 2013 Managing Data

43 - Sorting

44 - Filtering

45 - Tables

22 - Excel 2013 Functions Case Study

46 - VLOOKUP

47 - Text Function

48 - Date and Time Functions

49 - Logical Functions

23 - Excel 2013 Analyzing Data

50 - Financial Analysis Case Study Part 1

51 - Financial Analysis Case Study Part 2

52 - Quick Analysis Tool

24 - Excel 2013 Shapes and Pictures

53 - Adding and Formatting Shapes Picture Clip Art WordArt and SmartArt

25 - Excel 2013 Sharing and Protecting

54 - Protecting Worksheets

55 - Protecting Workbooks

56 - Sharing and SkyDrive

26 - Excel 2013 More Backstage View Options

57 - Trust Center Export Inspect Workbook

27 - Excel 2013 Closing

58 - Summary More Help

59 - BONUS Lecture Dashboards in Excel Live Webinar Recording

28 - Introduction to PowerPoint 2013

60 - Acquiring PowerPoint 2013

61 - WATCH ME Essential Information for a Successful Training Experience

62 - DOWNLOAD ME Course Exercise Files.html

62 - powerpoint-2013-files.zip

63 - Downloadable Course Transcripts.html

63 - Learn-PowerPoint-2013-by-Simon-Sez-IT.pdf

64 - Whats New in PowerPoint 2013

29 - PowerPoint 2013 Using Touch

65 - Overview of Principles

30 - PowerPoint 2013 Getting Started

66 - PowerPoint Workspace Opening Saving and Exiting

67 - Backstage View Protecting Presentations Editing Properties

31 - PowerPoint 2013 Help

68 - Online and Offline Help

32 - PowerPoint 2013 PowerPoint Options

69 - Customize Settings and Preference

33 - PowerPoint 2013 The Ribbon and Toolbars

70 - The Ribbon

71 - Quick Access Toolbar

72 - Mini Toolbar

73 - Status Bar

34 - PowerPoint 2013 Backup AutoSave and AutoRecover

74 - Backup Files Adjust AutoSave Recover Unsaved Presentation

35 - PowerPoint 2013 Creating a Presentation

75 - New Blank Presentation Slide Size Orientation and Background

76 - Adding Contents Adding and Deleting Slides

36 - PowerPoint 2013 Views

77 - Adjusting View and Adding Notes in Normal View PromoteDemote and ExpandCollap

78 - Moving Slides in Slide Sorter View Notes Page and Reading View

79 - Zoom

37 - PowerPoint 2013 Undo and Redo

80 - Undo and Redo Actions Set Maximum Number of Undos

38 - PowerPoint 2013 Working with Text

81 - Adding and Formatting Text Placeholder Textbox

82 - Manual Textbox Inserting Symbols

39 - PowerPoint 2013 Copy Cut and Paste

83 - Using Clipboard and Mini Toolbar Paste Option

40 - PowerPoint 2013 Spelling and Grammar Checking

84 - AutoCorrect and Proofing

41 - PowerPoint 2013 Masters Themes and Layouts

85 - Templates Slides and Masters

86 - Background Color Themes and Layouts

87 - Header and Footer

42 - PowerPoint 2013 Lists

88 - Bulleted and Numbered Lists

43 - PowerPoint 2013 Paragraph Formatting

89 - Alignment Line Spacing Ruler and Tabs

44 - PowerPoint 2013 Working with Images and Clip Art

90 - Inserting Pictures

91 - Formatting Pictures

92 - Photos and Photo Albums

93 - Clip Art

94 - Screenshots

45 - PowerPoint 2013 Working with Shapes and Drawings

95 - Drawing and Formatting Shapes

96 - Creating Complex Shapes

97 - SmartArt

46 - PowerPoint 2013 Saving a Presentation

98 - Save Options Create PDFXPS Document Change File Type

47 - PowerPoint 2013 Tables

99 - Creating and Formatting Tables

48 - PowerPoint 2013 Charts

100 - Creating Charts using Excel Editing Data Chart Type and Chart Element

49 - PowerPoint 2013 Animation

101 - Basics of Animation

102 - Controlling Animation Motion Path

103 - Animation of SmartArt

50 - PowerPoint 2013 Printing and Page Setup

104 - Printing Slides and Handouts

51 - PowerPoint 2013 Interactivity and Hyperlinks

105 - Linking to a Webpage and a Slide

52 - PowerPoint 2013 Laying out Slides

106 - Aligning Objects Grid and Guides Nudging

53 - PowerPoint 2013 Preparing for a Presentation

107 - Spell check Create Handouts and Videos Inspect Document Hide Slide Custom Sh

108 - Transitions and Timings Setting up and Recording a Slide Show

54 - PowerPoint 2013 Delivering a Presentation

109 - Manual Presentation Presenter View and Tools

55 - PowerPoint 2013 Collaboration

110 - Comments

56 - PowerPoint 2013 Sharing

111 - Saving your Presentation on SkyDrive

112 - PowerPoint Web App Send Email Get a Link

57 - PowerPoint 2013 Online Presentation

113 - Presenting on the Web

58 - PowerPoint 2013 Working with Multimedia

114 - Inserting and Formatting Video Adding Audio

59 - PowerPoint 2013 Conclusion

115 - Protecting your Presentation Trust Center Closing

116 - BONUS Lecture PowerPoint Tips and Tricks Live Webinar Recording

60 - Introduction to Word 2013

117 - Acquiring Word 2013 Information about Installing and Upgrading

118 - WATCH ME Essential Information for a Successful Training Experience

119 - DOWNLOAD ME Course Exercise Files.html

119 - word-2013-files.zip

120 - Downloadable Course Transcripts.html

120 - Learn-Word-2013-by-Simon-Sez-IT.pdf

121 - Whats New

61 - Word 2013 Using Touch

122 - Overview of Principles

62 - Word 2013 Getting Started

123 - Starting and Exiting Templates Creating Opening and Saving Documents

124 - Word Workspace Backstage View

63 - Word 2013 Help

125 - Online and Offiline Help

64 - Word 2013 Word Options

126 - Settings and Preferences

65 - Word 2013 The Ribbon and Toolbars

127 - The Ribbon

128 - Quick Access Toolbar

129 - Mini ToolbarBar

66 - Word 2013 Backup AutoSave and AutoRecover

130 - Setting Up AutoSave and AutoRecover Preferences

67 - Word 2013 Entering and Editing Data

131 - Typing Editing and Deleting Text Customizing Status Bar

132 - Navigation Word Wrapping Making a Selection

133 - Inserting Symbols Date and Time and Document Property

68 - Word 2013 Copy Cut and Paste

134 - Various Methods of Copying Cutting and Pasting

69 - Word 2013 Navigation and Find

135 - Uses of Navigation Pane

136 - Find and Replace Go to

70 - Word 2013 Keyboard Shortcuts

137 - Keyboard Shortcuts and Key Tips

71 - Word 2013 Views

138 - Print Layout Web Layout and Draft Views Ruler and Gridlines Split and Switch

139 - Zoom

140 - Read Mode

72 - Word 2013 Spell Checker

141 - Spelling and Grammar Errors Language Settings

142 - AutoCorrect Proofing Settings Spell Checking

73 - Word 2013 Formatting

143 - Fonts Font Size and Font Colors Text Effect and Text Highlight

144 - Alignment Line and Paragraph Spacing Indent

145 - FillShading Border Tab Format Painter

74 - Word 2013 Lists

146 - Bulleted Numbered and Multilevel Lists

75 - Word 2013 Managing Document

147 - File Formats

76 - Word 2013 Page Setup and Printng

148 - Printing

149 - Page Layout Sections and Margins

150 - Headers Footers and Page Numbers

77 - Word 2013 Templates Themes and Styles

151 - Using Templates

152 - Using Themes and Styles

78 - Word 2013 PDF in Word

153 - Opening and Editing PDFs

79 - Word 2013 Tables

154 - Creating a Table Inserting Selecting and Deleting Rows and Columns

155 - Formatting Tables

80 - Word 2013 Graphics

156 - Inserting Cropping Resizing and Positioning Pictures

157 - Picture Styles Picture Adjustments Corrections and Effects

158 - Online Pictures and Clipart

159 - Inserting and Formatting Shapes and Textbox

160 - Smart Art and WordArt

161 - Screenshots

81 - Word 2013 Charts

162 - Creating Charts

82 - Word 2013 Resume

163 - Resume Reading and Editing

83 - Word 2013 Read Mode

164 - Object Zoom

84 - Word 2013 Mail Merge

165 - Mail Merge Wizard Part 1

166 - Mail Merge Wizard Part 2

85 - Word 2013 Collaboration Reviewing and Sharing

167 - Send to Email Post to Blog SkyDrive Invite People

168 - Restrict Editing Comments Simple Markup and Tracking Changes

86 - Word 2013 Long Documents

169 - Navigation Headings Table of Contents Update Page numbers and Outline View

87 - Word 2013 Desktop Publishing

170 - Watermarks

171 - Page Borders

88 - Word 2013 Hyperlinks

172 - Types of Hyperlinks

89 - Word 2013 Security

173 - Inspecting and Protecting Documents

90 - Word 2013 Conclusion

174 - Microsoft Update Closing

175 - BONUS Lecture Advanced Word Live Webinar Recording

139,000 تومان

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

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

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

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