Excellent		13 Reviews
Good		9 Reviews
medium		0 Reviews
Acceptable		0 Reviews
Not Good		2 Reviews

Excel from Beginner to Advanced

Computer Softwares

1 Launching Excel

2 Microsoft Excel Startup Screen

3 Introduction to the Excel Interface

4 Customizing the Excel Quick Access Toolbar

5 More on the Excel Interface

6 Entering Text to Create Spreadsheet Titles

7 Working with Numeric Data in Excel

8 Entering Date Values in Excel

9 Working with Cell References

10 Creating Basic Formulas in Excel

11 Relative Versus Absolute Cell References in Formulas

12 Understanding the Order of Operation DOWNLOAD EXERCISE FILE

13 The structure of an Excel Function

14 Working with the SUM Function

15 Working with the MIN and MAX Functions

16 Working with the AVERAGE Function

17 Working with the COUNT Function

18 Adjacent Cells Error in Excel Calculations

19 Using the AutoSum Command

20 Excel s AutoSum Shortcut Key

21 Using the AutoFill Command to Copy Formulas

22 Moving and Copying Data in an Excel Worksheet

23 Inserting and Deleting Rows and Columns

24 Changing the Width and Height of Cells

25 Hiding and Unhiding Excel Rows and Columns

26 Renaming an Excel Worksheet

27 Deleting an Excel Worksheet

28 Moving and Copying an Excel Worksheet

29 Working with Font Formatting Commands

30 Changing the Background Color of a Cell

31 Adding Borders to Cells

32 Formatting Data as Currency Values

33 Formatting Percentages

34 Using Excel s Format Painter

35 Creating Styles to Format Data

36 Merging and Centering Cells

37 Using Conditional Formatting

38 Inserting Images

39 Inserting Excel Shapes

40 Formatting Excel Shapes

41 Working with Excel SmartArt

42 Creating an Excel Column Chart

43 Working with the Excel Chart Ribbon

44 Adding and Modifying Data on an Excel Chart

45 Formatting an Excel Chart

46 Moving a Chart to another Worksheet

47 Working with Excel Pie Charts

48 Viewing your Document in Print Preview

49 Changing the Margins Scaling and Orientation

50 Working with Page Layout View

51 Adding Header and Footer Content

52 Printing a Specific Range of Cells

53 Intro to Excel Templates

54 Opening an Existing Template

55 Creating a Custom Template

56 Congratulations

57 Understanding Excel List Structure

58 Sorting a List Using Single Level Sort

59 Sorting a List Using Multi Level Sorts

60 Using Custom Sorts in an Excel List

61 Filter an Excel List Using the AutoFilter Tool

62 Creating Subtotals in a List

63 Format a List as a Table

64 Using Conditional Formatting to Find Duplicates

65 Removing Duplicates

66 Excel Function DSUM

67 Excel Function DAVERAGE

68 Excel Function DCOUNT

69 Excel Function SUBTOTAL

70 Understanding the Need for Data Validation

71 Creating a Validation List

72 Adding a Custom Validation Error

73 Dynamic Formulas by Using Validation Techniques

74 Importing Data from Text Files

75 Importing Data from Microsoft Access

76 Exporting Data to a Text File

77 Understanding Excel PivotTables

78 Creating an Excel PivotTable