By using expertatexcel.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

Become an Σxpert at Σxcel.com

 


Table of Contents

Introduction

1-Health Related
1.Help you Lose Weight
2.Help you do a million push-ups
3.Help you exercise
4.Blood Sugar Tracking
5.Calorie Tracking

2-Make Money
6.Help beat the stock market
7.Make 6 figure Salary
8.Excel Helped me Write a Book
9.Run a Business
10.Help you understand bitcoin

3-Web/Internet
11.Create Dynamic Web Pages via ASP which is VBA

4-Save Time
12.I got 60,000 followers on Twitter using Excel
13.Tracking your Time Every 15 Minutes
14.Takeaways
15.Create PowerPoint Slides
16.Logger window (shortcuts)
17.Dont Lose Your Work
18.User Defined Functions
19.Delete Rows on complex condition
20.Create a Questionnaire
21.Shortcut key to Google cell contents
22.Don't lose access

5-Tracking
23.Party Planning
24.Error Tracking

6-Business Usage of Excel
25.Create a file that Reports Top Counterparties to Regulators
26.Trader Analyzer
27.Monitor for an Event

7-Succeed at Work
28.Questionnaire
29.Analyze Data
30.Improved Job Security

8-Learning New Topics
31.Book Summaries
32.Learn about Bitcoin
33.Learn to Automate Excel with Macros aka VBA

9-Excel out of the Box
34.Formatting
35.Formulas
36.Conditional Formatting
37.Functions
38.Pivot Tables
39.Charts
40.Lookup a Value from a table of data (VLookup)
41.Sorting

10-Excel Tools
42.Reduce the Size of an Excel file aka Workbook
43.Examine all Excel files on your computer
44.Find Data

11-File processing
45.Get the file name from the full path name
46.Create Directories
47.Create a file
48.Get Data from External Source
49.Send Data to external source
50.Count files in a directory

12-Simulation
51.Identify Black Jack probabilities via simulation
52.Excel - Baseball Simulator

13-Creativity
53.Random Idea Creator
54.James Altucher Idea Muscle

14-Miscellaneous
55.Brute Force Statistics

15-Database
56.Create Insert Query from column data

16-Controlling Other Applications
57.Open Websites or Run Programs
58.Control PowerPoint
59.Control Word
60.Control Outlook
Top
   


Home | Excel Syntax Checker | About | Videos | Feedback | @alecberg | websites | FAQ | Memes | Thanks | Copyright © 2021 All Rights Reserved. Edit