There are no items in your cart
Add More
Add More
| Item Details | Price | ||
|---|---|---|---|
MIcrosoft Excel - Beginner to Pro Level
Instructor: Rudra
Language: Hindi
Validity Period: Lifetime
₹9999 70% OFF
₹2999
1. Introduction to course!
2. Excel worksheet operations- the basics
3. How to use copy, cut and paste features in Excel
4. Excel Comments- How to use them
5. Sorting data in Excel
6. Finding and Replacing Data in Excel
7. Text Formatting in Excel
8. Applying a format quickly to other cells
9. Tables and Excel filtering- the basics
10. Data Validation in under 20 minutes
11. Formulas Part 1- Understanding syntax and basic maths
12. Formulas Part 2- Understanding more formula syntax and formula references
13. Formulas Part 3- Learn how to write formulas
14. Formulas Part 4- If then else statements
15. Formulas Part 5- Multiple conditions testing in Excel
16. Formulas Part 6- How do I know which formula to use
17. Formulas Part 7- Excel Formula Error Messages
18. Formulas Part 8- How to audit any formula
19. Formulas Part 9- Useful text functions to know
20. Formulas Part 10- Data analysis Excel functions to know
21. Formulas Part 11- Advanced Vlookup()
22. Charts- The basics part 1
23. Charts- The basics part 2
24. Charts Intermediate level Part 1- Colour changing and thermometer charts
25. Charts Intermediate level Part 2- Handy chart techniques,funnel and gantt charts
29. Charts Advanced level- Creating a dynamic chart
30. Charts Advanced level- Creating a dynamic chart part 2
31. Charts Advanced level- Creating a dynamic chart part 3
32. Conditional Formatting
33. Pivot Tables
34. Excel Reporting Skills- Essential Tips for Excel Reports
35. Excel Security- Protect your workbooks
36. Making Excel run faster
37. How to stop one Excel workbook from crashing another
38. Introduction to VBA
39. Setting up Excel for VBA use
40. The Basics of VBA
41. VBA Object Model Explained
42. Debugging Code in VBA
43. Building _Real Life_ Macros
44. Excel Career Tips- Use your skills to do better
45. General IT Career Tips
46. The end!
| 1. Introduction to course! | |||
| 1. Introduction to the Excel course 8:00 | |||
| 1.1 Excel Course Syllabus (1 pages) | |||
| 2. Get your personalised training program | |||
| 3. How to access the course discussion forum | |||
| 4. Handy List of Excel Shortcuts (1 pages) | |||
| 2. Excel worksheet operations- the basics | |||
| 1. A very quick overview of an Excel workbook 3:00 | |||
| 2. Excel worksheet operations- the basics 10:00 | |||
| 2.1 worksheet tasks | |||
| 3. Sorting Excel worksheet tabs 6:00 | |||
| 3.1 sorting tabs start of lecture | |||
| 3.2 sorting tabs end of lecture | |||
| 4. The Excel ribbon tab 12:00 | |||
| 4.1 excel ribbon | |||
| 5. Customising the Quick Access Toolbar and Excel Ribbon 13:00 | |||
| 6. Your Excel exercises for the Excel ribbon 1:00 | |||
| 7. Resizing Excel columns 4:00 | |||
| 7.1 resizing columns quickly | |||
| 8. Hiding and Unhiding Excel Columns 6:00 | |||
| 8.1 hiding and unhiding columns | |||
| 9. Hiding and Unhiding Excel Rows 5:00 | |||
| 9.1 hiding and unhiding rows | |||
| 10. Hiding and Unhiding Non Sequential Excel Rows and Columns 4:00 | |||
| 10.1 hiding and unhiding non sequential rows | |||
| 11. How to zoom in and out on an Excel spreadsheet 7:00 | |||
| 11.1 worksheet zoom | |||
| 12. Splitting a worksheet view in Excel 2:00 | |||
| 12.1 splitting a worksheet | |||
| 13. Using Freeze Panes part 1 1:00 | |||
| 13.1 freeze panes | |||
| 14. Using Freeze Panes part 2 4:00 | |||
| 15. Filling in data using Auto Fill 12:00 | |||
| 15.1 autofill | |||
| 16. Excel Auto Fill exercises 3:00 | |||
| 16.1 autofill exercises | |||
| 17. The Excel skill of spotting errors 8:00 | |||
| 17.1 autofill-exercises follow up | |||
| 18. A quick note about Auto Fill in Excel 3:00 | |||
| 18.1 autofill-exercises quick note | |||
| 19. Using Flash Fill in Excel to fill in data 5:00 | |||
| 19.1 Flash Fill | |||
| 20. Flash Fill exercises 2:00 | |||
| 20.1 flash fill exercises | |||
| 21. Printing pages in Excel properly 3:00 | |||
| 21.1 how to print | |||
| 22. Using Excel_s status bar 9:00 | |||
| 22.1 status bar | |||
| 23. How to use Excel_s Spell Checker Properly 8:00 | |||
| 23.1 excel spell check | |||
| 24. Student Handout Excel Essentials _How to_ Sheet Summary of Section | |||
| 24.1 Excel summary sheet essentials v2 | |||
| 3. How to use copy, cut and paste features in Excel | |||
| 1. An overview to Copy, Cutting and Pasting Excel data 2:00 | |||
| 1.1 Excel copy cut paste workbook | |||
| 2. How to cut, copy and paste rows and columns 6:00 | |||
| 2.1 cutting and copying rows and columns | |||
| 3. Examples of CopyCutPaste 12:00 | |||
| 4. More Worked Examples 11:00 | |||
| 5. Yours Tasks for this Section | |||
| 6. How to copy only visible cells in Excel 3:00 | |||
| 6.1 copy cells shown | |||
| 4. Excel Comments- How to use them | |||
| 1. Adding comments to Excel worksheets 4:00 | |||
| 1.1 comments | |||
| 2. Quiz on Comments in Excel | |||
| 3. Deleting Excel comments all at the same time 2:00 | |||
| 3.1 deleting comments | |||
| 4. Changing the colour of Excel comments 5:00 | |||
| 4.1 changingcoloursofexcelcomments | |||
| 5. Resize comments in Excel 4:00 | |||
| 5.1 resize comments natively | |||
| 6. How to use Excel comments properly 3:00 | |||
| 6.1 commenttips | |||
| 5. Sorting data in Excel | |||
| 1. Overview of sort 8:00 | |||
| 1.1 sorting data | |||
| 2. Sorting data by numbers 2:00 | |||
| 3. Sorting data by cell background colour 2:00 | |||
| 4. Sorting data by font colour 1:00 | |||
| 5. Using more than one rule to sort data 8:00 | |||
| 6. Conclusion to Sorting in Excel section | |||
| 7. Your Sorting Tasks | |||
| 8. How to sort in reverse order with data that has no logical order 4:00 | |||
| 8.1 sorting in reverse order | |||
| 6. Finding and Replacing Data in Excel | |||
| 1. Finding and replacing data in Excel 3:00 | |||
| 1.1 finding and replacing data | |||
| 2. Finding and replacing data for selected columns 2:00 | |||
| 2.1 finding and replacing data selected columns | |||
| 3. Quiz on finding and replacing data | |||
| 7. Text Formatting in Excel | |||
| 1. Applying formatting to text 16:00 | |||
| 1.1 text part 1 | |||
| 2. Applying formatting to text part 2 15:00 | |||
| 2.1 text part 2 | |||
| 8. Applying a format quickly to other cells | |||
| 1. Applying a format quickly to other cells 6:00 | |||
| 1.1 format painter | |||
| 2. Quiz on Format Painter | |||
| 9. Tables and Excel filtering- the basics | |||
| 1. Making a table 9:00 | |||
| 1.1 making a table part 1 | |||
| 2. Using filters in tables, removing duplicate data and resetting a table 19:00 | |||
| 2.1 filters, deleting duplicates, table back to normal | |||
| 3. Your turn! Preparing a table for a report 1:00 | |||
| 3.1 test on tables - Copy.xlsx | |||
| 4. How to copy a table from MS Excel to MS Word 6:00 | |||
| 4.1 copying a table - Copy.xlsx | |||
| 10. Data Validation in under 20 minutes | |||
| 1. Data Validation Part 1 9:00 | |||
| 1.1 data validation start of section | |||
| 1.2 data validation end of section | |||
| 2. Data Validation Part 2 7:00 | |||
| 11. Formulas Part 1- Understanding syntax and basic maths | |||
| 1. Formulas- An Introduction 2:00 | |||
| 2. Formula Syntax Breakdown 7:00 | |||
| 3. Formulas syntax quiz | |||
| 4. Back to basics overview 7:00 | |||
| 5. Learning to add in Excel 5:00 | |||
| 6. Excel adding quiz | |||
| 7. Multiplying in Excel 2:00 | |||
| 7.1 multiplication | |||
| 8. Excel multiplication quiz | |||
| 9. Learning to subtract in Excel 2:00 | |||
| 9.1 subtraction | |||
| 10. Excel subtraction quiz | |||
| 11. Dividing in Excel 2:00 | |||
| 11.1 division | |||
| 12. Excel division quiz | |||
| 12. Formulas Part 2- Understanding more formula syntax and formula references | |||
| 1. Brackets and references- Quick intro 1:00 | |||
| 2. Using brackets() in Excel 4:00 | |||
| 2.1 brackets | |||
| 3. Excel brackets quiz | |||
| 4. Understanding absolute and fixed references 10:00 | |||
| 4.1 aandrreferences | |||
| 5. Best way for editing Excel absolute and relative references 1:00 | |||
| 5.1 referenceextra | |||
| 6. Excel references quiz | |||
| 7. Excellent key to use when writing Excel formulas 2:00 | |||
| 7.1 editingformulas | |||
| 8. How the F-lock key looks like on a typical keyboard | |||
| 13. Formulas Part 3- Learn how to write formulas | |||
| 1. Formulas Part 1 20:00 | |||
| 1.1 formulas part 1 - Copy.xlsx | |||
| 2. Formulas Part 2 8:00 | |||
| 3. Using Excel_s Auto Fill for formulas 10:00 | |||
| 3.1 auto fill and formulas - Copy.xlsx | |||
| 4. Formulas Worked Example 1 10:00 | |||
| 4.1 formulas further examples - Copy.xlsx | |||
| 5. Formulas Worked Example 2 3:00 | |||
| 6. Formulas Worked Example 3 12:00 | |||
| 7. Formulas Worked Example 4 7:00 | |||
| 8. Formulas Further Examples 4.1 2:00 | |||
| 9. Formulas Worked Example 5 16:00 | |||
| 10. Formulas - Your tasks for this section | |||
| 10.1 formulaspart3tasks - Copy.xlsx | |||
| 14. Formulas Part 4- If then else statements | |||
| 1. Introduction to if then else statements 13:00 | |||
| 1.1 if then else statements - Copy.xlsx | |||
| 2. Logical operators 7:00 | |||
| 2.1 Excel logical operators - Copy.xlsx | |||
| 3. If then else statements Worked Example 2 10:00 | |||
| 4. If then else statements Worked Example 3 7:00 | |||
| 5. Your tasks for this section | |||
| 5.1 if then else questions - Copy.xlsx | |||
| 15. Formulas Part 5- Multiple conditions testing in Excel15. Formulas Part 5- Multiple conditions testing in Excel | |||
| 1. The Excel AND operator 7:00 | |||
| 1.1 mutiple test conditions Excel if and or - Copy.xlsx | |||
| 2. The Excel OR operator 5:00 | |||
| 3. Your tasks | |||
| 3.1 andor questions - Copy.xlsx | |||
| 4. Using ifs statements 12:00 | |||
| 4.1 ifs statement - Copy.xlsx | |||
| 16. Formulas Part 6- How do I know which formula to use | |||
| 1. Formula Helper Part 1 8:00 | |||
| 1.1 excelformulahelper - Copy.xlsx | |||
| 2. Formula Helper Part 2 5:00 | |||
| 17. Formulas Part 7- Excel Formula Error Messages | |||
| 1. Excel Error Messages- What do they mean 6:00 | |||
| 1.1 Excel error messages - Copy.xlsx | |||
| 2. Excel error messages quiz | |||
| 18. Formulas Part 8- How to audit any formula | |||
| 1. Audit that formula! 13:00 | |||
| 1.1 formulatracing.xlsx | |||
| 2. Auditing formula quiz | |||
| 19. Formulas Part 9- Useful text functions to know | |||
| 1. Getting the length of a string 4:00 | |||
| 1.1 len function - Copy - Copy.xlsx | |||
| 2. Strings length quiz | |||
| 3. Finding text within a string 7:00 | |||
| 3.1 find function - Copy - Copy.xlsx | |||
| 4. Finding text quiz | |||
| 5. Finding text within a string part 2 9:00 | |||
| 5.1 search function - Copy.xlsx | |||
| 6. Searching text quiz | |||
| 7. Extracting text from a string 8:00 | |||
| 7.1 mid function rewind - Copy - Copy.xlsx | |||
| 8. Extracting text quiz | |||
| 9. Getting rid of excess spaces 4:00 | |||
| 9.1 trim - Copy - Copy.xlsx | |||
| 10. Trimming text quiz | |||
| 11. Joining text from different Excel cells 4:00 | |||
| 11.1 concatenate - Copy - Copy.xlsx | |||
| 12. Joining text quiz | |||
| 13. Worked Example- How do you separate first and last names 17:00 | |||
| 13.1 iserror, find, if statements, substitute and trim - Copy.xlsx | |||
| 14. Separating first and last names quiz | |||
| 15. How to extract initials from a full name in Excel 6:00 | |||
| 15.1 getting initials from names - Copy.xlsx | |||
| 20. Formulas Part 10- Data analysis Excel functions to know | |||
| 1. How to sum a range of values based on one or more criteria 9:00 | |||
| 1.1 sumifandsumifs.xlsx | |||
| 2. Sum if quiz | |||
| 3. How to retrieve a value based on a lookup of another value 13:00 | |||
| 3.1 vlookup.xlsx | |||
| 4. A vlookup() key concept that every Excel user must know 2:00 | |||
| 5. Vlookup() and column sorting | |||
| 6. Vlookup() exercises | |||
| 7. Isna() task 2:00 | |||
| 7.1 isna exercise - Copy.xlsx | |||
| 8. Vlookup() with Dynamic Columns 9:00 | |||
| 8.1 vlookup dynamic columns - Copy.xlsx | |||
| 9. Excel jobs demand for vlookup() as an employable skill 3:00 | |||
| 10. Vlookup quiz | |||
| 11. The Isblank() function- Determining if a cell is blank or not 6:00 | |||
| 11.1 isblank - Copy.xlsx | |||
| 12. Isblank() - Two examples of its typical use 14:00 | |||
| 12.1 isblank example 1 - Copy.xlsx | |||
| 12.2 isblank example 2 after alterations - Copy.xlsx | |||
| 12.3 isblank example 2 before alterations - Copy.xlsx | |||
| 13. Using dropdown lists and vlookup to create user friendly lookups 10:00 | |||
| 13.1 dropdown lists and vlookups - Copy.xlsx | |||
| 14. Building in advanced error checking into our friendly vlookup() | |||
| 14.1 Excel looking up data with error checking - Copy.xlsx | |||
| 15. Using Index() and Match() functions to lookup data 12:00 | |||
| 15.1 index and match lecture - Copy.xlsx | |||
| 16. IndexMatch exercises | |||
| 16.1 index match exercises - Copy.xlsx | |||
| 17. How to use HLookup() 12:00 | |||
| 17.1 hlookup - Copy.xlsx | |||
| 18. How to calculate working days 5:00 | |||
| 18.1 networkdays.xlsx | |||
| 19. Adding working days to a date! 7:00 | |||
| 19.1 workday.xlsx | |||
| 20. Working days quiz | |||
| 21. Using the Excel Aggregate function() 8:00 | |||
| 21.1 aggregate function - Copy.xlsx | |||
| 22. How to add Excel comments to formulas within the actual formula 4:00 | |||
| 22.1 n function - Copy.xlsx | |||
| 23. Two quick tips for entering formulas 5:00 | |||
| 23.1 Quick tips formulas - Copy.xlsx | |||
| 24. How to make formulas easier to type and read by inserting breaks 7:00 | |||
| 24.1 using insert breaks for formulas - Copy.xlsx | |||
| 25. Calculating Results Direct in the Formula Bar in Excel 6:00 | |||
| 25.1 calculating results in the formula bar - Copy.xlsx | |||
| 21. Formulas Part 11- Advanced Vlookup() | |||
| 1. Advanced Vlookup()- Using the _true_ parameter to reduce the calculation time | |||
| 1.1 advanced vlookup start of lecture for part 1 video - Copy.xlsx | |||
| 1.2 advanced vlookup end of lecture for part 1 video - Copy.xlsx | |||
| 2. Evolving our Vlookup() | |||
| 2.1 advanced vlookup end of lecture for part 2 video - Copy.xlsx | |||
| 2.2 advanced vlookup start of lecture for part 2 video - Copy.xlsx | |||
| 22. Charts- The basics part 1 | |||
| 1. What is a chart 6:00 | |||
| 1.1 charts - Copy.xlsx | |||
| 2. How to quickly make a bar chart 10:00 | |||
| 3. Adjusting a bar chart 9:00 | |||
| 4. Presenting a bar chart 11:00 | |||
| 5. Presenting a bar chart part 2- Worked Examples 3:00 | |||
| 6. Test on charts | |||
| 23. Charts- The basics part 2 | |||
| 1. Making a Clustered Column Excel Chart 6:00 | |||
| 1.1 clustered column charts - Copy.xlsx | |||
| 2. How to make a 100_ Stacked Bar Chart in Excel 7:00 | |||
| 2.1 how to make a 100_ stacked bar chart - Copy.xlsx | |||
| 3. How to make a Pie Chart in Excel 8:00 | |||
| 3.1 excel pie chart - Copy.xlsx | |||
| 4. How to create _before_ and _after_ effect Excel charts 10:00 | |||
| 4.1 before and after effects charts - Copy.xlsx | |||
| 5. Why 3D charts are bad | |||
| 5.1 3D charts - Copy.xlsx | |||
| 6. 3D Charts quiz | |||
| 7. Making sparkline Excel charts 6:00 | |||
| 7.1 sparklines - Copy.xlsx | |||
| 8. Sparklines quiz | |||
| 9. Making text based charts 10:00 | |||
| 9.1 text based charts - Copy.xlsx | |||
| 10. Text based charts quiz | |||
| 11. Variations of text based charts 5:00 | |||
| 11.1 text based charts extra - Copy.xlsx | |||
| 12. Scales and charts- why they matter 8:00 | |||
| 12.1 scales and charts Copy.xlsx | |||
| 24. Charts Intermediate level Part 1- Colour changing and thermometer charts | |||
| 1. How to make dynamic colour changing bar charts 17:00 | |||
| 1.1 coloured chart bars - Copy - Copy.xlsx | |||
| 2. Changing colours chart quiz | |||
| 3. How to make a thermometer chart in Excel Part 1 3:00 | |||
| 4. How to make a thermometer chart in Excel Part 2 6:00 | |||
| 5. How to make thermometer chart in Excel Part 3 7:00 | |||
| 5.1 Thermometer charts - Copy.xlsx | |||
| 25. Charts Intermediate level Part 2- Handy chart techniques,funnel and gantt charts | |||
| 1. Sorting Excel Chart Bars Automatically- Overview 2:00 | |||
| 1.1 introduction lecture - Copy.xlsx | |||
| 2. Sorting Excel Chart Bars- Method 1 10:00 | |||
| 2.1 sorting via rank and vlookup - Copy.xlsx | |||
| 3. Sorting Excel Chart Bars- Method 2 4:00 | |||
| 3.1 sorting via rank and index match - Copy.xlsx | |||
| 4. Sorting Excel Chart Bars- Solving Equal Rank 10:00 | |||
| 4.1 sorting via rank and vlookup with countif - Copy.xlsx | |||
| 5. Making an Excel Funnel Chart in Excel 2016 4:00 | |||
| 5.1 funnel chart - Copy.xlsx | |||
| 6. How to make a Gantt chart in Excel 8:00 | |||
| 6.1 gantt chart2 - Copy.xlsx | |||
| 26. Charts Intermediate Level Part 3- How to make Excel waterfall charts | |||
| 1. How to make a waterfall chart in Excel 2016- Overview 5:00 | |||
| 1.1 waterfall charts - Copy.xlsx | |||
| 2. How to make the monthly sales Excel chart 7:00 | |||
| 3. Waterfall basics quiz | |||
| 4. How to make a personal expense and income Excel chart 6:00 | |||
| 5. How to make a monthly Excel business expenseincome chart 3:00 | |||
| 6. Making an Excel waterfall chart with 3 totals 5:00 | |||
| 27. Charts Intermediate Level Part 4- How to make a gauge chart in Excel | |||
| 1. How to make a gauge chart in Excel | |||
| 1.1 gauge charts - Copy.xlsx | |||
| 28. Charts Advanced level- Creating an Excel Timeline Chart | |||
| 1. How to make an Excel timeline chart part 1 5:00 | |||
| 2. How to make an Excel timeline chart part 2 | |||
| 2.1 timeline charts v2 - Copy.xlsx | |||
| 29. Charts Advanced level- Creating a dynamic chart | |||
| 1. Our dynamic chart ! | |||
| 2. Named ranges 15:00 | |||
| 2.1 named ranges exercise answers - Copy.xlsx | |||
| 2.2 named ranges v2 after - Copy.xlsx | |||
| 2.3 named ranges v2 before - Copy.xlsx | |||
| 2.4 named ranges exercise - Copy.xlsx | |||
| 3. The min function 5:00 | |||
| 3.1 min function - Copy.xlsx | |||
| 4. The max function 4:00 | |||
| 4.1 min max exercises and answers - Copy.xlsx | |||
| 4.2 max function - Copy.xlsx | |||
| 5. Min() and Max() quiz | |||
| 6. The offset function part 1 18:00 | |||
| 6.1 offset after - Copy.xlsx | |||
| 6.2 offset before - Copy.xlsx | |||
| 7. The offset function part 2 4:00 | |||
| 7.1 offset exercises- questions - Copy.xlsx | |||
| 7.2 offset exercises - answers - Copy.xlsx | |||
| 8. Spinners 5:00 | |||
| 8.1 spinners - Copy.xlsx | |||
| 9. The & symbol 11:00 | |||
| 9.1 ampersand - Copy.xlsx | |||
| 10. The & Symbol quiz | |||
| 30. Charts Advanced level- Creating a dynamic chart part 2 | |||
| 1. Building our dynamic chart part 1 13:00 | |||
| 1.1 min and values chart final v2 after - Copy.xlsx | |||
| 1.2 min and values chart final v2 before - Copy.xlsx | |||
| 2. Building our dynamic chart part 2 11:00 | |||
| 3. Building our dynamic chart part 3 10:00 | |||
| 31. Charts Advanced level- Creating a dynamic chart part 3 | |||
| 1. Overview of our Excel annotated automated sales chart 3:00 | |||
| 2. How to annotate our Excel sales chart 12:00 | |||
| 3. How to turn onoff our Excel chart annotations dynamically 3:00 | |||
| 3.1 min and values chart final annotations at end of lecture - Copy.xlsx | |||
| 3.2 min and values chart final annotations at start of lecture - Copy.xlsx | |||
| 32. Conditional Formatting | |||
| 1. Conditional Formatting part 1 15:00 | |||
| 1.1 conditional formatting - Copy.xlsx | |||
| 2. Conditional Formatting Part 2 16:00 | |||
| 3. Highlighting the top ten performers in an Excel table- Part 1 | |||
| 4. Highlighting the top ten performers in an Excel table- Part 2 8:00 | |||
| 4.1 Excel top 10 table start of lecture - Copy.xlsx | |||
| 4.2 Excel top 10 table end of lecture - Copy.xlsx | |||
| 5. Conditional Formatting Tasks | |||
| 6. How to highlight alternate rows in Excel 5:00 | |||
| 6.1 alternate rows - Copy.xlsx | |||
| 7. How to highlight alternate columns in Excel 2:00 | |||
| 7.1 alternate columns - Copy.xlsx | |||
| 8. How to highlight even numbered rows and columns | |||
| 8.1 alternate even rows - Copy.xlsx | |||
| 9. Using conditional formatting to highlight percentage change 3:00 | |||
| 9.1 conditional formatting percent change - Copy.xlsx | |||
| 33. Pivot Tables | |||
| 1. PivotTables - An overview to our section and our first case study 9:00 | |||
| 1.1 excel pivot tables overview at end of lecture - Copy.xlsx | |||
| 1.2 excel pivot tables overview start of lecture - Copy.xlsx | |||
| 2. PivotTables Preparation - Cleaning the data 6:00 | |||
| 2.1 excel pivot tables cleaning data - start of lecture - Copy.xlsx | |||
| 2.2 excel pivot tables cleaning data - end of lecture - Copy.xlsx | |||
| 3. PivotTables overview quiz | |||
| 4. PivotTables - Constructing our Table Part 1 18:00 | |||
| 4.1 excel pivot tables building our table part 1 - start of lecture - Copy.xlsx | |||
| 4.2 excel pivot tables building our table part 1 - end of lecture - Copy.xlsx | |||
| 5. PivotTables- Constructing our Table Part 2 19:00 | |||
| 5.1 excel pivot tables building our table part 2 - end of lecture - Copy.xlsx | |||
| 5.2 excel pivot tables building our table part 2 - start of lecture - Copy.xlsx | |||
| 6. PivotTables- Quick note before the next lecture | |||
| 7. PivotTables- Building our table using the Classic Layout View 4:00 | |||
| 7.1 excel pivot tables building our table using classic layout - start of lecture - Copy.xlsx | |||
| 7.2 excel pivot tables building our table using classic layout- end of lecture - Copy.xlsx | |||
| 8. Showing Values as Percentages in PivotTables 12:00 | |||
| 8.1 using _ for showing values in Pivot tables - start of lecture - Copy.xlsx | |||
| 8.2 using _ for showing values in Pivot tables - end of lecture - Copy.xlsx | |||
| 9. PivotTable Slicers and Timelines - An introduction via another case study 11:00 | |||
| 9.1 excel slicers and timelines - end of lecture - Copy.xlsx | |||
| 9.2 excel slicers and timelines - start of lecture - Copy.xlsx | |||
| 10. Grouping , Sorting and Adding Slicers to PivotTables 11:00 | |||
| 10.1 Adding the slicer - end of lecture - Copy.xlsx | |||
| 10.2 Adding the slicer - start of lecture - Copy.xlsx | |||
| 11. Adding Excel Timelines to PivotTables 5:00 | |||
| 11.1 Adding the timeline - end of lecture - Copy.xlsx | |||
| 11.2 Adding the timeline - start of lecture - Copy.xlsx | |||
| 12. Linking an Excel Timeline to more than one PivotTable | |||
| 12.1 Linking one timeline to more than one PivotTable- start of lecture - Copy.xlsx | |||
| 12.2 Linking one timeline to more than one PivotTable - end of lecture - Copy.xlsx | |||
| 13. Adding an Excel Slicer to more than one PivotTable | |||
| 13.1 Linking one slicer to more than one PivotTable - start of lecture - Copy.xlsx | |||
| 13.2 Linking one slicer to more than one PivotTable - end of lecture - Copy.xlsx | |||
| 14. Conditional formatting for PivotTables | |||
| 14.1 using conditional formatting in Pivot Tables start of lecture - Copy.xlsx | |||
| 14.2 conditional formatting pivottable tasks top and bottom value - Copy.xlsx | |||
| 14.3 conditional formatting pivottable data bar - Copy.xlsx | |||
| 14.4 using conditional formatting in Pivot Tables end of lecture - Copy.xlsx | |||
| 15. PivotTables- Another worked example and your task | |||
| 15.1 pivot table tasks cleaning data end of lecture - Copy.xlsx | |||
| 15.2 pivot table tasks cleaning data task answer - Copy.xlsx | |||
| 15.3 pivot table tasks cleaning data start of lecture - Copy.xlsx | |||
| 16. PivotTable task walkthrough 3:00 | |||
| 17. Replacing blank values in PivotTables | |||
| 34. Excel Reporting Skills- Essential Tips for Excel Reports | |||
| 1. How to do bullet points and new lines in the same cell 6:00 | |||
| 1.1 bulletpointsandnewlines - Copy.xlsx | |||
| 2. An alternative way to do bullet points 7:00 | |||
| 2.1 bullet points alternative way - Copy.xlsx | |||
| 3. Handy special characters to use in Excel Reports 6:00 | |||
| 3.1 handy symbols excel reports - Copy.xlsx | |||
| 4. How to capitalisede-captalise your text- quickly 3:00 | |||
| 4.1 upperandlower - Copy.xlsx | |||
| 5. How to make text properly capitalised 5:00 | |||
| 5.1 proper - Copy.xlsx | |||
| 6. Proper and UpperLower quiz | |||
| 7. How to add a watermark in Excel 6:00 | |||
| 7.1 watermark - Copy.xlsx | |||
| 8. Watermark quiz | |||
| 9. How to customise numbers to display as currency in Exce 11:00 | |||
| 9.1 quickly format numbers to currency - Copy.xlsx | |||
| 10. Format quiz | |||
| 11. Formatting numbers as percentages 6:00 | |||
| 11.1 formatting numbers as percentages - Copy.xlsx | |||
| 12. Generating random numbers in Excel 5:00 | |||
| 12.1 generating random numbers - Copy.xlsx | |||
| 13. How to extract the name from an email address using Excel functions 4:00 | |||
| 13.1 email address - Copy.xlsx | |||
| 14. How to find merged cells in Excel quickly 2:00 | |||
| 14.1 how to find merged cells - Copy.xlsx | |||
| 15. How to show a percentage for the amount of work done | |||
| 15.1 percentage from task or checklist work - Copy.xlsx | |||
| 16. How to check if an Excel cell has a formula in it 5:00 | |||
| 16.1 isformula - Copy.xlsx | |||
| 17. How to generate random dates between two specified dates in Excel | |||
| 17.1 random dates between two specified dates - Copy.xlsx | |||
| 18. How to get a random list in Excel 3:00 | |||
| 18.1 how to get a random list in excel - Copy.xlsx | |||
| 19. How to work out an average excluding zero in Excel 6:00 | |||
| 19.1 averageif - Copy.xlsx | |||
| 20. How to work out the average dynamically based on the last 5 days sales | |||
| 20.1 average last 5 days - Copy.xlsx | |||
| 21. How to calculate the weighted average in Excel 4:00 | |||
| 21.1 weighted average - Copy.xlsx | |||
| 22. How to work out the maximum value based on selected criteria in Excel | |||
| 22.1 maxifs - Copy.xlsx | |||
| 23. How to calculate the minimum value based on selected criteria in Excel | |||
| 23.1 minifs - Copy.xlsx | |||
| 24. How to get dates as days in Excel 3:00 | |||
| 24.1 how to get dates as days - Copy.xlsx | |||
| 25. How to add shapes in Excel 10:00 | |||
| 25.1 shapesadding - Copy.xlsx | |||
| 26. How to add Hierarchy diagrams in Excel 8:00 | |||
| 26.1 Hierarchyflow - Copy.xlsx | |||
| 27. How to add Cycle flow diagrams in Excel 4:00 | |||
| 27.1 cycleflowdiagram - Copy.xlsx | |||
| 28. How to add a Funnel diagram in Excel 3:00 | |||
| 28.1 funneldiagram - Copy.xlsx | |||
| 29. How to quickly locate cells which have formulas in Excel 3:00 | |||
| 30. How to get a weekday from a date using Excel functions | |||
| 30.1 weekday determine - Copy.xlsx | |||
| 31. How to determine the fiscal month from a date in Excel 5:00 | |||
| 31.1 fiscal month from date - Copy.xlsx | |||
| 32. How to return a formula as text in Excel 2013Excel 2016 3:00 | |||
| 32.1 Returning Formulas as Text - Copy.xlsx | |||
| 33. Returning formulas as strings quiz | |||
| 34. How to increment numbers as part of text in Excel 6:00 | |||
| 34.1 numbers with text incrementing - Copy.xlsx | |||
| 35. How to search by colour in Excel 7:00 | |||
| 35.1 Search in Excel by Colour - Copy.xlsx | |||
| 36. Searching Excel by other ways | |||
| 37. How to bookmark Excel spreadsheets quickly for easy reference 6:00 | |||
| 38. Joining formulas and text An In-depth look 12:00 | |||
| 38.1 joiningformulasandtext - Copy.xlsx | |||
| 39. Printing Excel reports- and making them look professional 7:00 | |||
| 40. Resizing comments in Excel using VBA Part 1 3:00 | |||
| 41. Resizing comments in Excel using VBA Part 2 4:00 | |||
| 42. Resizing comments in Excel using VBA Part 3 4:00 | |||
| 43. Using Excel Charts to Quickly Check Data for Outliers 4:00 | |||
| 43.1 charts and outliers - Copy.xlsx | |||
| 44. How to display the last time a workbook was edited 5:00 | |||
| 45. Using vlookups() to calculate money owed by clients 4:00 | |||
| 46. How to work out an average excluding zero 3:00 | |||
| 46.1 averageifzero - Copy.xlsx | |||
| 35. Excel Security- Protect your workbooks | |||
| 1. Protecting your worksheet 6:00 | |||
| 1.1 password worksheet | |||
| 2. Passwording your worksheet quiz | |||
| 3. Adding a password to a workbook 4:00 | |||
| 3.1 password workbook | |||
| 4. Quick note on unpasswording lecture | |||
| 5. How to unpassword your Excel workbook 1:00 | |||
| 5.1 taking out the password to a workbook | |||
| 6. Quiz on workbooks | |||
| 7. How to protect the structure of a workbook 3:00 | |||
| 7.1 protect structure of workbook | |||
| 8. Hiding Excel sheets from plain sight 6:00 | |||
| 8.1 hiding excel worksheets | |||
| 9. Quiz on hiding sheets | |||
| 10. Choosing a good password | |||
| 11. Use Excel 2013 onwards | |||
| 36. Making Excel run faster | |||
| 1. Setting a higher priority for Excel in Windows 2:00 | |||
| 2. Higher priority Excel quiz | |||
| 3. Understanding how to use the calculation feature in Excel 7:00 | |||
| 4. Keeping the Excel window in focus | |||
| 5. Summary of ways to turbo charge Excel | |||
| 37. How to stop one Excel workbook from crashing another | |||
| 1. The problem- One Excel workbook crashing another- live example 4:00 | |||
| 2. A very simple explanation of how Excel loads workbooks | |||
| 3. The solution- How to stop one Excel workbook from crashing another 8:00 | |||
| 38. Introduction to VBA | |||
| 1. Excel VBA Introduction 4:00 | |||
| 2. Excel VBA Handouts | |||
| 2.1 Excel VBA terminology v1.6 (2 pages) | |||
| 2.2 VBA Best Code Practice v1.3 (2 pages) | |||
| 39. Setting up Excel for VBA use | |||
| 1. Adding the Developer tab in MS Excel and how to run the example VBA codes | |||
| 2. Exploring the VBA editor | |||
| 40. The Basics of VBA | |||
| 1. How to run the VBA code from our Excel course 2:00 | |||
| 2. Variables and data types part 1 | |||
| 2.1 variables and data types - Copy.xlsx | |||
| 3. Variables and data types part 2 | |||
| 4. Variables and data types test | |||
| 5. VBA Functions | |||
| 5.1 subroutines and functions - Copy.xlsx | |||
| 6. Functions assignment | |||
| 7. Subroutines Part 1 | |||
| 8. Subroutines Part 2 2:00 | |||
| 9. Subroutines knowledge test | |||
| 10. Operators in VBA 2:00 | |||
| 10.1 operators - Copy.xlsx | |||
| 11. Using if then else statements to make decisions in VBA | |||
| 11.1 Excel VBA Decisions - Copy.xlsx | |||
| 12. Using for loops | |||
| 12.1 Excel VBA Loops - Copy.xlsx | |||
| 41. VBA Object Model Explained | |||
| 1. VBA Object Model Part 1 | |||
| 2. Give an example of a method for a _Car_ Object and a Property too | |||
| 3. VBA Object Model Part 2 | |||
| 3.1 excel macro examples - Copy.xlsx | |||
| 4. Short test for our coding example | |||
| 5. VBA Object Model Part 3 | |||
| 6. VBA Object Model Part 4 | |||
| 6.1 excel cells and r1c1 - Copy.xlsx | |||
| 7. Quick test on R1C1 notation attributes | |||
| 8. VBA Object Model Part 5 | |||
| 9. VBA Object Model Part 6 | |||
| 9.1 R1C1 For Next Loop Summary (1 pages) | |||
| 10. VBA Object Model Part 7 | |||
| 42. Debugging Code in VBA | |||
| 1. Debugging Code in VBA Part 1 | |||
| 1.1 debug macro example - Copy.xlsx | |||
| 2. Debugging Code in VBA Part 2 | |||
| 43. Building _Real Life_ Macros | |||
| 1. Project 1 - Making a macro to clean data | |||
| 1.1 macro 1 project - Copy.xlsx | |||
| 2. Using the Object Browser in VBA | |||
| 3. Project 2 - Making a Macro to Sort Excel Worksheets Alphabetically Part 1 | |||
| 3.1 macro 2 sorting sheets project - Copy.xlsx | |||
| 4. Project 2 - Making a Macro to Sort Excel Worksheets Alphabetically Part 2 | |||
| 5. Project 3 - A VBA Macro to Colour Cells which contain Formulas | |||
| 5.1 VBA colour constants (1 pages) | |||
| 5.2 formulas colours project - Copy.xlsx | |||
| 6. Project 4 - Copying a worksheet from one open workbook to another open workbook | |||
| 6.1 copy sheet to new workbook code.xlsx | |||
| 44. Excel Career Tips- Use your skills to do better | |||
| 1. How to write MS Excel skills on your CVResume 9:00 | |||
| 2. Different jobs that use Excel and the CVResume areas you can focus on 11:00 | |||
| 3. Excel career tips for Graduates with little or no work experience 6:00 | |||
| 4. Power words to use on your CVResume for Excel examples | |||
| 5. Optimising your Excel CVResume for online jobs 12:00 | |||
| 6. Excel Careers lectures wrap up 2:00 | |||
| 45. General IT Career Tips | |||
| 1. Overview of section | |||
| 2. Get your business card sorted 5:00 | |||
| 4. Its good to give 4:00 | |||
| 5. Company reports 4:00 | |||
| 6. Activitiestasks for Company Reports lecture | |||
| 7. Take on any IT project 3:00 | |||
| 8. Activitiestasks for IT projects lecture | |||
| 9. Experiment with new technologies 6:00 | |||
| 10. Activitiestasks for _Experiment with new technologies_ | |||
| 11. Learn how to talk the _talk_ 7:00 | |||
| 12. Activitiestasks for Learn how to talk the _talk_ lecture | |||
| 13. Joining peer societies 4:00 | |||
| 14. Start a blogJoin forums 6:00 | |||
| 15. Activitiestasks for blogforums | |||
| 16. IT Career checklist | |||
| 16.1 Career-checklist (1 pages) | |||
| 46. The end! | |||
| 1. Wrap up lecture to our Excel course 1:00 | |||
After successful purchase, this item would be added to your Library.
You can access the library in the following ways :
- From Computer, you can access your library after successful login
- For other devices, you can access your library using this web app through browser of your device.
Reviews
Other Courses
Launch your Graphy