Microsoft Excel – Excel from Beginner to Advanced

Microsoft Excel – Excel from Beginner to Advanced

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 14 Hours | 3.33 GB

Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, Excel 2013, Excel 2016

Microsoft Excel all in One Package

This Microsoft Excel course combines 4 different courses.

  • Microsoft Excel 101 – An Introduction to Excel
  • Microsoft Excel 102 – Intermediate Level Excel
  • Microsoft Excel 103 – Advanced Level Excel
  • Master Microsoft Excel Macros and VBA in 6 Simple Projects

Material recorded with Excel 2013 but works in 2010, 2013, and 2016

As you participate in each of the 4 courses you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Creating effective spreadsheets
  • Managing large sets of data
  • Mastering the use of some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more…)
  • Create dynamic report with Excel PivotTables
  • Unlock the power and versatility of Microsoft Excel’s AddIn, PowerPivot
  • Audit Excel Worksheet formulas to ensure clean formulas
  • Automate your day to day Excel tasks by mastering the power of Macros and VBA
Table of Contents

microsoft excel course introduction
1 welcome to the ultimate microsoft excel course

microsoft excel 101 course introduction
2 course exercise files

microsoft excel fundamentals
3 launching excel
4 introduction to the excel interface
5 customizing the excel quick access toolbar
6 understanding the structure of an excel workbook
7 saving an excel document
8 opening an existing excel document
9 common excel shortcut keys

entering and editing text and formulas
10 entering text to create spreadsheet titles
11 working with numeric data in excel
12 entering date values in excel
13 working with cell references
14 creating basic formulas in excel
15 relative versus absolute cell references in formulas
16 understanding the order of operation

working with basic excel functions
17 the structure of an excel function
18 working with the sum function
19 working with the min and max functions
20 working with the average function
21 working with the count function
22 using the autosum command
23 using the autofill command to copy formulas

modifying an excel worksheet
24 moving and copying data in an excel worksheet
25 inserting and deleting rows and columns
26 changing the width and height of cells
27 hiding and unhiding excel rows and columns
28 deleting an excel worksheet
29 renaming an excel worksheet
30 moving and copying and excel worksheet

formatting data in an excel worksheet
31 working with font formatting commands
32 changing the background color of a cell
33 adding borders to cells
34 formatting data as currency values
35 formatting percentages
36 using excels format painter
37 creating styles to format data
38 merging and centering cells
39 using conditional formatting

inserting images and shapes into an excel worksheet
40 inserting images
41 inserting excel shapes
42 formatting excel shapes
43 working with excel smartart

creating basic charts in excel
44 creating an excel column chart
45 working with the excel chart ribbon
46 adding and modifying data on an excel chart
47 formatting an excel chart
48 moving a chart to another worksheet
49 working with excel pie charts

printing an excel worksheet
50 viewing your document in print preview
51 changing the margins scaling and orientation
52 working with page layout view
53 adding header and footer content
54 printing a specific range of cells

working with excel templates
55 intro to excel templates
56 opening an existing template
57 creating a custom template

congratulations youve built a solid microsoft excel foundation
58 congratulations

microsoft excel 102 course introduction
59 course exercise files download these first

working with an excel list
60 understanding excel list structure
61 sorting a list using single level sort
62 sorting a list using multilevel sorts
63 using custom sorts in an excel list
64 filter an excel list using the autofilter tool
65 creating subtotals in a list
66 format a list as a table
67 using conditional formatting to find duplicates
68 removing duplicates

excel list functions
69 excel function dsum
70 excel function daverage
71 excel function dcount
72 excel function subtotal

excel data validation
73 understanding the need for data validation
74 creating a validation list
75 adding a custom validation error
76 dynamic formulas by using validation techniques

importing and exporting data
77 importing data from text files
78 importing data from microsoft access
79 exporting data to a text file

excel pivottables
80 understanding excel pivottables
81 creating an excel pivottable
82 modifying excel pivottable calculations
83 grouping pivottable data
84 formatting pivottable data
85 drilling down into pivottable data
86 creating pivotcharts
87 filtering pivottable data
88 filtering with the slicer tool

working with excels powerpivot tools
89 why powerpivot
90 activating the excel powerpivot addin
91 creating data models with powerpivot
92 creating pivottables based on data models
93 powerpivot calculated fields
94 powerpivot kpis

working with large sets of excel data
95 using the freeze panes tool
96 grouping data columns andor rows
97 print options for large sets of data
98 linking worksheets 3d formulas
99 consolidating data from multiple worksheets

congratulations youre an intermediate excel user
100 congratulations

microsoft excel 103 course introduction
101 course excerise files download this excel file first

working with excels conditional functions
102 working with excel name ranges
103 using excels if function
104 nesting functions
105 using excels countif function
106 using excels sumif function
107 using excels iferror function

working with excels lookup functions
108 using excels vlookup function
109 using excels hlookup function
110 using excels index and match functions

working with excels text based functions
111 using excels left right and mid functions
112 using excels len function
113 using excels search function
114 using excels concatenate function

auditing an excel worksheet
115 tracing precendents in excel formulas
116 tracing dependents in excel formuals
117 working with the watch window
118 showing formulas

protecting excel worksheets and workbooks
119 protecting specific cells in a worksheet
120 protecting the structure of a workbook
121 adding a workbook password

mastering excels what if tools
122 working with excels goal seek tool
123 working with excels solver tool
124 building effective data tables in excel
125 creating scenarios in excel

automating repetitive tasks in excel with macros
126 understanding excel macros
127 activating the developer tab in excel
128 creating a macro with the macro recorder
129 editing a macro with vba
130 creating buttons to run macros

congratualtions
131 congratulations on competing the microsoft excel 103

microsoft excel macros and vba course introduction
132 welcome to the course
133 understanding the why and how behind excel macros
134 course exercise files download these first

project 1 using excels macro recorder tool
135 introduction to project 1 inserting and formatting text
136 project 1 start recording
137 project 1 running a macro with a button
138 project 1 opps i need to edit my macro
139 practical uses of excel macros

excel vba concepts
140 excel vba concpets
141 the visual basic editor vbe
142 excel vba modules
143 creating an excel vba procedure
144 understanding excel vba variables
145 working with excel vba loops to repeat blocks of code
146 building logic with an if statement

project 2 moving beyond the basics and into vba
147 introduction to project 2 interacting with the user
148 project 2 breaking down the vba code
149 project 2 prompting the user for information
150 project 2 building logic into your macros
151 project 2 alerting the user of errors
152 other practical uses of message and input boxes

project 3 preparing and cleaning up data with a little vba
153 introduction to project 3 cleaning up and formatting data
154 project 3 using the macro recorder to lay the foundation
155 project 3 preparing to the use the macro recorder
156 project 3 inserting the headers
157 project 3 formatting the headers
158 project 3 putting it all together with a little vba

project 4 using vba to automate excel formulas
159 introduction to project 4 automate excel formulas
160 project 4 automate the sum function through code
161 project 4 loop the sum function over multiple worksheets

project 5 bringing it all together and a weekly report
162 introduction to project 5 creating the final report
163 project 5 putting it all together to create a final report

project 6 working with excel vba user forms
164 introduction to project 6 working with excel vba user forms
165 project 6 creating an excel user form
166 project 6 adding controls to the form
167 project 6 changing control and form properties
168 project 6 adding vba code to the initialize event
169 project 6 adding vba code to the combobox change event
170 project 6 adding vba code to the add worksheet button
171 project 6 adding vba code to the create report button
172 project 6 showing the form

course wrap up
173 congratulations youre an excel macrovba master
174 bonus special offer discount on any of my courses