Microsoft Excel – Excel from Beginner to Advanced

Introduction to Microsoft Excel – Excel from Beginner to Advanced Course

After you finish this Intro Course, enroll in the Full Microsoft Excel Course and become an Excel Guru

https://firsteacademy.com/home/course/microsoft-excel-excel-from-beginner-to-advanced/86

You will learn the following:

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. We will guide you step by step through the beginner to advanced level and beyond.

As you participate in each of the 65+ Lectures 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 Add-In, PowerPivot
• Audit Excel Worksheet formulas to ensure clean formulas
• Automate your day-to-day Excel tasks by mastering the power of Macros and VBA

So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newbie to Excel Guru!

You will Learn by Practice:

By the end of this Unique Course, you will go from #Newbie to #Advanced as an #Excel #Spreadsheet_Expert. Here is what you’ll learn:

1 Introduction

1. Introduction
2. Course Outcome
3. Study Skills Required
4. How to get most out of the course

2 Getting Started With Excel

5. Why Excel
6. Excel Menu System
7. Quick Access Toolbar
8. Workbook and Worksheet
9. Status Bar
10. Navigation
11. Shortcut Menus and Mini Toolbar
12. New Workbook
13. Save and Save As

3 Working With Formula

14. Formula Bar
15. Creating Simple Formula
16. Copying a Formula
17. Calculating Year To Date Total
18. Percentage Change
19. Working With Functions under Formula

4 Formatting

20. Fonts
21. Row Height and Column Width
22. Font color and toggle button
23. Alignment and Text Wrapping
24. Borders
25. Numeric and Special Formatting
26. Formatting Date and Time
27. Conditional Formatting
28. Inserting Table
29. Shapes and Visual Effects
30. Smart Art

5 Adjusting Worksheet Layout

31. Inserting Rows and Columns
32. Shifting Rows and Columns
33. Hiding and Unhiding Rows and Columns
34. Copying and Moving Data

6 Printing

35. Print Preview
36. Page Layout
37. Final Print

7 Charts

38. Creating Charts
39. Changing Chart Types
40. Formatting Chart
41. Chart Design
42. Creating Spark lines

8 Worksheet Views

43. Freezing and Unfreezing Panes
44. Splitting Rows and Columns Horizontally and Vertically

9 Multiform Workbook and Worksheets

45. Renaming Worksheet
46. Inserting and Deleting Worksheet
47. Moving and Copying Worksheet

10 IF Function

48. IF Function

11 Vlookup

49. Vlookup

12 Security and Protection

50. Locking and Protecting Data
51. Protecting Worksheet Part 1
52. Protecting Worksheet Part 2

13 Sharing

53. Sharing Workbooks

14 Data Management

54. Sorting Data
55. Calculating Sub-Total
56. Filtering Data
57. Splitting Data Into Different Columns
58. Removing Duplicates

15 Data Analysis

59. Goal Seek
60. Scenario Manager
61. Data Table

16 Pivot Table

62. Creating A New Pivot Table
63. Manipulation of pivot table
64. Grouping Data by Date and Time
65. Filtering Data
66. Slicer
67. Pivot Chart

17 Macros

68. Using Macros

18 Conclusion

69. Conclusion

19 Bonus Material

70. Sorting Data
71. Sub-total
72. Goal Seek
73. Scenario manager
74. Pivot table
75. Macros

20 Additional Content: Grand Finale

76. Bonus Lectures. Enjoy the Benefits

You could also end up using these skills in your work for Your #Clients, and much more.

You’ll Also Get:

* Lifetime Access to course updates

So wait no more! Learn Excel, increase your knowledge, become an Excel Expert and advance your career all in a fun and practical way!

WE’D LOVE TO SEE YOU INSIDE AND HELP YOU MASTER EXCEL the Right Way!

Pls leave your much-valued Review.

Funny Passport Holder for Kids eco leather cover for documents for Boys birthday gifts idea Stylish designer case

(22)

$12.89 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Monogrammed Custom Leather Passport Cover. 9 Designs and 5 Colors. Personalized Passport Holder With Name, for Women and Men, Travel Gift, Gift For Him, Her, Spouse, Honeymoon. Engraved Passport

(29)

$21.99 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

PEGAI Personalized Leather Passport Holder Cover Wallet Travel Essentials | 100% Soft Touch Rustic Travel Wallet Case, International Travel Must Haves | DeKalb (Rock Gray)

(358)

$25.58 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Black Girl Braids Passport Holder and Luggage Tag, Travel Accessories, Travel Gift Set Custom Passport and Tags (Passport Holder)

(9)

$22.99 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Personalized Passport Holder, Handmade Travel Wallet, Passport Cover with Card and Ticket Slot, Genuine Leather, Passport Case, Wallet for Passports

(1)

$12.99 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

PEGAI Personalized Leather Passport Holder Cover Wallet Travel Essentials | 100% Soft Touch Rustic Travel Wallet Case, International Travel Must Haves | DeKalb (Sand Brown)

(358)

$25.58 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Passport Holder, Passport Cover OR Luggage Tag | Marie Kitty & Kittens 4 designs

(4)

$8.49 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Personalized Natural Leather Luxury Passport Holder Book • Custom Travel Wallet with Name Monogram Initials • Unisex Brown Leather Passport Sleeve for Men (Passport Holder)

