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

Become an Σxpert at Σ


Table of Contents


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

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

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
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
36.Conditional Formatting
38.Pivot Tables
40.Lookup a Value from a table of data (VLookup)

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

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

53.Random Idea Creator
54.James Altucher Idea Muscle

55.Brute Force Statistics

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

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