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.

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

(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.)

Leather passport holder - Personalized passport cover and luggage tag set for women and men - Awesome gift for travelers.

(12)

$20.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.)

PEGAI Personalized Leather, Passport Holder For Travel | Handmade Passport Wallet Cover Case | Travel Document Holder, Passport Cover for Men, Women, and Family | Pike (Charcoal Black)

(262)

$34.38 (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 Holder and Luggage Tag Set for Women with Flower Birth and Name, Custom Engraved Passport Cover Suitcase Tag with Name | Teal

$24.95 (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.)

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

(54)

$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 For Travel | Handmade Passport Wallet Cover Case | Travel Document Holder, Passport Cover for Men, Women, and Family | Pike (Cognac)

(262)

$34.38 (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 For Travel | Handmade Passport Wallet Cover Case | Travel Document Holder, Passport Cover for Men, Women, and Family | Pike (Cinnamon Brown)

(262)

$34.38 (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 Genuine Leather Journal, Travel Gift, Refillable Leather Notebook, Handmade Nature Journal, Hike Journal, Cabin Journal

(63)

$57.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.)

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.)

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.)

Divitize Premium Bag Organizer fits St louis GM Bag Organizer and St Louis PM Tote Bag Insert, Handmade 2mm Wool Double Layered Base Felt, Snug Sturdy Fit with Silver Zipper (For St Louis GM, Beige)

(10)

$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.)

Coupon Organizer Receipt Holder Purse Organizer

(83)

$18.95 (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.)

Divitize Premium Purse Organizer compatible with Rive Gauche Tote Bag Organizer, Handmade 2mm Thick Felt Insert with Silver Zipper, Perfect Snug Sturdy Fit (For Large Rive Gauche N/S, Cream)

(8)

$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 Wool Felt Snug Sturdy (Keepall 55, Lilac)

(13)

$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 Wallet for Men - Top Grain Leather Wallet with Engraved Name & initial -Custom in 5 Colors & 6 Designs- Ideal Gift for Husband, Groomsman, Son, Boyfriend, Anniversaries & Christmas- USA

(36)

$24.90 (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 fits Saint Louis PM Bag Organizer and St Louis GM Tote Bag Insert, Handmade 2mm Double Layered Oval Shaped Felt Snug Sturdy Silver Zipper (For St Louis PM, Beige)

(10)

$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.)

Birth Control Case Sleeve with Snap Closure and Optional Keychain Clip -Stitch on purple

(28)

$12.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.)

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.)

Grime guards cross stitch 11 x 11 grime guard for qsnap 11”×11” flowers cross stitch supplies q-snap frame floral embroidery accessories storage craft gift for stitcher

(42)

$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.)

Cedar, Patchouli and Vetiver (Solid Cologne) - Handcrafted with natural oils and butters, Vegan and alcohol-Free cologne

(3)

$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.)

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.)

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.)

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.)

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 Personalized)

(135)

$35.00 (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 Bag Custom Dance Bag Waterproof Kids Travel Bag Pink Lace Bag for Girls Yoga Bag Dance Duffle Bag

(58)

$18.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.)

Bergamot, Sea Salt and Amber (Solid Cologne) - Handcrafted with natural oils and butters, Vegan and alcohol-Free cologne

(12)

$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.)

The White Invite Gifts Leather Fanny Pack Crossbody Bags for Women Trendy Sling Bag for Women Small Crossbody Bags for Women Vacation Essentials Handbags Crossbody Purse Belt Bag (Nutmeg Personalized)

(135)

$35.00 (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 Purse for Little Girls Embroidered Toddler Crossbody Bag with Tassel Custom Kids Shoulder Bag Tassel Purse, Monogramed Children Purse

$16.98 (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.)