2015
Udemy
Joel Levy
3:09
English
By taking this Excel For Beginners course, you will learn excel basics and other important details on your way to becoming an Expert in using Excel. Joel Levy of PC Applications with 20 years of Instructor Led Computer Training Experience will take you step by step through the entire process of creating a Worksheet with Net Income and Commission Calculations, Basic Function Calculations (including Average), and a Sales Chart as an example of how to create, save and print an Excel Workbook. Many important underlying concepts about working with Excel are explained in detail using plain simple terms. Course files are provide so you can work right along with each lesson for the "hands on experience".
Along the way, you will learn about what Excel can be used for, the Excel Window and Using Tabs and Ribbons, Opening, Creating and Saving Workbooks, Excel File Types, Entering Data and Data Types, Creating Formulas and Functions, Cell Addresses and Cell Address Types, Moving and Copying Data and Formulas, Editing Data and Worksheets, Formatting Data and Worksheets, Creating Basic Charts, Proofing and Printing Including Headers and Footers in this excel for beginners. Many shortcuts are covered. This excel basics course contains 17 Lessons with almost 4 Hours of video content.
1 - Intro
2 - Opening Excel
3 - The Anatomy Of A Workbook
4 - The Anatomy Of A Workbook Review
5 - First Things First - Save Your New Workbook
6 - Entering Data - Text
7 - Editing Data - Text
8 - Ooops. I Made A Mistake - Undo and Redo
9 - Formatting Text - Fonts
10 - A Quick Word On Formatting
11 - Formatting - Alignment
12 - Saving Time with AutoFilling Sequences
13 - Saving Time with Format Painter
14 - Changing The Column Width
15 - Merge And Centre
16 - Entering Data - A Couple Of Shortcuts
17 - Sums - The Old Fashioned Way
18 - Sums - Using Autosum
19 - Copying Formulas
20 - SUMming Horizontally
21 - Basic Formulas - Subtraction
22 - Basic Formulas - Multiplication
23 - Basic Formulas - Division
24 - Average Function
25 - The Order Of Mathematical Operation
26 - POWER USER - Evaluate Formula Function
27 - Inserting New Columns and Rows
28 - Moving Existing Columns And Rows
29 - Cutting Copying Inserting And Deleting
30 - Hiding Columns And Rows
31 - ROUNDing
32 - Formatting Numbers
33 - A Primer In Building Complex Formulas
34 - Building A Complex Formula
35 - Sorting
36 - Wrapping Text And Soft Enter
37 - Adding A New Worksheet
38 - Creating A Simple Chart
39 - Adding Borders
40 - Customizing the Quick Access Toolbar
41 - Simple Printing
42 - Freezing For An Easier View
43 - Getting Help
44 - Filters
45 - Highlighting Cells
46 - Closing
47 - Bonus 1 - Whizzing Around Excel
48 - Bonus 2 - The Keyboard Shortcuts
Download File Size:575.78 MB
|