(15)

$33.00 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Genuine Leather Personalized Passport Holder, Engraved with Monogram or Initials, Travel Wallet, Father's Day Gift, Christmas gift for Travel lovers (Luggage Tag)

(15)

$28.00 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Personalized Leather Passport Cover, Customized Travel Wallet, Genuine Leather Passport Cover, Custom Laser Engraved Passport holder, Passport Wallets

$12.99 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Bag Organizer for Loewe Puzzle Small Insert - Premium Felt (Handmade/20 Colors)

(3)

$35.00 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Keepall Bag Organizer for Lv Keepall 50 Insert Keepall 45 Organizer Base Shaper Handmade 3mm Premium Felt Snug Sturdy (Keepall 55, Lilac)

(32)

$39.00 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Divitize Premium Bag Organizer for Nice bb Organizer Insert, Handmade Liner Protector Fits Nice Mini Vanity PM Organizer, Nice Makeup Bag Felt Snug Sturdy Fit (Nice BB, Beige)

(1)

$35.00 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Divitize Premium Bag Organizer for Nice bb Organizer Insert, Handmade Liner Protector Fits Nice Mini Vanity PM Organizer, Nice Makeup Bag Felt Snug Sturdy Fit (Nice BB, Beige)

(6)

$35.00 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Keepall Bag Organizer for Lv Keepall 50 Insert Keepall 45 Organizer Base Shaper Handmade 3mm Premium Felt Snug Sturdy (Keepall 45, Lilac)

(32)

$39.00 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Personalized Leather Wallet for Men, Fathers Day Gifts for Him, Custom Name Wallets, Customazible Gift for Husband, Dad, Boyfriend, Him, Men Gifts for Anniversary, Birthday, Wedding, Fathers Day

(262)

$22.50 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Zoomoni Nice BB Bag Insert Organizer - Premium Felt (Handmade/20 Colors)

(15)

$39.00 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Personalized Leather Brown CHECKBOOK COVER/Leather Check Cover/Monogrammed Gift For Him or Her/Monogram Initials

(8)

$29.50 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Divitize Purse Organizer for Artois MM Bag Organizer, Artois PM Bag Organizer, Artois MM Insert, Handmade 2mm Wool Premium Felt Insert with Silver Zipper Snug Sturdy Fit (For Artois MM, Beige)

(16)

$35.00 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Divitize Premium Purse Organizer for Mini Anjou Bag Organizer Insert, fits Anjou PM Organizer, Anjou GM Insert, Handmade 2mm Thick Oval Shaped Felt Snug Sturdy Silver Zipper (For Anjou Mini, Red)

(3)

$35.00 (as of November 14, 2024 01:52 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Personalized Backpack for Girls Boys, Baby Toddler Backpack, Preppy Backpack, Back to School Nursery Backpack, Preschool Kids Bookbag, Daycare Bag, Xmas Birthday Gift, Chenille Letter Name, 10x5x13"

(17)

$21.99 (as of November 13, 2024 01:49 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Personalized Firefighter Ripstop Duffel Bag, Custom Firefighter Duffle Bag for the Brave On-The-Go Waterproof Large Gear Storage Bag, Firefighter Gear Bag with Shoulder Strap (Style 1)

$68.96 (as of November 13, 2024 01:49 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Personalized Kids Dance Ballet Bag, Kids Chenille Letter Duffel Bag, Sport Duffle Bag, Travel Duffel Bag, Pink Cheerleader Bag for Girls, Dance Duffle Bag, Special Performance Reward Gift for Children

(8)

$28.99 (as of November 13, 2024 01:49 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

ROSLILY Personalized Backpacks for Girls Back To School Backpack Kids Custom Backpack With Name Patch Nylon School Backpack Gifts for Boys Toddles Students Birthday Christmas

(21)

$23.88 (as of November 13, 2024 01:49 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Personalized Kids Dance Ballet Bag Large Capacity Fashion Tote with Keychain Bag Custom Dance Bag Adjustable Waterproof Kids Travel Bag Pink Lace Bag for Little Girls Yoga Bag Dance Duffle Bag

(58)

$22.99 (as of November 13, 2024 01:49 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Leather Fanny Pack Crossbody Bags for Women Trendy Sling Bag for Women Small Crossbody Bags for Women Vacation Essentials Handbags Crossbody Purse Belt Bag Travel Backpack (Black)

(135)

$29.99 (as of November 13, 2024 01:49 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Teacher Crayons Personalized Zippered Tote Bag

(189)

$32.99 (as of November 13, 2024 01:49 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Personalized Duffle Bag, Custom Embroidered Bag with Wet Dry Pockets & Shoe Compartment for Women/Men for Sports Dance Gym Travel Weekender Overnight Bridesmaid Gift School Business Men Sport

(2)

$16.99 (as of November 13, 2024 01:49 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Cross stitch grime guard qsnap 11x11 cross stitch accessories grime guard for cross stitch easy secrets of embroidery 11x11 grime guards for cross stitchers

(28)

$19.90 (as of November 13, 2024 01:49 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

25 Personalized Memorial Service Ribbons for Funeral Celebration of Life Custom Made Awareness Remembrance Anniversary Death Cross Sympathy In Loving Memory Angel - Custom Made Assembled Bows

(79)

$24.99 (as of November 13, 2024 01:49 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)