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.

Personalized Leather Passport Cover Holder and Luggage Tag Set for Women with Flower Birth and Name, Custom Engraved Passport Cover Suitcase Tag with Name | Chestnut

$24.95 (as of December 17, 2024 00:46 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 (Rock Grey)

(268)

(as of December 17, 2024 00:46 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 (Rose Red)

(361)

$31.98 (as of December 17, 2024 00:46 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 Full Grain Leather Passport Cover Field Notes Cover Wallet, Gift for Traveler, Passport Case, Gift for Him or her, Gift for Couple Unique

(46)

$15.99 (as of December 17, 2024 00:46 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)

(as of December 17, 2024 00:46 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/Cover OR Luggage Tag | Balloon House | Adventure is out there!

(13)

$8.49 (as of December 17, 2024 00:46 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 | Burgundy

$24.95 (as of December 17, 2024 00:46 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 (Dexios Black)

(268)

$42.97 (as of December 17, 2024 00:46 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)

(361)

$31.98 (as of December 17, 2024 00:46 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/Cover "My Adventure Book" | Luggage Tag "My Adventure Bag"

(14)

$8.49 (as of December 17, 2024 00:46 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 Premium Bag Organizer for Louis Vuitton Nice BB (Insert/Liner/Organiser/Shaper) - Premium Felt (Handmade)

(2)

$45.95 (as of December 17, 2024 00:41 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 December 17, 2024 00:41 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)

(2)

$36.00 (as of December 17, 2024 00:41 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 PM, Beige)

(16)

$35.00 (as of December 17, 2024 00:41 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 50, Olive)

(13)

$39.00 (as of December 17, 2024 00:41 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 December 17, 2024 00:41 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, Green)

(3)

$35.00 (as of December 17, 2024 00:41 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 Organizer fits Chloe Woody Tote Insert, Handmade Double Layered Felt Shaper for Medium Woody Tote Bag Organizer Insert 2mm Thick (For Medium Woody, Tea)

(2)

$35.00 (as of December 17, 2024 00:41 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 December 17, 2024 00:41 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 Insert fits Book Tote Organizer Medium, Small Book Tote Organizer Insert Best Fit Detailed Size, Large Book Tote Bag Organizer Premium Felt Handmade (For Large Book Tote, Beige)

(28)

$35.00 (as of December 17, 2024 00:41 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 (Ivory Personalized)

(141)

$35.00 (as of December 17, 2024 00:46 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 Nursing is a Work of Heart, RN, LPN, CNA, CMA Tote Bag with Mesh Pockets

(101)

$32.99 (as of December 17, 2024 00:46 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 Dance Ballet Bag for Girls, Customized Cute Tote Bag Dance Bag with Name Tag and Decorate, Custom Toddler Dance Bag Gymnastics Bag Yoga Bag Duffle Bag, Gifts for Christmas Ballerina Kids

(4)

$14.99 (as of December 17, 2024 00:46 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)

(141)

$29.99 (as of December 17, 2024 00:46 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.)

StinkBalm Odor Blocker Survival Kit 2 Pack

(142)

$16.99 (as of December 17, 2024 00:46 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.)

Travel Tokens Personalized

(8)

(as of December 17, 2024 00:46 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 Bags for Men - Expandable Canvas Duffle Bag for Travel - Mens Overnight Bag or Weekender Bag with Shoe Compartment - Carry-On Duffel Bag for Short Trip, Gym & Camping (brown)

$59.99 (as of December 17, 2024 00:46 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.)

StinkBalm Odor Blocker New Grad Gift Set 2 Pack

(8)

(as of December 17, 2024 00:46 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

(22)

$23.88 (as of December 17, 2024 00:46 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.)

CraffBase Personalized Name Dance Duffle Bags for Girls Dance Ballet Bag, Cute Travel Duffel Bag, Sport Duffle Gym Cheerleader Bag, Custom Chenille Letter Name Girls Boys Kids (Style 1)

(2)

$18.66 (as of December 17, 2024 00:46 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.)