- Description
- Curriculum
Useful Excel for Beginners
Welcome to the Useful Excel for Beginners course.
In this course, you will learn the fundamentals of Excel and become an effective user. The target audience for the course are those who have never used Excel before and those who are beginner level users. You would need a copy of Microsoft Excel for Windows since you will be practicing along with the course. I use Excel 2010 for Windows in the videos but any version with Excel 2007 for Windows or later would work. Excel Versions prior to 2007 have a different user interface but concepts will apply.
As the course is targeting beginners, it has been developed to be very easy to follow. We will be working with data related to a book store in the exercises. The files are available for download and you can follow along the videos while practicing.
The course covers the topics that you would need to know, to become a functional user. You can download the Table of Contents document from Chapter 1, to see all the topics the course will address. The course has 89 videos and runs for 9.5 hours.
Since this is a free course, Udemy does not offer certificates anymore.
Related
Discover more from HeryGacy CompTutor
Subscribe to get the latest posts sent to your email.
-
6How to Enter dataVideo lesson
-
7Auto FitVideo lesson
-
8Keyboard NavigationVideo lesson
-
9Auto CompleteVideo lesson
-
10Entering NumbersVideo lesson
-
11Navigating edgesVideo lesson
-
12Navigating - First and last used cellsVideo lesson
-
13Selecting cells - IntroductionVideo lesson
-
14Selecting cells - Shift + ArrowVideo lesson
-
15Selecting cells - Ctrl + Shift + ArrowVideo lesson
-
16Selecting cells - Mouse Click and DragVideo lesson
-
17Selecting cells - Mouse Click and Shift ClickVideo lesson
-
18Selecting cells - All Cells & Used CellsVideo lesson
-
19Selecting cells - Rows and ColumnsVideo lesson
-
20Selecting cells - Non-contiguous cellsVideo lesson
-
21Selecting cells - SummaryVideo lesson
-
22Number Formatting - IntroductionVideo lesson
-
23Number Formatting - General and TextVideo lesson
-
24Number Formatting - Number and FractionVideo lesson
-
25Number Formatting - CurrencyVideo lesson
-
26Number Formatting - AccountingVideo lesson
-
27Number Formatting - PercentageVideo lesson
-
28Number Formatting - DateVideo lesson
-
29Number Formatting - TimeVideo lesson
-
30Number Formatting - SummaryVideo lesson
-
31Inserting and deleting Rows, Columns and CellsVideo lesson
-
32CHAPTER 3: ENTERING DATAQuiz
QUESTIONS RELATED TO THE MATERIAL COVERED IN CHAPTER 3: ENTERING DATA
-
33Formatting - IntroductionVideo lesson
-
34Formatting - Bold, Italics and UnderlineVideo lesson
-
35Formatting - BorderVideo lesson
-
36Formatting - Fill and FontVideo lesson
-
37Formatting - AlignmentVideo lesson
-
38Formatting - Format Painter and Clear FormatsVideo lesson
-
39CHAPTER 4: FORMATTINGQuiz
QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 4: FORMATTING
-
40Editing - Editing Cell ContentVideo lesson
-
41Editing - Multiple Lines of TextVideo lesson
-
42Editing - Ctrl + EnterVideo lesson
-
43Editing - Auto FillVideo lesson
-
44Editing - Copy and PasteVideo lesson
-
45Editing - Cut and PasteVideo lesson
-
46Editing - Auto Fill SeriesVideo lesson
-
47Editing - SortVideo lesson
-
48Editing - FilterVideo lesson
-
49Editing - Find and ReplaceVideo lesson
-
50CHAPTER 5: EDITINGQuiz
QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 5: EDITING
-
54Calculations - Introduction to FormulaVideo lesson
-
55Editing FormulaVideo lesson
-
56Introduction to FunctionsVideo lesson
-
57Entering FunctionsVideo lesson
-
58Types of FunctionsVideo lesson
-
59MIN, MAX and AVERAGE FunctionsVideo lesson
-
60Copying FormulaVideo lesson
-
61Cell ReferencesVideo lesson
-
62Paste FormulaVideo lesson
-
63Counting FunctionsVideo lesson
-
64Lookup FunctionsVideo lesson
-
65Date FunctionsVideo lesson
-
66Text FunctionsVideo lesson
-
67SUMIF FunctionVideo lesson
-
68IF FunctionVideo lesson
-
69ErrorsVideo lesson
-
70Calculations - SummaryVideo lesson
-
71CHAPTER 8: CALCULATIONSQuiz
QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 8: CALCULATIONS
-
72Introduction to ChartsVideo lesson
-
73Creating a ChartVideo lesson
-
74Chart Components - LabelsVideo lesson
-
75Chart Components - BackgroundVideo lesson
-
76Chart Components - AxesVideo lesson
-
77Chart Components - Format and DesignVideo lesson
-
78Chart TypesVideo lesson
-
79Introduction to Conditional FormattingVideo lesson
-
80Conditional Formatting - Format All CellsVideo lesson
-
81Conditional Formatting - Format Only CellsVideo lesson
-
82Conditional Formatting - More Rule TypesVideo lesson
-
83Conditional Formatting - Formula BasedVideo lesson
-
84Conditional Formatting - SummaryVideo lesson
-
85IllustrationsVideo lesson
-
86CHAPTER 9: VISUALIZINGQuiz
QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 9: VISUALIZING
