Introduction to Course - Red & White

Excel Mastery Program (Beginner to Advanced) Introduction to Course

Excel Mastery Program (Beginner to Advanced)

0% Completed

Introduction, Shortcuts, Data Editing

Introduction to Course

Video - 2:06 mins

1 - Excel - Introduction

Video - 3:10 mins

2 - Excel - Exploring

3 - Excel - Understanding Ribbon

4 - Excel - Shortcuts

5 - Excel - Help

6 - Excel - Wroking with Template

7 - Excel - Workbook and Worksheet

8 - Excel - Saving and Recovery

9 - Excel - Editing Data

10 - Navigation and Selection

10.1 - Excel - Exercise 1

Formuls, Calculations, Filtering

11 - Excel - Formulas and Functions

12 - Excel - Calculations

13 - Excel - Counting Values and Blanks

14 - Excel - Filtering Average

15 - Excel - Working with Min and Max

16 - Excel - Error Handling

17 - Excel - ABsolute and Relative Reference

18 - Excel - AutoSum and AutoFill

19 - Excel - Exercise 2

FlashFill, Managing, Calculation

20 - Excel - FlashFill

21 - Excel - Named Ranges

22 - Excel - Create Named Ranges

23 - Excel - Managing Named Ranges

24 - Excel - Using Named Ranges in Calculation

25 - Excel - Exercise 3

Number Formatting, Time Formatting, Format Painter

26 - Excel - Number Formatting

27 - Excel - Date and Time Formatting

28 - Excel - Formatting Cells

29 - Excel - Using Format Painter

30 - Excel - Exercise 4

Clearing Data, Aligning Text, Applying Themes

31 - Excel - Working with Rows and Columns

32 - Excel - Deleting and Clearing Data

33 - Excel - Aligning Text and Numbers

34 - Excel - Applying Themes and Styles

35 - Excel - Exercise 5

Structure Data, Custom Sorting, Filtaring

36 - Excel - How to Structure Data

37 - Excel - Single Level Sorting

38 - Excel - Multi Level Sorting

39 - Excel - Custom Sorting

40 - Excel - Auto Filtering

41 - Excel - Format as a Table

42 - Excel - Subtotal

43 - Excel - Exercise 6

Clipboard, Workbooks, Hyperlinks

44 - Excel - Cut and Copy

45 - Excel - Paste Options

46 - Excel - Pasting form the Clipboard

47 - Excel - Linking Worksheets and Workbooks

48 - Excel - 3D Referencing

49 - Excel - Inserting Hyperlinks

50 - Excel - Exercise 7

VLOOKUP Introduction, Handling Functions, Making Decision with IF

51 - Excel - VLOOKUP Introduction

52 - Excel - VLOOKUP - Approximate Match

53 - Excel - Error Handling Functions

54 - Excel - Logical Functions IF, AND, OR

55 - Excel - Making Decision with IF

56 - Excel - Text Functions

57 - Excel - Time and Date Functions

58 - Excel - Exercise 8

Chart Types, Data withChart

59 - Excel - Chart Types

60 - Excel - Data withChart

61 - Excel - Chart Formatting

62 - Excel - Exercise 9

Data Bars, Highlighting Cell Values, Icons Set

63 - Excel - Data Bars

64 - Excel - Highlighting Cell Values

65 - Excel - Color Scales

66 - Excel - Icons Set

67 - Excel - Exercise 10

Inserting Shapes and Text, Icons and 3D Models, Diagrams and SmartArt

68 - Excel - Inserting Pictures

69 - Excel - Inserting Shapes and Text

70 - Excel - Icons and 3D Models

71 - Excel - Diagrams and SmartArt

72 - Excel - Screenshots

73 - Excel - Comments

74 - Excel - Exercise 11

Workbook Views, Arranging Workbooks, Freezing Panes

75 - Excel - Wprkbook Views

76 - Excel - Using Zoom

77 - Excel - Arranging Workbooks

78 - Excel - Freezing Panes

79 - Excel - Exercise 12

Orientations, Headers and Footers, Printing Options

80 - Excel - Setting Margins and Orientations

81 - Excel - Print Area

82 - Excel - Page Breaks

83 - Excel - Print Titles

84 - Excel - Headers and Footers

85 - Excel - Printing Options

86 - Excel - Exercise 13

Spell Checking, Imspecting Workbook, Saving and Export

87 - Excel - Protecting Wroksheet and Workbook

88 - Excel - Spell Checking

89 - Excel - Imspecting Workbook

90 - Excel - Saving and Export

91 - Excel - Share Document

92 - Excel - Exercise 14

Announcements Course Info