The Complete Excel Guide Beginners to Advanced

Focused View

15:33:52

22 View

01.01-introduction to excel.mp4

01:00

01.02-whats new in excel 2019.mp4

07:52

01.03-course overview.mp4

01:16

01.04-overview of the excel window.mp4

08:25

01.05-mouse features.mp4

03:12

01.06-backstage view.mp4

02:37

02.01-entering text and numbers.mp4

04:32

02.02-creating basic formulas.mp4

06:49

02.03-relative references.mp4

03:01

02.04-order of operations.mp4

04:48

02.05-working with ranges.mp4

04:14

02.06-module 2-practice exercise.mp4

01:35

03.01-working with the save and save as commands.mp4

04:34

03.02-file extensions share export and publish files.mp4

03:44

03.03-module 3-practice exercise.mp4

00:59

04.01-opening a file.mp4

05:33

04.02-working with larger files.mp4

05:34

04.03-freeze panes option.mp4

03:16

04.04-split screen option.mp4

03:22

04.05-module 4-practice exercise.mp4

02:50

05.01-headers and footers.mp4

07:23

05.02-print titles.mp4

02:52

05.03-comments.mp4

05:23

05.04-page setup options.mp4

07:30

05.05-fit to print on one page.mp4

03:59

05.06-printing workbooks.mp4

03:55

05.07-module 5-practice exercise.mp4

01:53

06.01-adding and deleting rows columns and cells.mp4

06:12

06.02-changing column and row widths.mp4

03:45

06.03-module 6-practice exercise.mp4

01:11

07.01-cut copy and paste.mp4

07:07

07.02-copying formulas.mp4

05:09

07.03-module 7-practice exercise.mp4

01:20

08.01-overview of formulas.mp4

02:48

08.02-create formulas using functions part 1.mp4

10:03

08.03-create formulas using functions part 2.mp4

05:24

08.04-absolute values.mp4

05:16

08.05-module 8-practice exercise.mp4

01:20

09.01-adding deleting and renaming sheets.mp4

04:09

09.02-additional sheet tab options.mp4

05:19

09.03-dimensional formulas.mp4

05:28

09.04-module 9-practice exercise.mp4

01:31

10.01-formatting cells part 1.mp4

10:04

10.02-formatting cells part 2.mp4

03:38

10.03-formatting numbers.mp4

09:24

10.04-borders and shading.mp4

07:08

10.05-format as table.mp4

06:07

10.06-using styles.mp4

03:49

10.07-using format painter.mp4

04:29

10.08-protecting sheets.mp4

09:01

10.09-fill handle and custom lists.mp4

07:17

10.10-module 10-practice exercise.mp4

01:10

11.01-creating charts.mp4

09:48

11.02-types of charts.mp4

05:58

11.03-editing charts part 1.mp4

11:00

11.04-editing charts part 2.mp4

03:12

11.05-using graphics to enhance charts.mp4

05:05

11.06-linking chart titles.mp4

02:47

11.07-module 11-practice exercise.mp4

00:53

12.01-creating range names.mp4

07:45

12.02-managing names.mp4

03:17

12.03-using names in formulas.mp4

05:58

12.04-module 12-practice exercise.mp4

01:20

13.01-remove duplicates.mp4

07:45

13.02-sort data.mp4

10:28

13.03-filter data.mp4

07:38

13.04-advanced filters.mp4

04:46

13.05-module 13-practice exercise.mp4

00:57

14.01-creating an outline.mp4

06:01

14.02-subtotals.mp4

08:00

14.03-module 14-practice exercise.mp4

01:07

15.01-arranging files.mp4

03:14

15.02-new window option.mp4

02:45

15.03-custom views.mp4

05:32

15.04-module 15-practice exercise.mp4

01:07

16.01-creating formulas between files.mp4

06:35

16.02-working with links.mp4

04:01

16.03-consolidating data.mp4

05:16

16.04-module 16-practice exercise.mp4

01:30

17.01-if statements.mp4

07:49

17.02-vlookups.mp4

07:39

17.03-data validation.mp4

08:13

17.04-formula auditing.mp4

05:29

17.05-module 17-practice exercise.mp4

01:20

18.01-pivottables.mp4

09:36

18.02-pivot charts.mp4

03:16

18.03-module 18-practice exercise.mp4

00:56

19.01-slicers.mp4

04:41

19.02-goal seeker.mp4

02:56

19.03-text to columns.mp4

02:49

19.04-watch window.mp4

02:32

19.05-customizing ribbons and tabs.mp4

03:25

19.06-module 19-practice exercise.mp4

01:23

20.01-excel shortcuts every user should know.mp4

12:00

21.01-summary.mp4

00:37

22.01-introduction.mp4

06:39

22.02-course structure.mp4

04:19

23.01-functions-part 1.mp4

13:38

23.02-functions-part 2.mp4

08:04

23.03-autosum.mp4

06:01

24.01-how date and time works.mp4

10:00

24.02-basic date and time functions.mp4

09:43

24.03-complex date and time functions.mp4

10:38

25.01-using text functions-part 1.mp4

12:21

25.02-using text functions-part 2.mp4

12:12

26.01-logical functions.mp4

09:44

26.02-exercise 01.mp4

01:58

27.01-lookup functions-part 1.mp4

14:02

27.02-lookup functions-part 2.mp4

07:56

27.03-exercise 02.mp4

05:37

28.01-financial functions and terminology.mp4

08:51

28.02-personal financial functions.mp4

09:18

28.03-principal and interest payments.mp4

07:23

28.04-depreciation.mp4

05:04

28.05-exercise 03.mp4

01:37

29.01-statistical functions for description-part 1.mp4

13:32

29.02-statistical functions for description-part 2.mp4

13:43

29.03-statistical functions for forecasting-part 1.mp4

11:54

29.04-statistical functions for forecasting-part 2.mp4

11:45

29.05-exercise 04.mp4

01:45

29.06-one click forecasting.mp4

08:56

29.07-statistical functions for inference.mp4

11:09

30.01-connecting to other workbooks.mp4

13:09

30.02-connecting to access databases.mp4

12:50

30.03-connecting web data sources.mp4

07:52

30.04-get and transform.mp4

14:25

30.05-exercise 05.mp4

05:06

31.01-introduction to tables.mp4

12:13

31.02-working with tables.mp4

10:40

31.03-table references.mp4

08:31

31.04-table styles.mp4

05:33

31.05-exercise 6.mp4

01:21

32.01-introduction to pivottables.mp4

09:50

32.02-working with pivottables.mp4

12:43

32.03-filters and slicers.mp4

12:25

32.04-pivot and charts.mp4

08:30

32.05-exercise 07.mp4

02:28

33.01-what if analysis.mp4

10:15

33.02-scenario manager.mp4

11:21

33.03-goal seek.mp4

07:25

33.04-solver.mp4

12:00

33.05-exercise 08.mp4

01:43

34.01-area charts.mp4

06:40

34.02-surface charts.mp4

04:40

34.03-radar charts.mp4

05:21

34.04-bubble charts.mp4

07:19

34.05-sparklines.mp4

09:33

34.06-stock charts.mp4

09:06

34.07-exercise 9.mp4

03:33

35.01-web app-part 1.mp4

10:07

35.02-web app-part 2.mp4

09:52

36.01-summary.mp4

00:49

9781801075763 Code.zip

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

PacktPub

View courses PacktPub

Packt is a publishing company founded in 2003 headquartered in Birmingham, UK, with offices in Mumbai, India. Packt primarily publishes print and electronic books and videos relating to information technology, including programming, web design, data analysis and hardware.