Icons & text

  • Icon & text

    Use an icon and text to communicate the value proposition and share the specific benefits of your offering. What makes it unique in your market?

  • Icon & text

    Use an icon and text to communicate the value proposition and share the specific benefits of your offering. What makes it unique in your market?

  • Icon & text

    Use an icon and text to communicate the value proposition and share the specific benefits of your offering. What makes it unique in your market?

Course curriculum

    1. Welcome message from John Michaloudis!

    2. MyExcelOnline Resources

    3. Downloadable Excel Workbooks

    4. Course Progress Tracker Workbook

    5. Terms & Conditions - Video Sharing Limitations

    1. Tabular Format

    2. No Gaps

    3. Find Blank Cells In Excel With A Color

    4. Formatting

    5. Tables

    6. Clean Your Data Set

    7. Inserting a Pivot Table

    8. Field List - Activate, move, resize & layout

    9. Field List & Areas

    10. Drill down to audit

    11. Sort Field List from A to Z

    12. Double click on any labels to show more Fields

    13. Defer Layout Update

    14. Pivot cache explained

    15. Refresh

    16. Refresh All

    17. Refresh External Data

    18. Import from Access database

    19. Change Data Source

    20. Clear Filters & Clear Pivot

    21. Select & Format

    22. Move a Pivot Table

    23. Pivot Table Styles

    24. Customizing a Pivot Table Style

    25. Use a customised style in another workbook

    26. Subtotals

    27. Grand Totals

    28. Blank Rows

    29. Report Layouts

    30. Show the Classic Pivot Table Layout

    31. Expand & Collapse buttons

    32. Move & Remove Fields and Items

    33. Show/Hide Field List

    34. Show/Hide Field Headers

    35. Change Count of to Sum of

    36. Number formatting

    37. Field name formatting

    38. Predetermined number formatting

    39. Change Sum views in Label areas

    40. Indent rows in compact layout

    41. Change the layout of a report filter

    42. Format error values

    43. Format empty cells

    44. Keep column widths upon refresh

    45. Automatic Refresh a Pivot Table

    46. Printing a pivot table on two pages

    47. Show report filter on multiple pages

    1. Create multiple subtotals

    2. Count

    3. Average

    4. Maximum

    5. Minimum

    6. Product

    7. Count Numbers

    8. Std Dev

    9. Varp

    10. Show various Grand Totals

    11. Shortcuts to Field & Value Field Settings

    12. See all pivot items

    13. Show a unique or distinct count

    1. % of Grand Total

    2. % of Column Total

    3. % of Row Total

    4. % Of

    5. % of Parent Row Total

    6. % of Parent Column Total

    7. % of Parent Total

    8. Difference From

    9. % Difference From

    10. Running Total in

    11. % Running Total in

    12. Rank Smallest to Largest

    13. Rank Largest to Smallest

    14. Index

    15. Shortcuts to Show Values As

    16. ACCOUNTING: % of Revenue Margins

    17. FINANCIAL: Actual v Plan Variance Report

    1. Group by Date

    2. Group by Months

    3. Group by Quarters & Years

    4. Group by Sales ranges

    5. Group by Text fields

    6. Group by Time

    7. Shortcuts to Grouping

    8. Grouping by Half Years

    9. Group by a Date that starts on a Monday

    10. Grouping by a custom date

    11. Group by fiscal years & quarters

    12. Errors when grouping by dates

    13. Group two pivot tables independently

    14. Fixing the problem of counting grouped sales

    15. Display dates that have no data

    16. ACCOUNTING: Quarterly Comparative Report

    17. FINANCIAL: Min & Max Bank Balance

    1. Sorting by Largest or Smallest

    2. Sort an Item Row (Left to Right)

    3. Sort manually (drag, write, right click)

    4. Sort using a Custom List

    5. Override a Custom List sort

    6. Sort row from A-Z and sales from Z-A

    7. Sort new items added to your data source

    8. Clear a sort

    9. Sort Largest to Smallest Grand Totals

About this course

  • $497.00
  • 252 lessons
  • 3 hours of video content

Pricing options

Explain how different pricing options might be valuable to different segments of your audience.

Call to action

This is where you seal the deal. Sprinkle this section throughout you page to push prospects to purchase!